Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Proving or Debunking the need for rebuilding
hpuxrac wrote :
> hasta_l3_at_hotmail.com wrote:
> > I checked exactly this last month. In retrospect, I would use
> > this methodology :
> >
> > 1. Setup a load test environment duplicating system activity
> > 2. Let the system run for 15 days, without index rebuild.
> > 3. Time a small representative set of transactions, including
> > - Most common querying user action(s)
> > - Most common updating user action(s)
> > - Nightly batch jobs
> > 4. Rebuild all indexes
> > 5. Time again
> > 6. Run one week with nightly rebuilds
> > 7. Time again
> > 8. Believe your data
>
> What conclusions did you reach based on your approach?
On my system - and I stress : on my system
Unfortunatly, I didnt time update actions, not did I check the rate of redo log switches, nor did I compare the size of indexes.
9.2.0.5