select a.tablespace_name,a.bytes/1024/1024 bytes_used,b.largest/1024/1024,
round(((a.bytes-b.bytes)/a.bytes)*100,2) percent_used
from
(select tablespace_name,sum(bytes) bytes from dba_data_files
group by tablespace_name) a,
(select tablespace_name,sum(bytes) bytes,max(bytes) largest
from dba_free_space group by tablespace_name) b
where a.tablespace_name=b.tablespace_name
ORDER by ((a.bytes-b.bytes)/a.bytes) DESC;
服务器空间使用情况,空间使用情况
最新推荐文章于 2023-12-26 11:49:25 发布