Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How I can kill killed session?

Re: How I can kill killed session?

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: Thu, 11 Feb 1999 14:02:04 -0700
Message-ID: <36c34515.0@news.cadvision.com>


In the sqlnet.ora you specify the sqlnet.expiry_time parameter. It introduces some overhead, since sqlnet will now send probes at specific intervals so chcek whether you are still alive.

--
Terry Dykstra
Canadian Forest Oil Ltd.
Lev Yunak wrote in message <01bd36cb$3408e0e0$101aa8c0_at_lev.vaz.ru>...
>Hello
>
>I disconnected one session and it had marked as "KILLED".
>And this session continued lock object that it worked. Also I terminated
>client program
>too but nothing happened.
>I want session dissapper only and unlock my objects without restart DB.
>I remember there is parameter for init.ora that define time to wait client
>answer.
>Does it help? What can help?
>
>Best wishes, Lev.
>
>P.S. May it FAQ but I couldn't find.
Received on Thu Feb 11 1999 - 15:02:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US