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

Home -> Community -> Usenet -> c.d.o.misc -> How to find who locks my table?

How to find who locks my table?

From: Kevin W. <KCW3388_at_HOTMAIL.COM>
Date: 22 May 2002 17:12:47 -0700
Message-ID: <8ca654f6.0205221612.60f617af@posting.google.com>


Hi,

I am using Oracle 8.
Is there anyway to find out who locks my table.

I tried using DBA_DML_LOCKS but I got the following message.

ERROR at line 1:
ORA-00942: table or view does not exist

Is there any better way to do so?

Thanks!

Kevin W. Received on Wed May 22 2002 - 19:12:47 CDT

Original text of this message

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