表空间使用率

 

SELECT
    a.tablespace_name,
    round(a.total_size) "total_size(MB)",
    round(a.total_size) - round(b.free_size,3) "used_size(MB)",
    round(b.free_size,3) "free_size(MB)",
    round(b.free_size / total_size * 100,2)
    || '%' free_rate
FROM
    (
        SELECT
            tablespace_name,
            SUM(bytes) / 1024 / 1024 total_size
        FROM
            dba_data_files
        GROUP BY
            tablespace_name
    ) a,
    (
        SELECT
            tablespace_name,
            SUM(bytes) / 1024 / 1024 free_size
        FROM
            dba_free_space
        GROUP BY
            tablespace_name
    ) b
WHERE
    a.tablespace_name = b.tablespace_name (+) order by a.tablespace_name ;