Re: Connection never killed

This is not true.

You have sqlnet.ora's sqlnet.expire_time and idle_time in Oracle profiles.
Both have nothing to do with init.ora

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

On Tue, 18 Jun 2002 09:17:48 -0400, Imprecise <f_puhan_at_precise.com> wrote:

>I overheard in a discussion recently that this behavior is actually
>influenced by an INIT.ORA parameter. Unfortunately, I don't recall
>which (I want to say it has something to do with the COMPATIBLE
>parameter, but I can't say why). Perhaps you could check Oracle's
>technet site <http://technet.oracle.com>.
>
>In article <58d6a85c.0206180221.e740ee_at_posting.google.com>,
> oracle8_at_firemail.de (Eric Menzel) wrote:
>
>> Hi,
>>
>> on my Oracle 8.1.7.3 server (Linux) I have the problem that a remote
>> client connection never gets killed if the client has dropped the
>> connection due to an application crash. I also can't kill the session
>> on the server side. When issueing "alter system kill session..." I get
>> a "System altered" reply but the session is still in v$session and
>> server is set to "pseudo". Do I really have to kill the dedicated
>> server process on OS level? And what shall I do with a shared server
>> connection? The server has both dedicated and shared server
>> connections.
>> I don't have any timeout parameters set.
Received on Tue Jun 18 2002 - 12:28:15 CDT