Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Proving or Debunking the need for rebuilding

Re: Proving or Debunking the need for rebuilding

From: <hasta_l3_at_hotmail.com>
Date: 13 Nov 2006 22:24:43 -0800
Message-ID: <1163485482.971252.200030@f16g2000cwb.googlegroups.com>


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

Received on Tue Nov 14 2006 - 00:24:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US