select df.tablespace_name "表空间名",totalspace "总空间M",freespace "剩余空间M",round((1-freespace/totalspace)*100,2) "使用率%"
from
(select tablespace_name,round(sum(bytes)/1024/1024) totalspace
from dba_data_files
group by tablespace_name) df,
(select tablespace_name,round(sum(bytes)/1024/1024) freespace
from dba_free_space
group by tablespace_name) fs
where df.tablespace_name=fs.tablespace_name;[@more@]
from
(select tablespace_name,round(sum(bytes)/1024/1024) totalspace
from dba_data_files
group by tablespace_name) df,
(select tablespace_name,round(sum(bytes)/1024/1024) freespace
from dba_free_space
group by tablespace_name) fs
where df.tablespace_name=fs.tablespace_name;[@more@]
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16396910/viewspace-1032442/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
C#操作Excel详解
下一篇：
漫谈C++ Builder多线程编程技术
请登录后发表评论
登录
全部评论
