RE: ORA-04020: deadlock detected while trying to lock object...

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:u.pavuls_at_konts.lv]

> 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:U.Pavuls@konts.lv, http://www.konts.lv

> 

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> -- 

> Author: Uldis

>   INET: u.pavuls_at_konts.lv

> 

> 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: ListGuru_at_fatcity.com (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: RICHARD.T.CALE_at_saic.com

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: ListGuru_at_fatcity.com (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).