ORA-00054: resource busy

From: Shivaswamy / ಶಿವಸ್ವಾಮಿ <shivaswamykr_at_gmail.com>
Date: Fri, 30 May 2008 09:30:48 -0400
Message-ID: <1e52ad820805300630r35a48bd5sf910453f6d84f7b8@mail.gmail.com>

We have an application which runs over night. It is failing some time on ORA-54 and I am trying to troubleshoot.

I know that, we can use DDL_WAIT_FOR_LOCKS parameter to contorl if DDL statements wait and complete instead of timing out if the statement is not able to acquire all required locks.
But I like to know -
A. What controls the wait duration to acquire the required locks, before timing out?
B. Can we set this wait time?

Any input?


Received on Fri May 30 2008 - 08:30:48 CDT

Original text of this message