Re: How to find the exact SQL locking others?

"You can't" is the correct generic answer.
There is no guaranteed link between the locked row(s) and the statement. In fact, as the following link shows
http://jonathanlewis.wordpress.com/2009/04/19/locking-sql/ , the statement need not be in memory even though the rows are still locked.

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543

• Original Message ----- From: "Powell, Mark" <mark.powell2_at_hp.com> To: "oracle_l" <Oracle-L_at_freelists.org> Sent: Monday, July 02, 2012 5:51 PM Subject: RE: How to find the exact SQL locking others?

"You can't" is the answer I have seen Oracle support post on this question
in the past. However because the statement is uncommitted I would expect that the cursor will be listed in v$open_cursor for the blocking session. You just have to manually try to determine which open cursor is the one of interest.

--
http://www.freelists.org/webpage/oracle-l