Re: Dropping Dead SQLNET Sessions

From: Donald Campbell <Donald_at_suedon.co.uk>
Date: 1996/01/29
Message-ID: <822943497snz_at_suedon.co.uk>#1/1

>We have a HP server running HP-UX 9.04, Oracle 7.1.4.1 and SQLNET 2.1.4.1.
>We have set the listener CONNECT_TIMEOUT parameter set as follows:
>
>CONNECT_TIMEOUT_flclcsp1.dbp1=10
>
>Where flclcsp1.dbp1 is our listener name. This is the only
>parameter we found pretaining to dropping dead sessions.
>
>This parameter setting does not appear to be consistently dropping
>dead sessions after 10 minutes of inactivity.
>
>Is there another parameter or a HP-UX 9.04 setting we should change?
>

in $ORACLE_HOME/network/admin/sqlnet.ora put:

sqlnet.expire_time=15

15 relates to the time period (minutes) that the server should check if the client still responds. Note it can take some time before it descides that it has not responded.

Regards
Donald Campbell [ SueDon Ltd - UNIX and Database Specialists (Bracknell, UK) ] Received on Mon Jan 29 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Steve Shiflett: "Re: Oracle 7.2 on an aix box - printf and dbx don't work"
Previous message: M.Verwey_at_inter.nl.net: "Re: Newbie problem figuring out parent/child problems"
Maybe in reply to: Mark Hansen: "Dropping Dead SQLNET Sessions"
Next in thread: Steve Shiflett: "Re: Oracle 7.2 on an aix box - printf and dbx don't work"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message