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(+);
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博客 ” ，链接：https://blog.itpub.net/11411056/viewspace-734300/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
显示当前排序空间的SQL
请登录后发表评论
登录
全部评论
