Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04021: timeout occurred while waiting to lock object start1.st

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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 12 Dec 2006 07:07:52 -0000
Message-ID: <IoadnXNIC6XbyOPYnZ2dnUVZ8s-qnZ2d@bt.com>


"Shahnaz" <ahamedshahnaz_at_gmail.com> wrote in message news:1165903334.645298.260470_at_n67g2000cwd.googlegroups.com...
> Could anybody help me in this issue?
>

ORA-04021 is about library cache object locking.

One possibility is that one session is trying to recompile an object (e.g. pl/sql procedure) which is being run by another session, but the run-time exceeds 5 minutes (IIRC)

This can also happen if you grant execute on procedure to USER, and the procedure is currently in use and stays in use for the same time.

Check 1: do you grant execute (etc.) directly to users Check 2: do you have any 'infinite loop' procedures that might need to be recompiled occasionally.

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Received on Tue Dec 12 2006 - 01:07:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US