Re: kill query w/o killing session?

From: DA Morgan <damorgan@xxxxxxxxx>
Date: Tue, 30 Aug 2005 21:08:13 -0700

susana73@xxxxxxxxxxx wrote:

I've been using "alter system kill session 'sid,serial';" to kill
sessions.  Now I am wondering is there a way to kill just the query of
a session/sid without killing the session/sid itself?  Or is it simply
not recommended?


Can not be done AFAIK.

--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.

References:
- kill query w/o killing session?
  - From: susana73

Prev by Date: Re: 10g RAC on a single physical server
Next by Date: Re: Primary/non primary sessions
Previous by thread: Re: kill query w/o killing session?
Next by thread: Re: kill query w/o killing session?
Index(es):
- Date
- Thread

Relevant Pages

Re: kill query w/o killing session?
... Now I am wondering is there a way to kill just the query of a session/sid without killing the session/sid itself? ... Resource Manager will use the statistics in the CBO to generate an estimated completion time for each database operation. ...
(comp.databases.oracle.server)
Re: kill query w/o killing session?
... Now I am wondering is there a way to kill just the query of ... > a session/sid without killing the session/sid itself? ... Kill the client with kill -HUP or kill -INT and write a signal handler ...
(comp.databases.oracle.server)
kill query w/o killing session?
... I've been using "alter system kill session 'sid,serial';" to kill ... Now I am wondering is there a way to kill just the query of ... a session/sid without killing the session/sid itself? ...
(comp.databases.oracle.server)
Re: Restarting Xserver from cli
... Later, Ray Parrish-- ... Can I actually query and kill hung processes from 7 while logged ... use htop to find what needs killing and to do the killing. ...
(Ubuntu)