Re: How to terminate user's session ?

From: S S Wan <sswan_at_hk.super.net.NOSPAM>
Date: Sat, 2 May 1998 18:28:41 +0800
Message-ID: <6iesdq$hll$1@tst.hk.super.net>

I was told by Oracle support that this command only attempt to kill the session, and the SESSION KILLED signal must be acknowledged by the client before it can do its work. Otherwise, the session will be marked KILLED and hold up resources and locks forever until the instance is shut down. The cleanest way to kill is to issue the UNIX kill process command.

I have encountered and been annoyed by many of these cases. Anybody has something better?

Venkat ????? <6ib30b$4e_at_sjx-ixn2.ix.netcom.com>...
>ALTER SYSTEM KILL SESSION 'sid, serial#'
>(the sid and serial# are from v$session table. The sid and serial# are
>enclosed in quotes separated by a comma)
>
>Venkat
>
>>If a user X is connected to the database, how can I disconnect
>>just that user ? There doesn't seem to be any server command
>>I can do to drop their session.
>>
>>Thanks,
>>
>>Bill Dietrich
>>bill_dietrich_at_wayfarer.com
>>
>>
>
>
Received on Sat May 02 1998 - 05:28:41 CDT