Re: latch wait - cache buffer chain

I don't think I can rebuild that index because it is partitioned.

thank you

Gene Gurevich

                                                                           
             "Thomas Day"                                                  
             <tomday2_at_gmail.co                                             
             m>                                                         To 
             Sent by:                  oracle-l_at_freelists.org              
             oracle-l-bounce_at_f                                          cc 
             reelists.org                                                  
                                                                   Subject 
                                       Re: latch wait - cache buffer chain 
             10/25/2006 08:40                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             tomday2_at_gmail.com                                             
                                                                           
                                                                           

Without know more about the detail, I would suggest alter index rebuild reverse. You might get lucky and the reverse could redistribute your data to eliminate the hot blocks.

Since you say "report" I am assuming that you are doing read only.

--
http://www.freelists.org/webpage/oracle-l