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