Question: How do I find the top
indexes by size in Oracle? I want to find the ten top
Answer: The following script will
find the top indexes by size:
segment_type = 'INDEX'
rownum <= 10;
Also see my notes on the
top tables by size.