Re: kill query w/o killing session?

<susana73_at_hotmail.com> wrote in message
news:1125449161.384454.40080_at_z14g2000cwz.googlegroups.com...
> I've been using "alter system kill session 'sid,serial';" to kill
> sessions. Now I am wondering is there a way to kill just the query of
> a session/sid without killing the session/sid itself? Or is it simply
> not recommended?
>

Hit ctrl-c on the client? :-D

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.