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

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

Allan Hicks <ahicks_at_acsatlanta.com> wrote:
>Eric Meier, DBA wrote:
 

>I haven't run out of processes, but I've had a bunch of processes named:
>
> oracleSID(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
>
>in my ps list on HP-UX 9.04 and HP-UX 10.10 with Oracle sever 7.1.6.
>They
>appear to be orphaned server clients. At least that's what I gathered
etc. Received on Wed Sep 11 1996 - 00:00:00 CEST