Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> LOCK STATEMENT

LOCK STATEMENT

From: William de Souza Alencar <walencar_at_br.oracle.com>
Date: Tue, 26 Oct 1999 16:23:09 -0200
Message-ID: <3815F18C.311A112D@br.oracle.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US