Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP.NET Oracle - Using ODP for .net - HANG Issue...

Thread Tools

ASP.NET Oracle - Using ODP for .net - HANG Issue...

Posts: n/a

We are having an application that uses ASP.Net / Oracle DB /
ODP for .net with connection pooling on

We are using ODP .Net

We have set the parameters as below in the web.config file

<add key="ERSDBConnectionString" value="Password=yyyy;User ID=zzzz;Data
Source=xxxx;Persist Security Info=true;pooling=true;Min Pool Size=2;Max
Pool Size=100;Incr Pool Size=2; Decr Pool Size=1;Connection
Lifetime=1;Connection Timeout=2;"></add>

We are using REF Cursors and XML Type datatypes in the Stored Procs

We are linking to 5 other diff databases(4 Oracle and 1 SQL Server)

Once our application hits the place where we are using xmltypes the
application creates some sessions which dont get killed
We tried all possible parameters and their values for Connection
Pooling but no use

Once we turn the conn pooling off, the application works fine for ever
with out any hanging
But is very slow

Also by the time the application hangs we have accessed only the other
Oracle databases and not the one single SQL Server database.

Any pointers on how to solve this issue.

We started with 9.2.01 then started applying all available pached of
oracle and are in now

I would really appreciate any quick response.


Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODP.NET and Oracle 10g =?Utf-8?B?RGlmZmlkZW50?= ASP .Net 1 05-02-2007 01:03 AM
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/ line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM venky ASP .Net 0 02-15-2005 05:26 PM SK ASP .Net 2 02-14-2005 10:21 PM
ODP.NET : VB.NET and PLSQLAssociativeArray, hanging webserver =?Utf-8?B?Sm9vc3QgRXZlcnRzZQ==?= ASP .Net 1 11-06-2004 10:47 PM