I saw this note on MetaLink that may help.
Rick
Error: ORA 4020
Text: deadlock detected while trying to lock object %s%s%s%s%s
----------------------------------------------------------------------------
---
Cause: While trying to lock a library object, a deadlock is detected.
Explanation:
During compilation we hit a deadlock situation.
This is generally caused by a circular dependency of some form.
Diagnosis:
Find out what objects are being compiled in what order.
Changing the order of creation should prevent this.
When creating objects a SAFE order of creation is:
TABLE, PACKAGE, PACKAGE BODY, TRIGGER
> -----Original Message-----
> From: Uldis [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, February 09, 2001 7:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-04020: deadlock detected while trying to lock object...
>
> Need guru! :)
>
> At attempt to compile procedure we're getting subj. Nevertheless there is
> no
> more sessions accessing the schema.
>
> About environment:
> Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production
> PL/SQL Release 8.1.6.0.0 - Production
> CORE 8.1.6.0.0 Production
> TNS for Solaris: Version 8.1.6.0.0 - Production
> NLSRTL Version 3.4.0.0.0 - Production
>
> TIA,
> Uldis
>
> Uldis Pavuls
> DBA, Tieto Konts Financial Systems Ltd.
> Kr.Barona 32, Riga, Latvia, LV 1011
> phone +371 7 286 660, fax +371 7 243 000
> mailto:[EMAIL PROTECTED], http://www.konts.lv
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Uldis
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
