DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Urgent- Session killed but not rolling back

  1. 12-06-2002, 05:26 AM #1
    blakmk
    blakmk is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  2. 12-06-2002, 05:30 AM #2
    jovery's Avatar
    jovery
    jovery is offline Ha Ha
    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!
    Reply With Quote Reply With Quote
  3. 12-06-2002, 05:48 AM #3
    blakmk
    blakmk is offline Junior Member
    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.
    Reply With Quote Reply With Quote
  4. 12-06-2002, 06:27 AM #4
    blakmk
    blakmk is offline Junior Member
    Join Date
    Oct 2002
    Location
    london
    Posts
    41
    Ok my patience has been stretched
    What kind of kill do you recommend -9 or -16?
    Reply With Quote Reply With Quote
  5. 12-06-2002, 10:42 AM #5
    mike2000
    mike2000 is offline Senior Member
    Join Date
    Sep 2002
    Posts
    411
    NT or Unix?????

    NT ---> ORAKILL
    UNIX ---> kill -9
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width