Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: "best" option to abort a running stored proc

Re: "best" option to abort a running stored proc

From: John K. Hinsdale <hin_at_alma.com>
Date: Sat, 22 Sep 2007 13:20:54 -0700
Message-ID: <1190492454.436771.206140@g4g2000hsf.googlegroups.com>


On Sep 21, 3:05 pm, "userjohn" <userj..._at_mailinator.com> wrote:
> 10gR2 EE (10.2.0.3.0) /Solaris
>
> what is the "best" option to abort a running stored proc, dbms_pipe ?

If your aim is to kill off "runaway" procedures, you can set it up to run under an Oracle user w/ a profile that limits the CPU in a session. See:
http://www.psoug.org/reference/profiles.html

Of course that will kill off the session, not just the stored proc, which may be less graceful than what you want. But at least it will happen (eventually) in an automatic way. Your other option as mentioned by others is to kill off the session manually w/ ALTER SYSTEM KILL SESSION

John Hinsdale Received on Sat Sep 22 2007 - 15:20:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US