Adding the space to tablespace

Adding the space to tablespace:
===============================

Step 1: Check the space utilization

select a.tbl "Name",a.tsz "Total Size",b.fsz "Free Space",
round((1-(b.fsz/a.tsz))*100) "Pct Used",round((b.fsz/a.tsz)*100) "Pct Free" from
(select tablespace_name tbl,sum(bytes)/1024/1024 TSZ from dba_data_files
where tablespace_name ='MTHLY_DM_DATA' group by tablespace_name) a,
(select tablespace_name tblsp,sum(bytes)/1024/1024 FSZ from dba_free_space
where tablespace_name ='MTHLY_DM_DATA' group by tablespace_name) b
Where a.tbl=b.tblsp;

Step 2: Check the size of the tablespace;


col file_name for a55
select file_name,BYTES/1024/1024 from dba_data_files where tablespace_name ='MTHLY_DM_DATA' order by file_name;


Step 3: Add the space to tablespace:

1.

alter tablespace MTHLY_DM_DATA add datafile '/db031/oradata/BAPROD/mthly_dm_data_11.dbf' size 5120M;

2. ALTER DATABASE DATAFILE '/u02/oradata/ENGAGPRD/eng_data1.dbf' RESIZE 4608M;


3. ASM

ALTER TABLESPACE "IONBOARD" ADD DATAFILE '+DATADG' SIZE 31457280K REUSE AUTOEXTEND ON NEXT 1024M MAXSIZE 32767M;