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.
  • 2074

Introduction

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)

Further Readings

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.