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

Perhaps I'm missing something.

If expire_time=10, does this not mean that Oracle's SQL*Net V2.x will 'house-keep' a noted dead connection, using a probe packet, after ten minutes? Where does the concept of '1Hour of idle time' enter into the picture.
PB

In article <3238066F.41B8_at_sed.stel.com>, Robert Yeh <ryeh_at_sed.stel.com> wrote:
>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 Fri Sep 13 1996 - 00:00:00 CEST