Re: can Oracle DB can automaitc detect network disconnected?

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 03 Dec 2002 21:05:58 +0100
Message-ID: <oi3quucu60rdn2u91aa160c5frapc6g1gp@4ax.com>

On Wed, 4 Dec 2002 03:48:50 +0800, "jeng" <jeng_at_argotek.com.tw> wrote:

>Hi,
> Is it possible to let Oracle DB to detect the network disconnected (like
>network fail)
> and logout the DB sesion automatically?
>
> Because we have unstable remote network connection, and we were bothered
> by the hung DB sessions whick hold locks on DB objects.
>
> Is there any thing we can do to let the DB server to logout the DB sesion
> whenever the network connection fail or client program abnormally aborted.
>
> TKS.
>
>Jeng jeng_at_argotek.com.tw
>
>

Just enable dead connection detection by including sqlnet.expire_time = 10
in sqlnet.ora on the server.
Please note that on Windoze before XP this only works for the first 16 sessions, as windoze can only create 16 timers per process.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Dec 03 2002 - 14:05:58 CST