Killing session / Infinite loop
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Killing session / Infinite loop

  1. #1
    Join Date
    Jan 2001
    Posts
    3,131

    Killing session / Infinite loop

    OS Windoze NT
    Oracle 8.1.6.1.0

    Howdy Boys and Girls;

    Well it has been a looong weekend, working with my developers.

    One problem I seem to have encountered is trying to kill a session stuck in an infinte loop. I tried killing it through OEM and it shows "killed" but the session remains. We even tried shutdown immediate but it just hangs, this makes sense since it is waiting for a session to end that is not going to end.
    Is there a way around this problem. I'd really like to exhaust all possibilities before I go and shoot another developer.

    Thanks in advance!

    MH
    I remember when this place was cool.

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    There is an article in MetaLink about how to find a thread and killing it. For all that effort though, you may as well stop the service/bounce the database.

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    Originally posted by stecal
    There is an article in MetaLink about how to find a thread and killing it. For all that effort though, you may as well stop the service/bounce the database.
    Thanks Steve, that is what we did but I figured there is an easier way to do this. I hate doing ugly shutdowns like that.
    I remember when this place was cool.

  4. #4
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422
    Have you tried orakill?
    Do you let your developers put "exception when others" in the loops
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

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