Windows Oracle Data Access Components (MOSC)

MOSC Banner

ODP.net connection pool sessions not closed

Hi there,

we are facing an issue with an ODP.net connection pool. Sessions of the connection pool (running on IIS) are not closed and are also not reused for queries. Instead for new queries new sessions are opened.

But first a few details about the environment.

Operating system: Windows Server 2016 Datacenter

ODP.net version: 4.122.1.20170524 (Unmanaged)

Database version: 12.1.0.2.170418

The connection pool uses the following settings:

Pooling=true;
Min Pool Size=5;
Max Pool Size=100;
Connection Timeout=30;
Incr Pool Size=2;
Decr Pool Size=3;
Connection Lifetime=15;
Validate Connection=true;

From a trace I can see, that the sessions are not identified as idle.

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