Resource busy

[badrinathn]

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

[mhaller]

You'll need to wait until the lock is cleared.

[badrinathn]

cAN I MANUALLY RESET/CLEAR THE LOCK
Badrinath

[sambavan]

To avoid this problem, increase your dml_locks parameter to a good number. Default is 20.

Sam

[badrinathn]

DML_LOCKS parameter value is already 268;
Isn't it a big number.

[sambavan]

You can go further up. Put it to 1000.

Sam

[badrinathn]

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