ORACLE表空间使用量查询SQL

SELECT Upper(F.TABLESPACE_NAME) AS 表空间名
     , round(D.TOT_GROOTTE_MB / 1024, 2) AS "总大小(G)"
     , round((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / 1024, 2) AS "已使用空间(G)"
     , round(F.TOTAL_BYTES / 1024, 2) AS "空闲空间(G)"
     , Round((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_MB, 4) * 100 AS "已使用占最大比例(%)"
 FROM (
     SELECT TABLESPACE_NAME
         , Round(SUM(BYTES) / (1024 * 1024), 2) AS TOTAL_BYTES
         , Round(MAX(BYTES) / (1024 * 1024), 2) AS MAX_BYTES
     FROM SYS.DBA_FREE_SPACE
     GROUP BY TABLESPACE_NAME
 ) F, (
         SELECT tablespace_name
             , Round(SUM(BYTES) / (1024 * 1024), 2) AS TOT_GROOTTE_MB
             , Round(SUM(maxbytes) / (1024 * 1024), 2) AS TOT_MB
         FROM (
             SELECT file_id, tablespace_name, bytes
                 , CASE 
                     WHEN autoextensible = 'NO' THEN bytes
                     ELSE maxbytes
                 END AS maxbytes
             FROM dba_data_files
         )
         GROUP BY tablespace_name
     ) D
 WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME