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

Hi,

If you have any database administration tool TOAD, you can log in as SYS user and open the session browser and search any session id that has locked your object. You can kill that blocking session from there itself.
Or
Login as SYS from SQL client and query the v$lock, dba_objects, v$session where
v$session.sid = v$lock.sid and v$lock.id1 = dba_objects.object_id and dba_objects.object_type = 'PACKAGE' and dba_objects.object_name = <Yuor package name>
This will give the sid which has locked your package.

Hope this helps.

-Arnab

Shahnaz wrote:

> 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 - 08:33:12 CST