Re: killing queries - possible?

"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