Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: killing queries - possible?

Re: killing queries - possible?

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 15 Jul 2003 00:59:54 -0700
Message-ID: <1a75df45.0307142359.7de52aae@posting.google.com>


"Randy Nichols" <randynichols_at_yahoo.com> wrote

> If a query has been submitted via JDBC, is it possible to "kill" the query

Look at the SQL command ALTER SYSTEM KILL SESSION

> (for instance, it is exceeding a time limit)? How do you do it?

Ah.. don't confuse random killing with carefully planned murder when the latter is cleaner and automated. What you need to do is look at resource limits for schemas (i.e. Oracle users).

--
Billy
Received on Tue Jul 15 2003 - 02:59:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US