Randy Nichols <randynichols_at_yahoo.com> schreef in berichtnieuws
gWeSa.109639$Io.9388352_at_newsread2.prod.itd.earthlink.net...
| 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)
|
You can't kill the query.
You can kill the session. Query V$SESSION and note values of SID and
SERIAL#.
Then do "alter system kill session 'sid,serial#';
You can set resource limits. But they must be defined before the session is
started. See Oracle8i Concepts, chapter 26 (for V8.1.7).
Received on Sat Jul 19 2003 - 12:18:46 CDT
