查看数据库表空间大小，剩余空间，剩余空间百分比！

select (ddf.tsname) "TABLESPACE NAME",(ddf.alls||'M') "SIZE",trunc(dfs.frees) "FREE SIZE",trunc(dfs.frees/ddf.alls*100) "%" from (select tablespace_name tsname,sum(bytes/1024/1024) alls from dba_data_files group by tablespace_name) ddf,(select tablespace_name tsname,sum(bytes/1024/1024) frees from dba_free_space group by tablespace_name) dfs where ddf.tsname = dfs.tsname order by "%" asc;

[@more@]cha

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10685580/viewspace-1046917/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10685580/viewspace-1046917/