Re: ORA-04020
It is a library cache object deadlock. I've heard of problems on 8i with refreshing snapshots that could give you a 4020 error. During a creation of a view, I've suffered one. Also installing Application 11i, I've had many. If it occurs frequently, you should call to Support. During that if it happens to be always with the same package or code piece, take a look of the size of the object, their dependencies, etcMaybe it is a heavy loaded package or code piece If it is a procedure, try change it into a package, reduce its size, reduce its dependencies, etc. If it occured only oncemaybe it was a grant when many users were using it.If it is a view, redefine it. Wellif you are using Applications and the error appears frequently...call support too. Regards. --- Ramon Estevez [EMAIL PROTECTED] wrote: Hi list, Scenario 8.1.7 when execute a procedure I get the error ORA-04020. Suggestions ?? Thanks Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger. http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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).
RE: ORA-04020
Problem solved. Just recompile all the procedures and packages. Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121 -Mensaje original-De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ramon EstevezEnviado el: Tuesday, 25 September, 2001 9:05 AMPara: Multiple recipients of list ORACLE-LAsunto: ORA-04020 Hi list, Scenario 8.1.7 when execute a procedure I get the error ORA-04020. Suggestions ?? Thanks Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121
Re: ORA-04020
At 10:05 AM 9/25/2001, you wrote: Hi list, Scenario 8.1.7 when execute a procedure I get the error ORA-04020. Suggestions ?? well, that's a deadlock error on a library. the full text of the message might help, but i guess you need to find what's locking the library and get it to drop the lock. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The attention span of a computer is only as long as its power cord. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
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:[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).