Resource busy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Resource busy

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    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






  2. #2
    Join Date
    Apr 2000
    Posts
    126

    Wink

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

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    cAN I MANUALLY RESET/CLEAR THE LOCK
    Badrinath

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    To avoid this problem, increase your dml_locks parameter to a good number. Default is 20.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Jan 2001
    Posts
    642
    DML_LOCKS parameter value is already 268;
    Isn't it a big number.

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    You can go further up. Put it to 1000.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Jan 2001
    Posts
    642

    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


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width