查找表碎片sql

--判断表高水位（超过20%)

select  round((1-a.used/b.num_total)*100,0)  percent from
(SELECT COUNT (DISTINCT SUBSTR(rowid,1,15)) Used FROM 所有者.表名) a,
(select blocks num_total from dba_tables where table_name='表名' AND owner='所有者') b;