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: 11 Dec 2006 22:02:14 -0800
Message-ID: <1165903334.645298.260470@n67g2000cwd.googlegroups.com>


Could anybody help me in this issue?

Shahnaz wrote:
> 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 Tue Dec 12 2006 - 00:02:14 CST

Original text of this message

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