Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> LOCK STATEMENT
Hi guys,
I´m using ORACLE8 and I´d like to find out which SQL STATEMENT is locking a TABLE on database.
Example, when some user instance "UPDATE EMP SET SAL = 10" a lock will be generated into V$LOCK.
How can I recover this statement from V$ TABLES ?
Thanks in advance,
WILL,
Received on Tue Oct 26 1999 - 13:23:09 CDT