RE: locks?

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Thu, 3 Aug 2000 09:35:53 -0500
Message-Id: <10578.113729@fatcity.com>

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
<http://www.ixora.com.au/scripts/locks.htm>

Happy Hunting!

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Swapna_P [mailto:Swapna_P_at_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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>locks?</TITLE>

<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=014522914-03082000>Check
v$lock.  You also might want to consider using utllockt.sql.  There are some good ancilliary scripts for this available at:</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=014522914-03082000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=014522914-03082000>           
<A

href="http://www.ixora.com.au/scripts/locks.htm">http://www.ixora.com.au/scripts/locks.htm</A></SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN
class=014522914-03082000></SPAN></FONT> </DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=014522914-03082000>Happy
Hunting!</SPAN></FONT></DIV>
<DIV> </DIV>
<P><FONT face=Arial size=2>David A. Barbour</FONT> <BR><FONT face=Arial

size=2>Oracle DBA - ConnectSouth</FONT> <BR><FONT face=Arial 
size=2>512-681-9438</FONT> <BR><FONT face=Arial 
size=2>dbarbour_at_connectsouth.com</FONT> </P>

<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Swapna_P [mailto:Swapna_P_at_satyam.com]<BR><B>Sent:</B> Thursday, August 03, 2000 8:18 AM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> locks?<BR><BR></DIV></FONT>
<P><FONT color=#0000ff face=Arial>how can i find out the locks existing on a table and by whom?</FONT> <BR><FONT color=#0000ff face=Arial>rgds</FONT> <BR><FONT color=#0000ff face=Arial>swapna</FONT> </P></BLOCKQUOTE></BODY></HTML> Received on Thu Aug 03 2000 - 09:35:53 CDT