Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How many people here rebuid index regularly?
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
![]() |
![]() |