Re: How to terminate user's session ?

If many sessions are hanging arround marked as KILLED and they are not removed it is probably because the socket can not be released, you must setup Dead Connection Detection to release the sockets. sqlnet.ora entry on the server sqlnet.expire_time= <mins>

Regards
David Russell

S S Wan wrote in message <6iesdq$hll$1_at_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 - 17:07:04 CDT