Re: How to get the 'SQL query' which is blocking rows

From: <phil_herring_at_yahoo.com.au>
Date: Fri, 9 Jan 2009 14:13:09 -0800 (PST)
Message-ID: <1d69adbd-1047-4ffe-940c-665a6927acb6_at_a29g2000pra.googlegroups.com>



Your options are very limited. The statement that created the blocking lock may have occurred any time between when the DB was started and now; it may not even be in the SQL cache.

It is possible to dump the open cursors for the blocking session, which will give you more information. Despite the name, v$open_cursor also contains cursors that have been closed, so the problem SQL may still be there. You can also get some of the bind variables from the SGA, which may also help run down which specific row/s is/are affected.

  • Phil
Received on Fri Jan 09 2009 - 16:13:09 CST

Original text of this message