Friday, July 1, 2011

ORA-00054: resource busy and acquire with NOWAIT specified

If you administer a busy database you will see this error from time to time. 

It simply means that session has a lock on an object that your session is trying to update (or lock). More specifically, your session has asked for a lock on the same object, but has specified the 'nowait' clause. The nowait clause, upon finding something locked, returns an error, rather than waiting for the lock to be released.

Your options are as follows:

  • Try again later. Hopefully whatever was locking the object will have finished, and you can continue with your work.
  • Attempt to find out who/what is locking the object and kill it off. 

No comments:

Post a Comment