Re: How many people here rebuid index regularly?

<fitzjarrell_at_cox.net> wrote in message
news:1191612916.550302.168250_at_57g2000hsv.googlegroups.com...
> I realise this would take time, but have you considered a treedump of
> the indexes before and after the rebuild:
>
> alter session set evnts = 'immediate trace name treedump level <index
> object id>';
>

Test this one on a small index before trying it on a large index. On some versions of Oracle it does a full dump of all leaf blocks, rather than one line per block.

Remember, it reads the index one block at a time anyway, so it can be very slow even when it doesn't to a full dump.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html