Re: How I can kill killed session?

From: Andrew Protasov <a_protasov_at_hotmail.com>
Date: Sun, 14 Feb 1999 00:40:01 GMT
Message-ID: <7a5610$8oc$1@nnrp1.dejanews.com>

Hi,

Try to set

SQLNET.EXPIRE_TIME=5 in server side sqlnet.ora file. It is time in minutes between watchdog packets. Server uses them to check where is client alive or not.

Andrew Protasov

In article <01bd36cb$3408e0e0$101aa8c0_at_lev.vaz.ru>, "Lev Yunak" <L.Yunak_at_vaz.ru> wrote:
> 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.
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Feb 13 1999 - 18:40:01 CST