I can't remember the exact syntax, but there is a parameter you can set in
the sqlnet.ora file on the server, something like 'sqlnet.expire_time', that
will cause sqlnet to "ping" connections periodically to make sure they are
still connected. If it finds a connection that is no longer valid it will
kill it allowing pmon to clean up in the Oracle db. You can get more
information in the sqlnet manual.
Kenny Gump
OCP 7.3 DBA
tim.mcconechy_at_runtime.dk wrote in message
<7aj1n8$u8s$1_at_nnrp1.dejanews.com>...
>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
Received on Fri Feb 19 1999 - 06:30:06 CST
