查询表空间碎片

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;