Message-Id: <10578.113729@fatcity.com> From: David Barbour Date: Thu, 3 Aug 2000 09:35:53 -0500 Subject: RE: locks? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFFD58.20DC4880 Content-Type: text/plain; charset="iso-8859-1" Check v$lock. You also might want to consider using utllockt.sql. There are some good ancilliary scripts for this available at: http://www.ixora.com.au/scripts/locks.htm Happy Hunting! David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 dbarbour@connectsouth.com -----Original Message----- From: Swapna_P [mailto:Swapna_P@satyam.com] Sent: Thursday, August 03, 2000 8:18 AM To: Multiple recipients of list ORACLE-L Subject: locks? how can i find out the locks existing on a table and by whom? rgds swapna ------_=_NextPart_001_01BFFD58.20DC4880 Content-Type: text/html; charset="iso-8859-1" locks?
Check v$lock.  You also might want to consider using utllockt.sql.  There are some good ancilliary scripts for this available at:
 
            http://www.ixora.com.au/scripts/locks.htm
 
Happy Hunting!
 

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour@connectsouth.com

-----Original Message-----
From: Swapna_P [mailto:Swapna_P@satyam.com]
Sent: Thursday, August 03, 2000 8:18 AM
To: Multiple recipients of list ORACLE-L
Subject: locks?

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