Loading...
Tuesday, July 29, 2008

ORA-00054

ORA-00054
ORA-00054: Resource busy and acquire with NOWAIT specified
Cause: Resource interested is busy.
Action: Retry if necessary

More Information
If you administer a busy database you will see this error from time to time. It is nothing to worry about, but it can be quite annoying when it stops you from doing something.

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.

http://www.shutdownabort.com/errors/ORA-00054.php




Tags: ,,,,

0 comments:

 
TOP