OracleDBA之路之Tabespace(六)

查看表空间使用情况

select a.tablespace_name,total,free,total-free used from 
  (select tablespace_name,sum(bytes)/1024/1024 total from dba_data_files group by tablespace_name) a, 
   (select tablespace_name,sum(bytes)/1024/1024 free from dba_free_space 
       group by tablespace_name) b 
   where a.tablespace_name=b.tablespace_name;