ODP.NET connection pooling issue???
We are using ODP.NET 11.2.0 and Oracle database 11G.
WHERE parameter IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET')"
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_parametersWHERE parameter IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET')"
i saw same pattern for further query creation.
0