-
Hi,
I am trying to issue
Alter table acc_partition Nologging and get
ora-00054: Resource busy and acquire with NOWAIT specified
*********I checked in the ORA Err message documents ***
ORA-00054 resource busy and acquire with NOWAIT specified
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
Action: Try the command after a few minutes or enter the command without the NOWAIT keyword.
****I tryed after some time, but still get the same error***
Could someone help me , how to go ahead;
Badrinath
-
You'll need to wait until the lock is cleared.
-
cAN I MANUALLY RESET/CLEAR THE LOCK
Badrinath
-
To avoid this problem, increase your dml_locks parameter to a good number. Default is 20.
Sam
-
DML_LOCKS parameter value is already 268;
Isn't it a big number.
-
You can go further up. Put it to 1000.
Sam
-
Alternatively, I killed the session which had acquired a lock on the object, It went through.
But still want to understand from you:
what does the DML_locks parameter do? Does it allow more locks on the same object and allow me to go ahead ?
Badrinath
