Re: Connection never killed

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.

-- 
The underscore character does not belong in my address. You know the drill...
***
Anyone sufficiently smart enough to configure and use USEnet for research should
be smart enough to Read The Freakin' Documentation!