Dotnet-Oracle connectivity

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
solutionsahead
Posts: 2
Joined: Fri 17 Mar 2006 11:36

Dotnet-Oracle connectivity

Post by solutionsahead » Fri 17 Mar 2006 11:43

Hi,

I have developed an E-business web application in Visual Studio.NET1.0 with ASP.NET, C# and Oracle9i as the database. The application is hosted on a windows Terminal Server with 2 GB RAM and 80 GB HDD resource.

There is a lot of inactive sessions. The connections don't seem to be released from the pool whether I call dispose(), close(), or both, and this keeps building-up as users connect to the portal. We have used .NET 1.1 frame work with service pack 1 on the server. Can someone provide me with a solution recommendation asap?

Thanks in anticipation?

SRK

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 20 Mar 2006 07:29

Please use OracleConnection.ClearAllPools() or OracleConnection.ClearPool().
Or use OracleConnection="Pooling=false;......" for disabling pooling

solutionsahead
Posts: 2
Joined: Fri 17 Mar 2006 11:36

Dot Net - Oracle connectivity

Post by solutionsahead » Mon 20 Mar 2006 08:29

We have tried that as well...

SRK

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Mon 20 Mar 2006 14:52

What value of Pooling parameter do you use in your application? It is "true", "false" or blank?
Please note that ClearAllPools and ClearPool clears pools during 40 seconds. How did you determine
that there are opened connections to Oracle server?

Post Reply