Re: Lost Connection Detection

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 26 May 1999 20:56:06 +0100
Message-ID: <927749385.14018.0.nnrp-08.9e984b29@news.demon.co.uk>

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.

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 ?
Received on Wed May 26 1999 - 14:56:06 CDT