Windows Oracle Data Access Components (MOSC)

MOSC Banner

ODP.NET connection pooling issue???

edited Nov 1, 2013 1:11AM in Windows Oracle Data Access Components (MOSC) 3 commentsAnswered
We are using ODP.NET 11.2.0 and Oracle database 11G. 

we have ASP.NET web application running on IIS 7.5. 

we faced some issue related with connection pool. i saw lots of connections created by IIS even it's not concurrent call. i limited to single use and ran it. 
it keep created 6 ~10 connection immediately. 

observation is it started with single connection and executed queries multiple times 
and 2 connections were added, one with query application asked, the other one with below query 
"SELECT parameter, VALUE
  FROM SYS.nls_database_parameters
  WHERE parameter IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET')"

i saw same pattern for further query creation. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center