Once the session is killed the locks are released but the session will wait
for the client to realize (You can check the V$LOCK table for the session
holding the lock), but the session doesn't go away until the client process
realizes it has been killed or closes in a normal fashion. If the client
process has an abnormal termination (kick the cord) then that session will
remain until PMON cleans it up. If you have dead connection detection then
this process can be sped up but you may take a performance hit. PMON can
also be accelerated but this also can drain the server. I've found it best
to wait for PMON to do it's thing, which can take from a few minutes to over
a day. I'm over Alpha and an Intel based servers now, but I was formerly
administering a UNIX box and I have found the same solution. Although when I
first called Oracle support I was told that killed sessions holds locks, I
later tested and disproved this. Oracle support informed me very soon after
that the locks did go away. I have thus far had good advice from Oracle
support, but even they can slip up.
Hope that helps,
Darren K. Cockrel
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 Tue May 05 1998 - 20:54:11 CDT
