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

Home -> Community -> Usenet -> c.d.o.misc -> Re: idle sessions from ADO.NET despite closing them?

Re: idle sessions from ADO.NET despite closing them?

From: jobs <jobs_at_webdos.com>
Date: Fri, 16 Nov 2007 11:30:54 -0800 (PST)
Message-ID: <5571c8b0-ff06-472e-9d41-9fc0174f7f80@p69g2000hsa.googlegroups.com>


>
> Just because you connect and disconnect in your application does not
> mean that .net is not using connection pooling of some type. What is
> the .net release level? I do not remember the details but we had a
> developer that wrote a .net application that created a new session
> every time it ran. We hit max processes over and over till I
> convenced another developer to look into the issue. They found some
> parameters that they set. I am pretty sure one was set in the
> application and another outside the individual program but in the
> software.
>
> Your problem could be different but use v$session to verify if one
> applicaiton is spawing tons of processes.
>
> HTH -- Mark D Powell --- Hide quoted text -
>

I think you are right. We are on .NET 2.0. If anybody knows where i might find such a setting please let me know. Received on Fri Nov 16 2007 - 13:30:54 CST

Original text of this message

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