oracle表空间使用情况查询

SELECT D.TABLESPACE_NAME as 表空间,
       SPACE "总空间大小(M)",
       BLOCKS as 总数据块,
       SPACE - NVL(FREE_SPACE,
                   0) "已使用(M)",
       ROUND((1 - NVL(FREE_SPACE,
                      0) / SPACE) * 100,
             2) "使用率(%)",
       FREE_SPACE "未使用(M)",
      
            ROUND(NVL(FREE_SPACE,
                 0) / SPACE * 100,
             2) "未使用率(%)"
FROM   (SELECT TABLESPACE_NAME,
               ROUND(SUM(BYTES) / (1024 * 1024),
                     2) SPACE,
               SUM(BLOCKS) BLOCKS
        FROM   DBA_DATA_FILES
        GROUP  BY TABLESPACE_NAME) D,
       (SELECT TABLESPACE_NAME,
               ROUND(SUM(BYTES) / (1024 * 1024),
                     2) FREE_SPACE
        FROM   DBA_FREE_SPACE
        GROUP  BY TABLESPACE_NAME) F
WHERE  D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)
UNION ALL
SELECT D.TABLESPACE_NAME as 表空间,
       SPACE "总空间大小(M)",
       BLOCKS as 总数据块,
       USED_SPACE "已使用(M)",
       ROUND(NVL(USED_SPACE,
                 0) / SPACE * 100,
             2) "使用率(%)",
       NVL(FREE_SPACE,
           0) "未使用(M)",
            ROUND(NVL(FREE_SPACE,
                 0) / SPACE * 100,
             2) "未使用率(%)"
FROM   (SELECT TABLESPACE_NAME,
               ROUND(SUM(BYTES) / (1024 * 1024),
                     2) SPACE,
               SUM(BLOCKS) BLOCKS
        FROM   DBA_TEMP_FILES
        GROUP  BY TABLESPACE_NAME) D,
       (SELECT TABLESPACE_NAME,
               ROUND(SUM(BYTES_USED) / (1024 * 1024),
                     2) USED_SPACE,
               ROUND(SUM(BYTES_FREE) / (1024 * 1024),
                     2) FREE_SPACE
        FROM   V$TEMP_SPACE_HEADER
        GROUP  BY TABLESPACE_NAME) F
WHERE  D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)