Re: Lost Connection Detection

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Fri, 28 May 1999 15:37:57 +0100
Message-ID: <vrcpIEAFpqT3Ew7a@ahardy.demon.co.uk>

In article <927749385.14018.0.nnrp-08.9e984b29_at_news.demon.co.uk>, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> writes
>If the client's are at the end of a network
>then you I think need to look at sqlnet.ora
>(at both the client and server side) and set the
>dead-connection parameter which is (from
>memory)
>
>sql_net.expire_time=N
>
>where N is probably measured in minutes.

I *think* that this was broken until 7.3.6... may cause strange hang-ups on the server (experienced on our NT 7.3.3/7.3.4 and confirmed by Oracle).

>
>
>--
>
>Jonathan Lewis
>Yet another Oracle-related web site: www.jlcomp.demon.co.uk
>
>scooby_fudge_at_my-dejanews.com wrote in message
><7ieakh$s4s$1_at_nnrp1.deja.com>...
>>Is there any way of speeding up the time it takes
>>for Oracle to rollback transactions from user
>>processes which have died abnormally ?
>>
>>Is there an INIT.ORA parameter to control this, or
>>maybe it's an SQL*Net setting ?
>
>
>

--
Andy Hardy. PGP key available on request

Received on Fri May 28 1999 - 09:37:57 CDT