Re: Orphaned Oracle Processes

From: Johnny Baker <jb35541_at_us0n05.glaxo.com>
Date: 1997/02/03
Message-ID: <32F65130.2D9B@us0n05.glaxo.com>#1/1

Steve Main wrote:
>
> Does anyone have a way to get the Oracle server or SQL net V2 to kill
> orphaned unix processes ? It looks like when one of our developers has a
> Developer 2000 session hang it will leave a process running on our unix
> box. (RS6000 AIX 4.1).
>
> Oracle version 7.3.2.2
>
> Thanks
>
> Steve Main
> Database Administrator
> Quality Food CentersThere is an optional parameter SQLNET.EXPIRE_TIME in the SQLNET.ORA file
which determines how often SQL*Net sends a probe to verify that a client-server connection is still active. If it finds a dead connection or a connection no longer in use, it returns an error causing the server process to exit. Check your SQL*Net manuals for more information.

Johnny Baker
Database Administrator
Glaxo Wellcome Received on Mon Feb 03 1997 - 00:00:00 CST