Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04021: timeout occurred while waiting to lock object start1.st
"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.htmlReceived on Tue Dec 12 2006 - 01:07:52 CST