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: Shahnaz <ahamedshahnaz_at_gmail.com>
Date: 5 Dec 2006 22:36:14 -0800
Message-ID: <1165386974.918883.303000@f1g2000cwa.googlegroups.com>


thanks for you info
but how to find what are other sessions are locking this package?

Vladimir M. Zakharychev wrote:
> Shahnaz wrote:
> > Hi anybody,
> > I was getting error like below while compiling package
> > ORA-04021: timeout occurred while waiting to lock object start1.st
> > please assist me.
>
> This means that the object is currently in use and locked (some other
> session executes this stored procedure.) Wait until it finishes or kill
> that other session.
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com
Received on Wed Dec 06 2006 - 00:36:14 CST

Original text of this message

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