Urgent- Session killed but not rolling back
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Urgent- Session killed but not rolling back

  1. #1
    Join Date
    Oct 2002
    Location
    london
    Posts
    41

    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 8.1.7.0.0

    Any ideas how I can get this to finally clean up?

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    kill the O/S process associated with the session.

    Regards
    Jim
    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!

  3. #3
    Join Date
    Oct 2002
    Location
    london
    Posts
    41
    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.

  4. #4
    Join Date
    Oct 2002
    Location
    london
    Posts
    41
    Ok my patience has been stretched
    What kind of kill do you recommend -9 or -16?

  5. #5
    Join Date
    Sep 2002
    Posts
    411
    NT or Unix?????

    NT ---> ORAKILL
    UNIX ---> kill -9

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