Re: Inactive Dangling Connections When App Crashes.

From: Andrew Protasov <a_protasov_at_hotmail.com>
Date: Sat, 20 Feb 1999 02:45:29 GMT
Message-ID: <7al7k7$r0v$1@nnrp1.dejanews.com>

Hi,

Try to set this parameter in server side sqlnet.ora:

SQLNET.EXPIRE_TIME Purpose:
Determines time interval to send a probe to verify the session is alive.

Default Value:
NONE Minimum Value:
0 minutes

Recommended Value:
10 minutes

Example:
sqlnet.expire_time=10

Andrew Protasov

In article <7aj1n8$u8s$1_at_nnrp1.dejanews.com>, tim.mcconechy_at_runtime.dk wrote:
> How does one handle this senerio.
> The client server app crashes leaving an INACTIVE CONNECTION.
> TO Oracle.
>
> This only happens when the app GPF's or I kill it from the task bar.
>
> It doesn't happen much but it happens.
>
> Without the obvious (prevent it)
> Is there ways to handle this????
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Feb 19 1999 - 20:45:29 CST