To kill a user use "alter system kill session ' sid#, serial#' "
where you can get the sid# and serial# from the v$session table./
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
su_xu_at_my-dejanews.com wrote in message <6lqphs$dph$1_at_nnrp1.dejanews.com>...
>
>
>Hi, All
>
>Can anybody tell me how to kill a closed Oracle connection on Windows NT ?
>
>Several applications are connected to Oracle 7.3 on Windows NT and
>one of them should be killed because of Time-out. But when one main process
>is killed, the corresponding Oracle connection thread will not be killed
>automatically!
>
>The question is:
> How to find out which Oracle thread is from your application?
> and How to kill it?
>
>Thanks a lot for help.
>
>Xu
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Jun 12 1998 - 13:43:22 CDT
