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

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.

For example select * from v$lock; gives me following result

ADDR KADDR SID TY ID1 ID2 LMODE REQUEST

401CFF68 401CFF7C 7 TM 1239 0 3 0 401E86B8 401E874C 7 TX 262209 71 6 0

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

Best regards

Martin Pammer VRZ Informatik, Dornbirn (Austria) email: mpammer_at_vlr.gv.at Received on Fri Jan 12 1996 - 00:00:00 CET