Home » SQL & PL/SQL » SQL & PL/SQL » Timeout occured while trying to LOCK object
Timeout occured while trying to LOCK object [message #191449] Wed, 06 September 2006 07:07 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

I trying to compile a package, while compiling it is giving error "Timeout occured while trying to LOCK object...".

I've bounced the database also to release any locks, but still the problem is same.I can not drop table package also.

Anybody has the solution for this??

Thanking you,
Ronald.
Re: Timeout occured while trying to LOCK object [message #191883 is a reply to message #191449] Fri, 08 September 2006 08:11 Go to previous messageGo to next message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Could it be that the database is rolling back the transaction You broke, when You restarted the database.
If so, You just need to wait.
Or maybe You have someone logging on and creating the lock.

Check v$lock?
Re: Timeout occured while trying to LOCK object [message #192681 is a reply to message #191883] Wed, 13 September 2006 04:29 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or have a look at dba_blockers
Previous Topic: how to select from a ROWTYPE variable
Next Topic: sql features
Goto Forum:
  


Current Time: Wed Dec 07 14:15:37 CST 2016

Total time taken to generate the page: 0.06499 seconds