Re: oracle threads increasing, even after closing sessions

From: <yong321_at_yahoo.com>
Date: Thu, 14 Jun 2007 08:23:15 -0700
Message-ID: <1181834595.920713.227880@z28g2000prd.googlegroups.com>

On Jun 14, 11:11 pm, Cristian Cudizio <cristian.cudi..._at_yahoo.it> wrote:
...
>
> > By the way, DCD won't work because the SQL*Net connection is left
> > intact and TCP connection state is still established.
>
> but if there is not a client process (that opened the socket)
> responding i can't figure out why it will
> not detect a death connection ....
>
> > Yong Huang
>
> Bye
>
> Cristian Cudizio
>
> http://oracledb.wordpress.comhttp://cristiancudizio.wordpress.com

Isn't it true that DCD can only tear down a connection and terminate its server process if the client doesn't respond to an "Are you there?" packet? If the connection is healthy, the software client (sqlplus) does respond with a "Yes, I'm here", although the human client (user) can't type any command, other than exit and connect.

Yong Huang Received on Thu Jun 14 2007 - 10:23:15 CDT