Hi,
We have an ASP.NET 4.0 Project,
and we are connecting Oracle 11g database using ODP.Net 2.111.1.0 (Oracle.DataAccess.Client)
Our Application is hosted on WINDOWS SERVER 2008 R2 ENTERPRISE x64 Edition IIS 7.0.
Connection string is in web.config with following config
"User ID=XXX;password=XXXX;Data Source=XXXXX;Persist Security Info=False; Max Pool Size=70;Min Pool Size=5;Incr Pool Size=5; Decr Pool Size=2;Pooling=True; Connection Lifetime=180; Connection Timeout=30;Validate Connection=true;"
We are facing following problems at Oracle Database Side:--
- Some times connection goes beyond 70 like 467, 486 and so on.
- Active Connection - upto 20 only
- Inactive connections are not getting free (most of the connection are inactive).
So DBA team says Application Connection Pool is not behaving properly.
Plz guide us and provide suggestions.
Thanks
Naween