REM manque une partie

and t.owner not in ('SYS','SYSTEM','DBAUTIL','OUTLN','DBSNMP','SPOTLIGHT','PERFSTAT','RMAN','IWATCH') and i.clustering_factor/decode(t.blocks,0,decode(i.clustering_factor,0,1,i.clustering_factor),t.blocks)>&&min_ratio
order by t.owner,i.clustering_factor/decode(t.blocks,0,decode(i.clustering_factor,0,1,i.clustering_factor),t.blocks) desc,t.table_name,i.index_name
/
spool off
set lines 80 pages 22 feedback on verify on
clear columns
ttitle off
