Re: Kill abort session

From: Frederic DEBRUS <frederic.debrus_at_ces-cdr.be>
Date: 23 Sep 1999 12:25:50 GMT
Message-ID: <01bf05bf$b9e2bc80$3e35a99e@gal159a>

You can kill user session Oracle side or Unix side without problem but do not do both !

Also you can use a who -u to check inactive time of a unix session

hope this help

Andrey Demchenko <andrey_at_papir.kiev.ua> wrote in article <37E9E6CD.C9C39F2D_at_papir.kiev.ua>...
> Hi all.
> I write in $ORACLE_HOME/network/admin/sqlnet.ora (on the Server UW7
> ,Oracle 8.0.5.1):
> sqlnet.expire_time=5.
> But when users exit from application not correctly (switch the power off
> when they works with database) their sessions are psesent long time on
> the server.
> As far as know this session must killed after time<=sqlnet.expire_time
> (Am I right?) To kill this session manually is a bad idea.
> ----------------------------------
> The users works with Multi Threaded Server and works in DOS (through SQL
> Net 2 Lite for DOS).
> Any idea?
>
> Best regards
> Andrey Demchenko.
>
>
>
>
Received on Thu Sep 23 1999 - 07:25:50 CDT