ODP.Net 10.2.0.3 hanging intermittently

Hi All,

We've currently got an application written in ASP.Net connection via ODP.NET on Oracle Client 10.2.0.3 to a 9.2.0.8 database. The application is hanging intermittently due to a ThreadAbortException or ODP-1000
(this is what Oracle is telling us anyway).

After a lot of search and conversations with Oracle we are still not getting any closer to the problem. From what I've seen, a lot of people have experienced this as well but there's been no conclusive fix.

This is our connect string:

user id=scot;password=tiger; Data Source=(DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = sundev1.hansen.com.au)(PORT = 1521))
)(CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SCOTDEV.hansen.com.au))); Pooling=True; Max Pool Size=30; Min Pool Size=1; Incr Pool Size=1; Decr Pool Size=1; Validate Connection=true; Connection Lifetime=120

I'm going to try and describe the problem but it's probably not correct - I'm a DBA and this ODP thing is a black box. Also, the problem is intermittent and not reproducible on demand. It can happen any time and we don't really know why.

What appears to be happening is that a thread because "dead" and the web page dies. Other users try to get in and if they happen to get the dead thread they too hang. Even though max pool size is 30, we've never seen more than 5 connections in the database itself. If all 5 threads are frozen, new sessions do not fire up new threads so we eventually have to restart the IIS. The IIS Box itself is ok as I can connect via SQL*Plus etc during the time of the hang.

From the DBA side, the database is mostly idle. Nothing going on during the time of the hang.

I've tried to research the parameters but am still not clear on what they do. For example, what does validate connection do? If a new web page starts up, does it go and probe the thread to see if it's ok or has aborted? Would this overcome our problem? Or is it just an equivalent of sending out a "select x from dual" but if it happens to be assigned a dead thread it just hangs as well?

Any advice would be really appreciated!!

TIA, Leng.

Leng Kaing

Senior Oracle DBA

Hansen Technologies; 2 Frederick St; Doncaster 3108

Ph: +61-3-9840-3832

Notice:

This e-mail and any attachments are confidential and may contain legally privileged information and/or copyright material of Hansen Technologies Limited or third parties. Copying, distributing, disclosing, commercialising or otherwise acting in reliance on this e-mail and any attachments is strictly prohibited unless you are the addressee of this e-mail and have written permission to do so. If you have received this e-mail in error please delete this e-mail (including any copies and attachments) and contact Hansen Technologies Limited by return e-mail or by telephone on + 61 3 9840 3000. Any views expressed in this e-mail are those of the individual sender and may not necessarily reflect the views of or be a commitment by the organisation, except where the individual sender has the authority and expressly states them to be so.

--
http://www.freelists.org/webpage/oracle-l