Re: Stopping an PL/SQL procedure from running

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Fri, 17 Sep 1999 00:39:45 -0300
Message-ID: <HBjE3.1772$jy4.101519@newscontent-01.sprint.ca>

connect system/manager

select sid, serial#, -- process identifiers used for kill later username, machine, program, logon_time -- helpful info to deside what to kill
from v$session;

alter system kill session '<SID>,<SERIAL#>';

Its more safe for all database then shutdown abort you do.

Mark

Pål Jakobsen <paal.jak_at_nl.telia.no> wrote in message news:5lcE3.2412$cPf.186094080_at_news.telia.no...
> Is there any method to stop an pl/sql procedure from running without
> stopping the ORACLE80.EXE in the NT task manager.
>
> I am debugging an procedure in Oracle80 on Windows NT 4.0 which often goes
> in an endless loop. I can´t find anything help in the documentation.
>
>
>
> Any ideas ?
>
>
Received on Thu Sep 16 1999 - 22:39:45 CDT