Re: Killing Queries

Randy Nichols wrote:

> If a query has been submitted to an Oracle 8i or above server via JDBC, is
> it possible to "kill" the query
> (for instance, it is exceeding a time limit)?
>
> -Randy
>
> (I apologize if this is repeat - can't find previous post)

On UNIX kill-9
On Windows orakill.exe
On any system ... ALTER SYSTEM KILL SESSION ...

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)