Hi Arnab,
Thanks for your response.
but i couldn't see any record by joining these tables...just no rows
selected :(
arnab wrote:
> 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 Thu Dec 07 2006 - 03:55:16 CST
