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: Mark D Powell <Mark.Powell_at_eds.com>
Date: Sun, 18 Nov 2007 16:42:27 -0800 (PST)
Message-ID: <8ba7d2e9-9db6-45ad-9fb0-ff36af02bc10@b36g2000hsa.googlegroups.com>


On Nov 16, 2:30 pm, jobs <j..._at_webdos.com> wrote:
> > 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.- Hide quoted text -
>
> - Show quoted text -

Different tools may well have different settings. I will try to remember to ask Monday a couple of developers who work with .net if they are aware of any settings that may apply.

PS If you already have the answer please post it for the next user.

HTH -- Mark D Powell -- Received on Sun Nov 18 2007 - 18:42:27 CST

Original text of this message

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