Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2006
    Posts
    58

    Unanswered: How can I delete the running procedure?

    Hi, everyone ,thank you in advance!

    I have finished a procedure. But it has run over 3 hours. I found that there is a LOOP statement without EXIT statement. Now I want to stop the procedure and delete it.

    In the tool "UTF-8 TeraTerm Pro", I have used the keyes [CTRL]+[C], I hope I can stop the procedure. But I failed. How can I delete the running procedure with Oracle 10g database running in the operation system "Solaris"?

    Thank you very much!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    From the Solaris command line issue:
    $ kill -9 <pid>
    where <pid> is the process id of the offending OS process.

    You could try:
    SQL> ALTER SYSTEM KILL SESSION .......

    but I expect the offending session to be tagged as KILLED or SNIPED but the session won't clear until after OS process get terminated
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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