Re: How many people here rebuid index regularly?

In article <DPadnWQ-lar_XZva4p2dnAA_at_bt.com>, jonathan_at_jlcomp.demon.co.uk says...
>
> <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.
>

Thanks for the advice, Jonathan. No, David, I never did a treedump in my life.

Hmm.. If there is interest here, I could try to collect data from an actual production site, before and after a rebuild.

Which data would you (collective) want to see ?

Keep in mind that this would be from a customer production site. Therefore,

• Nothing destructive, please
• Collected data take a reasonable amount of space
• Collection takes at most ten minutes or so, preferably non blocking
• You'll see changes induced by a one day activity (night job + daily activity)

Best regards, everybody

• Raoul