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.>