Urgent- Session killed but not rolling back
I had to kill an session using TOAD. This came up as "session marked for kill". However this has been running for over 14 hours now. This is far more than it the process had been running (3-4 hours). It was executing a stored procedure which was basically inserting some records into a table. This still shows up as the current statement.
Im running oracle 22.214.171.124.0
Any ideas how I can get this to finally clean up?
kill the O/S process associated with the session.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Im concearned that killing the o/s session may not clear up what is causing the issue.
The only thing that I can think of that might have effected this was that I made a precision change on a table that was used by the stored procedure, after I killed the session. I would have thought oracle would have obtained an exclusive lock on the table if it was rolling back transactions from that table.
Ok my patience has been stretched
What kind of kill do you recommend -9 or -16?
NT or Unix?????
NT ---> ORAKILL
UNIX ---> kill -9
Click Here to Expand Forum to Full Width