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: Jimmy <jimmy.cooleman_at_gmail.com>
Date: Fri, 15 Jun 2007 02:16:35 -0700
Message-ID: <1181898995.922490.61190@k79g2000hse.googlegroups.com>


On 14 jun, 20:54, EscVector <EscVec..._at_gmail.com> wrote:
> On Jun 14, 1:14 pm, Jimmy <jimmy.coole..._at_gmail.com> wrote:
>
>
>
>
>
> > On 14 jun, 17:23, 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
>
> > When i check for TCP connections on the server,
> > i see a lot of TCP connection in the state CLOSE_WAIT; these
> > connection are from the Webserver ( hosting the ASP application )
>
> Guess: It's a connection pool issue from the server and it's not
> closing the connections.- Tekst uit oorspronkelijk bericht niet weergeven -
>
> - Tekst uit oorspronkelijk bericht weergeven -

Yes, probably,
have to check that with the developper
But this doesn't explain why this application worked fine with Oracle 9.2. This issue only appeared since we moved the database to a Oracle10 Received on Fri Jun 15 2007 - 04:16:35 CDT

Original text of this message

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