Re: latch wait - cache buffer chain

From: <genegurevich_at_discoverfinancial.com>
Date: Wed, 25 Oct 2006 09:31:02 -0500
Message-ID: <OF3272F596.F49AE993-ON86257212.004FABB2-86257212.004FBD6F@discoverfinancial.com>

Thomas,

Yes, this is read only. Thanks for your suggestion

thank you

Gene Gurevich
Oracle Engineering
224-405-4079

                                                                           
             "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

Received on Wed Oct 25 2006 - 09:31:02 CDT