Checking and Adding Space to tablespace

To check the tablespace size in oracle


df.tablespace_name "Tablespace",

totalusedspace "Used MB",

(df.totalspace - tu.totalusedspace) "Free MB",

df.totalspace "Total MB",

 round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace)) "Pct. Free"


(select tablespace_name, round(sum(bytes) / 1048576) TotalSpace from           

 dba_data_files group by tablespace_name) df,

(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name from dba_segments group by tablespace_name) tu

where df.tablespace_name = tu.tablespace_name ;



To add space to the tablespace using ASM :


 alter tablespace USTTAX_DATA add datafile '+PROD_RB_DATA' size 10G;

 alter tablespace UTT_M2_DATA add datafile '+PROD_RB_DATA' size 10G;


To add space to the tablespace using regular filesystem :




Search Results

User login