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: How many people here rebuid index regularly?

Re: How many people here rebuid index regularly?

From: Hasta <hasta_l3_at_hotmail.com>
Date: Fri, 5 Oct 2007 18:34:08 +0200
Message-ID: <MPG.217085ef485bbb60989692@news.dommel.be>


In article <RcudnXIKhJSqd5jaRVnyigA_at_bt.com>, jonathan_at_jlcomp.demon.co.uk says...
>
> "Hasta" <hasta_l3_at_hotmail.com> wrote in message
> news:MPG.216ffe82b29bfb0e98968f_at_news.dommel.be...
>
> >
> > We do rebuild indexes, because it was measured to improve
> > performance on our system (9i).
> >
> > See the thread "Proving or Debunking the need for rebuilding"
> > in this group for a report...
> >
> > http://groups.google.be/group/comp.databases.oracle.server/browse_thread
> > /thread/9579b57c3434d990/9e32aa3cf9282f81?
> > hl=fr&lnk=gst&q=+Proving+or+Debunking+the+need+for+rebuilding&rnum=1#
> > 9e32aa3cf9282f81
> >
> > --- Raoul
>
> Raoul,
>
> Did you ever find time to work out which indexes were
> particularly relevant to the massive change in the batch
> job, and what the difference was between the slow and
> the fast runs ?
>
> Running statspack at its default level 5 once per hour across
> the batch job might give you some useful information about
> the SQL with the biggest time change, and what made the
> time change - level 6 would allow you to check if this was
> due to plan changes, and level 7 might show you where the
> I/O changed most.
>
 

Your advice has been carefully saved, btw, Jonathan ;-) Received on Fri Oct 05 2007 - 11:34:08 CDT

Original text of this message

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