Re: ORA-04021 timeout occurred while waiting to lock object

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 3 Jul 2004 10:05:07 +0000 (UTC)
Message-ID: <cc60cj$7e0$1@titan.btinternet.com>

Someone else is probably executing the package/procedure while you are trying to compile it.

Find out who that is - you can find out who it is by checking the view dba_lock_internal that can be built using the catblock.sql script from the $ORACLE_HOME/rdbms/admin directory - and terminate their session if you can.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"Lijami" <spale_at_net.yu> wrote in message
news:ac6d8490.0407030137.7c6f99cc_at_posting.google.com...


> I'm constantly geting the same message while trying to compile a package

body:


> ORA-04021 timeout occurred while waiting to lock object!

>

> What am I to do?

>

> Thanks

Received on Sat Jul 03 2004 - 05:05:07 CDT