Re: Stop Store proc from running

In Oracle, find the sid and serial# of the session and do an "alter system kill session" command. That will kill it. It might take awhile to kill, depending on how much rollback it has to do.

cosltemp-g.manoj_at_orbitech.co.in wrote:

> Hi,
> I want to immediately stop a running stored proc.I tried kill -9 pid
> . It shows killed.
> But procedure is still continuing..
>
> Thanks
> Manoj

--
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
it" - Tom Lehrer


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: srcdco_at_ritvax.rit.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).