Re: kill query w/o killing session?
- From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
- Date: Wed, 31 Aug 2005 11:56:11 GMT
On Tue, 30 Aug 2005 17:46:01 -0700, susana73 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?
Kill the client with kill -HUP or kill -INT and write a signal handler
which will cancel any outstanding calls with OCIBreak() and resume the
session. That can be done if the application is your own, not with sqlplus.
With DBI you can disconnect the handle and immediately reconnect, thus
simulating the desired behavior.
--
http://www.mgogala.com
.
- References:
- kill query w/o killing session?
- From: susana73
- kill query w/o killing session?
- Prev by Date: Re: how to alter a sysdba privileged user on RAC?
- Next by Date: Re: [ODBC, Windows] How to install the 9.2.0.65 ODBC driver on a 9.2 client?
- Previous by thread: Re: kill query w/o killing session?
- Next by thread: Remove Discoverer from system tablespace.
- Index(es):
Relevant Pages
|
