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

mpammer_at_vlr.gv.at (Martin Pammer) wrote:

> Hi there.
>
> Oracle 7.2.2.4 on AIX
>
> 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.

HTH -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Chris Kasten
Programmer/Analyst (among others...)

#include <sys/std_disclaimer.h>
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Received on Fri Jan 12 1996 - 00:00:00 CET