Pooling in .NET Framework Data Provider for Oracle
This article deals with concepts of connection string to be used in Pooling in .NET Framework Data Provider for Oracle.
The pooling connection is made to create a new pool if there is no previous pool which could be used. If any existing pool satisfies the condition that poll can be used. To create a new pool connection use the following string.
|Data Source=myOracleDB;User Id=Username;Password=user_Password;Min Pool Size=12;Connection Lifetime=240;Connection Timeout=70;Incr Pool Size=7;Decr Pool Size=3;
The Incr Pool Size determines the number of new connections to be made when they are required. The Decr Pool Size determines the maximum number of connections that can be closed every 3 minutes. (3 minutes is by default)
You may also want to read these related articles.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here