表空间使用率

 

spool c:\data.txt

SELECT a.tablespace_name "表空間名",
       total/1024/1024 "表空間大小",
       free/1024/1024 "表空間剩余大小",
       (total - free)/1024/1024 "表空間使用大小",
       ROUND ( (total - free) / total, 4) * 100 "使用率%"
  FROM (  SELECT tablespace_name, SUM (bytes) free
            FROM DBA_FREE_SPACE
        GROUP BY tablespace_name) a,
       (  SELECT tablespace_name, SUM (bytes) total
            FROM DBA_DATA_FILES
        GROUP BY tablespace_name) b
 WHERE a.tablespace_name = b.tablespace_name;

 spool off