SELECT d.tablespace_name, SPACE sum_space,
SPACE - NVL (free_space, 0) used_space,
ROUND ((1 - NVL (free_space, 0) / SPACE) * 100, 2) used_rate,
free_space free_space
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(+);

ITPub博客

详细显示数据表空间的使用率与剩余空间的SQL

最新文章