数据库表空间的使用率

   su - oracle
   export ORACLE_SID=inoc(数据库实例名)
   sqlplus / as sysdba; 
   column TABLESPACE_NAME format a30;

   SELECT 'RESULT=' || UPPER(F.TABLESPACE_NAME) as TABLESPACE_NAME,            D.MAXBYTES as MAXBYTES_MB,            D.TOT_GROOTTE_MB - F.TOTAL_BYTES as USED_MB,            ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.MAXBYTES * 100,2) as USED_PCT       FROM (SELECT TABLESPACE_NAME, ROUND(SUM(BYTES) / (1024 * 1024), 2) TOTAL_BYTES FROM SYS.DBA_FREE_SPACE GROUP BY TABLESPACE_NAME) F,            (SELECT DD.TABLESPACE_NAME, ROUND(SUM(DD.BYTES) / (1024 * 1024), 2) TOT_GROOTTE_MB,                    ROUND(SUM(decode(DD.AUTOEXTENSIBLE, 'YES', DD.Maxbytes, DD.Bytes)) / (1024 * 1024),2) MAXBYTES               FROM SYS.DBA_DATA_FILES DD GROUP BY DD.TABLESPACE_NAME) D      WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME ORDER BY USED_PCT DESC;