select t.tablespace_name "表空间名称",t.full_space "总的 M",(t.full_space-nvl(f.free_space,0)) "使用 M",f.free_space "剩余 M",to_char(round((t.full_space-nvl(f.free_space,0))/t.full_space*100,1),'fm999990.99999')||'%' "使用率"from (select tablespace_name,round(sum(bytes)/(1024*1024),2) free_space from dba_free_space group by tablespace_name) f ,
(select tablespace_name,round(sum(bytes)/(1024*1024),2) full_space from dba_data_files group by tablespace_name) t where f.tablespace_name=t.tablespace_name(+)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29065182/viewspace-1629541/,如需转载,请注明出处,否则将追究法律责任。