csn233_at_gmail.com wrote:
>
>> 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>';
>>
>> You should see considerable differences in the dump files for a given
>> index if the rebuild of it improves performance. And those file pairs
>> with differences would indicate the indexes upon which you should
>> concentrate your rebuild efforts.
>
> Comparing index sizes before and after rebuild would probably reveal
> all there is to know.
Probably not. I wouldn't indicate that a huge waste of time and
resources had just taken place which is what would be the end-result
the majority of the time.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sat Oct 06 2007 - 02:35:50 CDT
