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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: locks?

Re: locks?

From: Steve McClure <steve_at_pactr.com>
Date: Thu, 3 Aug 2000 12:09:55 -0700
Message-Id: <10578.113778@fatcity.com>


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.

  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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>locks?</TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>column username format A10</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>column name format A20</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>select s.username, l.session_id, =
l.name,=20
l.mode_held</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>from sys.dba_dml_locks l, v$session =
s</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>where =
s.sid=3Dl.session_sid</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>This is the script I use to identify =
locks.&nbsp;=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.</FONT></DIV>
<BLOCKQUOTE=20

style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>   <DIV=20
  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: = black"><B>From:</B>=20
  <A href=3D"mailto:Swapna_P_at_satyam.com" = title=3DSwapna_P_at_satyam.com>Swapna_P</A>=20   </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> =
</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, August 03, 2000 = 6:18=20
  AM</DIV>

  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> locks?</DIV>
  <DIV><BR></DIV>
  <P><FONT color=3D#0000ff face=3DArial>how can i find out the locks =
existing on a=20
  table and by whom?</FONT> <BR><FONT color=3D#0000ff = face=3DArial>rgds</FONT>=20
  <BR><FONT color=3D#0000ff face=3DArial>swapna</FONT> =
</P></BLOCKQUOTE></BODY></HTML>
Received on Thu Aug 03 2000 - 14:09:55 CDT

Original text of this message

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