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

From: Mark J. Bobak <mark_at_bobak.net>
Date: Wed, 07 Jul 2004 02:34:24 -0400
Message-ID: <pan.2004.07.07.06.34.22.739643@bobak.net>

Except that if it's due to someone else executing, then it's already compiled, and killing their session to compile it would be pointless. ;-)

(Unless he meant that he was attempting to recreate the object w/ new code "CREATE OR REPLACE PROCEDURE ...".)

-Mark

On Sat, 03 Jul 2004 10:05:07 +0000, Jonathan Lewis wrote:

>
> 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.
Received on Wed Jul 07 2004 - 01:34:24 CDT