Re: Holder query in lock
- From: "Yong Huang" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "yong321" for DMARC)
- To: Oracle-l Digest Users <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Sep 2016 13:37:22 +0000 (UTC)
But is there a simple way (without any trace) to discover to the
SQL_ID that locked the rows related to blocker lock?
This is a feature Oracle should have provided a long time ago because so many
people have asked for it. I filed a feature request. (For those who can see, it
is: "Severity 4 SR 3-12200129251 : Request for ID of SQL responsible for
transaction to be added to v$transaction") As far as I know, unless you trace
or audit the session from at least the point the transaction starts, or using
LogMiner (as Stefan and Dominic suggested), there's no reliable way to find the
initial DML SQL that creates the transaction. I have checked data dictionary
for any possible view that contains both SCN and SQL columns, and all events
related to transactions.
Yong Huang
--
//www.freelists.org/webpage/oracle-l
Other related posts: