Re: How to find who locks my table?

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Thu, 23 May 2002 09:28:22 +0200
Message-ID: <aci5mm$dm3$1@news.mch.sbs.de>

Hi Kevin,

just run catblock.sql.

Regards
Stephan

"Kevin W." <KCW3388_at_HOTMAIL.COM> wrote in message news:8ca654f6.0205221612.60f617af_at_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 Thu May 23 2002 - 02:28:22 CDT