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.

Other related posts: