Re: How to find the exact SQL locking others?
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "oracle_l" <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 3 Jul 2012 22:03:48 +0100
"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@xxxxxx>
To: "oracle_l" <Oracle-L@xxxxxxxxxxxxx>
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
