Re: Inactive Sessions Remain Open

Hi Steven,

first change or insert a string in the sqlnet.ora on the server:

sqlnet.expire_time = 10

This will cause a "ping" of the connection all 10 minutes. If the client is dead the connection will be removed.

If you have to kill a spinning session, first kill the corresponding os process. Normally after some 10-20 minutes smon will clean up all sessions without os counterpart. If this didnīt work you can try to kill the session by hand. Please give smon some time to wake up and do his work. So if after another 10-20 minutes the session is still on the instance your only way to get rid of them is to bounce the instance (shutdown/reboot).

hth
Andy

"Steven Pannell" <steven.pannell_at_gmx.net> schrieb im Newsbeitrag news:9r0so9$r3hin$1_at_ID-82797.news.dfncis.de...
> Hi All,
>
> I am using Oracle 8i and have lots of inactive sessions open on the
> database. In fact I have so many that the max. number of processes is
being
> reached. The problem is sometimes our development applications crash
> leaving the cursor open and thus the session never goes away. Even if I
> attempt to kill the session it still reamains open.
>
> How can I set up Oracle to remove/kill dead sessions without restarting
the
> database.
>
> thanks for any help,
>
> Steve.
>
>
>
Received on Mon Oct 22 2001 - 08:24:16 CDT