Releasing Oracle connections from .Net application.

I've got many replies to that post. So I decide to try making it clearer.

If you see that Oracle holds Connections of your application with invalid status check:

1)      That you are using Oracle ODP.NET provider (version 102 or higher) and not Microsoft provider for oracle. This bug solved just in ODP.NET.

2)      Ensure that you close all your open connections by closing or disposing OracleConnection.

3)       Pay attention to those two connection string options: "Decr pool size" and "Incr pool size". "Decr pool size" set the Number of connections that are closed when an excessive amount of established connections are unused. "Decr pool size" default value is 1. ". "Incr pool size" set the Number of connections established when all connections in pool are used. "Incr pool size"  defult value is 5. As you can see those default values can cause the pool to reach it maximum connection pool size default value (Default - 100).

4)      Any other suggestion …