comp.databases.oracle.server

Re: How many people here rebuid index regularly?

Jonathan Lewis <jonat...@jlcomp.demon.co.uk>

<fitzjarr...@cox.net> wrote in message

news:1191612916.550302.168250@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