Re: Very high buffer gets

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: nnahata@xxxxxxxxxxxx
  • Date: Mon, 13 Feb 2006 18:11:11 +0100

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?


Other related posts: