Re: Aborting PL/SQL

From: Andrew Pahomov <Pahomov_at_validio.com.ua>
Date: Wed, 15 Nov 2000 06:30:07 +0200
Message-ID: <3a1167f4@miik2-ilt.ilt.kharkov.ua>

see v$session, v$process and after that 'alter system kill session 'sid,serial#' '

Ralf Jonas <ralf.jonas_at_gmx.de> wrote in message news:8urmg6$2rj4a$1_at_ID-6634.news.dfncis.de...
> Hi,
>
> is there any chance to abort a long running PL/SQL procedure by another
> way than 'shutdown abort'? We have some very impatient customers,
> thinking the client hangs and then - without further thinking - pressing
> ctrl-alt-del and quitting the client programme. The PL/SQL-routine
> allthough ist still running and is therefore holding locks on several
> tables.
>
> If it were possible, we could add an Abort button for them to kick the
> thread. No, we can't split the routine up to several small ones.
>
> Ah, almost forgotten: Oracle 8i EE Rel2 on Sun Solaris.
>
> Thanks in advance
> Ralf Jonas
Received on Tue Nov 14 2000 - 22:30:07 CST