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: