查询DM8数据库表空间使用率

SELECT
    TABLESPACE_NAME AS 表空间名,
    ROUND(SUM(TOTAL_SIZE) / 1024.0 / 1024.0, 2) AS "总大小(MB)",
    ROUND(SUM(USED_SIZE)/ 1024.0 / 1024.0, 2) AS "已使用大小(MB)",
    CAST(ROUND(SUM(USED_SIZE) * 1.0 / SUM(TOTAL_SIZE) * 100, 2) AS VARCHAR) || '%' AS 使用率
FROM (
    SELECT
        UPPER(T1.TABLESPACE_NAME) AS TABLESPACE_NAME,
        T1.BYTES AS TOTAL_SIZE,
        T1.BYTES - T2.BYTES AS USED_SIZE
    FROM DBA_DATA_FILES T1, DBA_FREE_SPACE T2
    WHERE T1.TABLESPACE_NAME = T2.TABLESPACE_NAME AND T1.FILE_ID = T2.FILE_ID
)
GROUP BY TABLESPACE_NAME;