Re: HP-UX running out of Processes : ORACLE??

From: Robert Yeh <ryeh_at_sed.stel.com>
Date: 1996/09/12
Message-ID: <3238066F.41B8_at_sed.stel.com>#1/1


Ramesha H.G. Bhatta wrote:
>
> Hi,
>
> If you have a specific dead connection detection software at the server
> use it. Otherwise you need to enable oracles dead connection detection by
> setting SQLNET.EXPIRE_TIME=10 in sqlnet.ora file to terminate the defunct
> server process after approximately 1Hour of idle time (reasonable that you
> may not be using the serverside processing or gone for tea).
>
> You can find the sqlnet.ora file in <ORACLE_HOME>\network\admin directory
>
> Both the server and client should have this parameter value same.
>
> If you are licensed to run multithreaded server then you can avoid this
> problem by configuring multithreaded serves.
>
> Hope this helps,
> Ramesha H.G. Bhatta
>

What happen if I have SQL*NET version 1?

Bob Received on Thu Sep 12 1996 - 00:00:00 CEST

Original text of this message