Re: Holder query in lock

> 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

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