Re: Inactive Dangling Connections When App Crashes.

Further more to my orignal post.
ON windows NT the process never get killed. And killed process stay in the system as KILLED. This is due to NT's threading mechanism. Not like unix kill pid cmd..
It's not that simple...

However,
the utility
orakill
Does the job...

But I can't do it from the client, or application or automatically.

So I guess the DBA must kill user connections....

In article <36D3F32D.27B3E765_at_KirchGruppe.de>,   mh_at_goofy wrote:
> We used this parameter a year ago with OPS 7.3.3.5 and SQL*Net V2.3.3.
Sometimes
> we found that sessions were killed that were inactive but nevertheless alive
and
> reachable by the ping command.
>
> Martin Haltmayer
>
> Andrew Protasov schrieb:
> >
> > 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
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Feb 25 1999 - 03:42:07 CST