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
[@more@]cha
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10685580/viewspace-1046917/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
ORACLE取整函数
请登录后发表评论
登录
全部评论
