Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: latch wait - cache buffer chain
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-lReceived on Wed Oct 25 2006 - 08:40:23 CDT
![]() |
![]() |