Oracle 11g tablespace usage

在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檔案中的內容.