Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle threads increasing, even after closing sessions

Re: oracle threads increasing, even after closing sessions

From: Cristian Cudizio <cristian.cudizio_at_yahoo.it>
Date: Thu, 14 Jun 2007 08:30:05 -0700
Message-ID: <1181835005.168762.57660@x35g2000prf.googlegroups.com>


On Jun 14, 5:23 pm, yong..._at_yahoo.com wrote:
> 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

Maybe i've not understood,
DCD works at lower level, SQLNET, Server sends a TCP packet and waits a ACK,
because this appens the socket must be open and i espect that this does not happen if
client application has closed. I'm wrong?

Bye

Cristian Cudizio

http://oracledb.wordpress.com
http://cristiancudizio.wordpress.com Received on Thu Jun 14 2007 - 10:30:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US