在pl sql developer的preferences-->files-->directories-->command files添加文件sp.sp的内容如下：
set pagesize 100
set timing on
select x.tablespace_name,y.bytes/1024/1024 total_size_mb,x.bytes/1024/1024 free_size_mb,(y.bytes-x.bytes)/1024/1024 use_size_mb,round((y.bytes-x.bytes)/y.bytes,4)*100 usage
from
(select tablespace_name,sum(bytes) bytes from dba_free_space group by tablespace_name) x,
(select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) y
where x.tablespace_name=y.tablespace_name
order by 5 desc;
然后就可以执行@sp文件中的内容.

ITPub博客

Oracle 11g tablespace usage

最新文章