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?
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:
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]
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
I have closed your thread on this problem, under the Administration forum and have provided a link from there to this one..
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width