-
select f.tablespace_name,
-
a.total "total (M)",
-
f.free "free (M)",
-
round((f.free / a.total) * 100) "% Free"
-
from (select tablespace_name, sum(bytes / (1024 * 1024)) total
-
from dba_data_files
-
group by tablespace_name) a,
-
(select tablespace_name, round(sum(bytes / (1024 * 1024))) free
-
from dba_free_space
-
group by tablespace_name) f
-
where a.tablespace_name = f.tablespace_name(+)
- order by "% Free";
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28878983/viewspace-2137115/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
