查询表空间碎片

2440阅读 0评论2018-06-04 roobbin
分类:Oracle

select a.tablespace_name,sqrt(max(a.blocks)/sum(a.blocks))*(100/sqrt(sqrt(count(a.blocks)))) FSFI
from dba_free_space a,dba_tablespaces b where a.TABLESPACE_NAME=b.TABLESPACE_NAME and b.contents not in ('TEMPRARY','UNDO') group by
a.tablespace_name order by 2;
上一篇:system登录时提示ora-01031?
下一篇:linux下sql命令行记录执行命令工具与设置