Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: canceling statement
hm, i do not want to kill the session, only the pending stmt
"Dan Murphy" <djmurphy0_at_hotmail.com> wrote in message
>
> You can use dynamic SQL to issue the following directive:
>
> ALTER SYSTEM KILL SESSION 'sid,serial#' e.g.
>
> EXECUTE IMMEDATE 'ALTER SYSTEM KILL SESSION ''25, 500'''
Received on Wed Jun 27 2001 - 10:34:30 CDT