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: EscVector <EscVector_at_gmail.com>
Date: Fri, 15 Jun 2007 02:09:36 -0000
Message-ID: <1181873376.064096.202890@i13g2000prf.googlegroups.com>


On Jun 14, 6:36 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jun 14, 10:14 am, 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 )-
>
> This means the ASP application is not properly closing _a_ TCP
> connection.
> Seehttp://support.microsoft.com/kb/137984"consider the following
> scenario:..."
>
> jg
> --
> @home.com is bogus.http://lauren.vortex.com/archive/000251.html

Is this an in-house app or 3rd party? Sounds like .Net connection pool is not being used correctly.

If .Net, search for stuff by Mark Williams http://oradim.blogspot.com/ if this is the case. He's got a good chapter in his book about .Net.ADO connections. Received on Thu Jun 14 2007 - 21:09:36 CDT

Original text of this message

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