Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: "best" option to abort a running stored proc
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