resource busy and acquire with NOWAIT specified
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: resource busy and acquire with NOWAIT specified

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    I ran a proc on a table. The proc is finished yet I get this message and the table is still locked. How do I release the lock?
    Hemant

  2. #2
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    510
    Open a fresh session, and kill all the previous inactive sessions and PMON will do the work for you of releasing all the locks.

    Alter system kill session 'sid, serial#';

    Looking at this link for more on how to find user sessions:
    http://www.dbasupport.com/forums/sho...threadid=14593

    Then fix the code: Are you using FOR UPDATE.. WHERE CURRENT OF? Did you close the cursor? Did you commit?


    [Edited by kris109 on 08-25-2001 at 11:00 AM]

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    If the procedure has finished, killing the session will only slow it down, because all the transactions which are being (slowly) recorded now will be (slowly) rolled back. As long as you're not running out of space for redo logs, let it go.
    Oracle DBA and Developer

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Hemant,

    I have closed your thread on this problem, under the Administration forum and have provided a link from there to this one..


    Reference: http://www.dbasupport.com/forums/sho...threadid=14983

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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