gc buffer busy from the same instance??

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Fri, 8 May 2009 12:10:54 -0700 (PDT)
Message-ID: <e614be64-1e0f-4cae-84e7-420eddf24a79_at_s16g2000vbp.googlegroups.com>

Hi All, EE on SLES 10

We have seen fairly significant waits recently on this during a large load recently. We know which query is causing it and are submitting a fix, but my question is the following:

When I select from gv$session, I see session x on instance 2 waiting on "db file sequential read" for a given file and block number. I see session y, also on instance 2, waiting on "gc buffer busy" for the same file and block. These are the only two sessions going after this block.

I can understand (and would expect) this if session y was on instance 3, or whatever. However, since both sessions are on the same instance, why is this not either recorded as "read by other session" or "buffer busy waits" event?


Steve Received on Fri May 08 2009 - 14:10:54 CDT

Original text of this message