Message-Id: <10578.113778@fatcity.com> From: "Steve McClure" Date: Thu, 3 Aug 2000 12:09:55 -0700 Subject: Re: locks? This is a multi-part message in MIME format. ------=_NextPart_000_03D1_01BFFD43.BCAF3B60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable locks?column username format A10 column name format A20 select s.username, l.session_id, l.name, l.mode_held from sys.dba_dml_locks l, v$session s where s.sid=3Dl.session_sid This is the script I use to identify locks. You also need to have the = catblock.sql script in the $ORACLE_HOME/rdbms/admin directory run prior = to using the above script. ----- Original Message -----=20 From: Swapna_P=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, August 03, 2000 6:18 AM Subject: locks? how can i find out the locks existing on a table and by whom?=20 rgds=20 swapna=20 ------=_NextPart_000_03D1_01BFFD43.BCAF3B60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable locks?
column username format A10
column name format A20
select s.username, l.session_id, = l.name,=20 l.mode_held
from sys.dba_dml_locks l, v$session = s
where = s.sid=3Dl.session_sid
 
This is the script I use to identify = locks. =20 You also need to have the catblock.sql script in the = $ORACLE_HOME/rdbms/admin=20 directory run prior to using the above script.
----- Original Message -----
From:=20 Swapna_P=20
To: Multiple recipients of list ORACLE-L =
Sent: Thursday, August 03, 2000 = 6:18=20 AM
Subject: locks?

how can i find out the locks = existing on a=20 table and by whom?
rgds=20
swapna =