Re: killing queries - possible?

To do it manually use: alter system kill session. To automate it look into using the RESOURCE MANAGER.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Randy Nichols" <randynichols_at_yahoo.com> wrote in message news:aVIQa.101357$Io.8723196_at_newsread2.prod.itd.earthlink.net...
> If a query has been submitted via JDBC, is it possible to "kill" the query
> (for instance, it is exceeding a time limit)? How do you do it?
>
> -Randy
>
>
Received on Tue Jul 15 2003 - 05:44:07 CDT