查看oracle資料表空間使用方式____oracle

dba_free_space:描述資料空間的剩餘大小

dba_data_file:描述資料資料表空間的總大小

 

select a.tablespace_name, a.bytes bytes_used, b.largest,round(((a.bytes-b.bytes)/a.bytes)*100,2) percent_used from (select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a , (select tablespace_name , sum(bytes) bytes ,max(bytes) largest from dba_free_space group by tablespace_name) b where a.tablespace_name = b.tablespace_name

Order by ((a.bytes - b.bytes)/a.bytes) DESC;

 

 

當發現資料表空間超過80%則需要擴大資料表空間:

alert tablespace .... add datafile