Re: Q: How do I find the SQL-Statement that is causing a lock

>> I would like to track down which SQL Statement is causing an entry in
>> the V$LOCK Table.

<example snipped>

>>
>> Is there a way for me to find out which SQL Statement caused these
>> rows in v$lock to show up ?

>You can get SQL_ADDRESS from v$session (using SID from v$lock) and
>join it to ADDRESS inm v$SQLAREA.

If I'm not mistaken - the sql statement you find using this method is not guaranteed to be the locking statement - it is only the most recent sql statement for the SID in question.

Paul Kelley Received on Sat Jan 13 1996 - 00:00:00 CET