Friday, October 18, 2013
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
The ‘ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired’ error can probably be avoided on a running system by setting the session ddl_lock_timeout e.g. ‘alter session set ddl_lock_timeout=5;’ will tell Oracle to retry for 5 seconds.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment