Re: Very high buffer gets

High-water mark of death? If you have recently had some service interruption and requests have accumulated into the queue, it might be an explanation.

Stephane Faroult

Nahata, Naveen (US - Glen Mills) wrote:

Hi All,

After tracing the QMON process which was doing lots of buffer gets, I
found this culprit. None of the three tables involved in the query have
more than 2 blocks. I know the nested loop is iterating over the blocks
but that should still not account for more than 200 blocks / execution.
Why do I see such high values for buffer gets? 





--
http://www.freelists.org/webpage/oracle-l


Other related posts: