Re: Debugging a buffer busy waits

From: <>
Date: Sat, 28 Mar 2009 12:13:06 -0700 (PDT)
Message-ID: <>

On Mar 28, 1:30 pm, Ste <> wrote:
> Hi all,
> Last day I've encountered a problem with a procedure waiting due to a
> buffer busy waits. In v$session_wait I've found FILE# and BLOCK#.
> Looking in DBA_SEGMENTS I've discovered incriminated blocks is belonging
> to a table called 'DUMMYTBL'.
> Ok, now I can discover which other SIDs are using this table?
> P3 code is 130 meaning no suitable images are found of this block.
> Deadlock are not signalled in alert.log.
> Thanks
> Ste

Why don't you look for SQL in your database instance that is going after DUMMYTBL? Received on Sat Mar 28 2009 - 14:13:06 CDT

Original text of this message