Re: How many people here rebuid index regularly?

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

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html