From nlaracca@afip.gov.ar Thu, 06 Sep 2001 06:55:18 -0700
From: "Natalia Laracca" <nlaracca@afip.gov.ar>
Date: Thu, 06 Sep 2001 06:55:18 -0700
Subject: RE: Please tell me how to know whether or not a table is locked
Message-ID: <F001.003852AC.20010906070113@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



Hi,
select dbo.owner||'.'||dbo.object_name 
object,
<FONT 
face=Arial>           
 dbo.Object_type
from v$locked_object lo,
         
dba_objects  dbo
where lo.object_id = dbo.object_id
/
 
 
<BLOCKQUOTE 
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  ----- Original Message ----- 
  <DIV 
  style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: 
  Ha Duy Thien 
  
  To: <A href="mailto:ORACLE-L@fatcity.com" 
  title=ORACLE-L@fatcity.com>Multiple recipients of list ORACLE-L 
  Sent: Thursday, September 06, 2001 5:00 
  AM
  Subject: Please tell me how to know 
  whether or not a table is locked
  
  Hi Gurus
   
  Please let me know which view can show me a table 
  that is being locked.
   
   
   
  Thanks a 
lot