Monday, September 15, 2008

Get chained rows percentage

select owner,table_name,to_char((chain_cnt/num_rows)*100,'99.99') pct_chained
from all_tables
where num_rows > 0
and owner not in ('SYS','SYSTEM','OUTLN')
order by to_char((chain_cnt/num_rows)*100,'99.99') desc

0 Comments:

Post a Comment

<< Home