Pooling Wisely for Oracle Data Provider for .NET

By Anoop Madhusudanan

Vote on HN
Use the Decr Pool Size and Incr Pool Size properties wisely when you use ODP pooling.

Decr Pool Size Controls the number of connections that are closed when an excessive amount of established connections are unused, and Incr Pool Size Controls the number of connections that are established when all the connections in the pool are used.

When a connection pool is created, the connection-pooling service initially creates the number of connections defined by the Min Pool Size attribute of the ConnectionString, and then Incr/Decr pool size properties are used to maintain the connections pooled.

The values for Incr/Decr pool size should be based on your Min Pool Size and Max Pool Size values. Eg: "User Id=scott;Password=tiger;Data Source=oracle; Min Pool Size=10; Max Pool Size=1200;Connection Lifetime=120;Connection Timeout=60; Incr Pool Size=10; Decr Pool Size=5";

No comments:

Post a Comment

Please keep your comments clean.

© 2012. All Rights Reserved. Amazedsaint.com