Dotnet-Oracle connectivity

Dotnet-Oracle connectivity

Postby 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
solutionsahead
 
Posts: 2
Joined: Fri 17 Mar 2006 11:36

Postby Paul » Mon 20 Mar 2006 07:29

Please use OracleConnection.ClearAllPools() or OracleConnection.ClearPool().
Or use OracleConnection="Pooling=false;......" for disabling pooling
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Dot Net - Oracle connectivity

Postby solutionsahead » Mon 20 Mar 2006 08:29

We have tried that as well...

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

Postby 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?
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle