How many people here rebuid index regularly? - comp.databases.oracle.server

Message from discussion How many people here rebuid index regularly?

Jonathan Lewis

View profile

More options 5 Oct 2007, 23:53

Newsgroups: comp.databases.oracle.server

From: "Jonathan Lewis" <jonat...@jlcomp.demon.co.uk>

Date: Fri, 5 Oct 2007 23:53:16 +0100

Local: Fri 5 Oct 2007 23:53

Subject: Re: How many people here rebuid index regularly?

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

<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

Reply to author Forward