Re: latch wait - cache buffer chain
- From: "Thomas Day" <tomday2@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 25 Oct 2006 09:40:23 -0400
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.
Other related posts: