Monday, November 12, 2007

Pooling Wisely for Oracle Data Provider for .NET

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";

1 comment:

Anonymous said...

Right here is the perfect website for everyone who wishes to understand this topic.

You realize so much its almost tough to argue with you (not that I actually would want
to…HaHa). You certainly put a new spin on a topic which has
been written about for ages. Wonderful stuff,
just excellent!
My site: ikea furniture assembly service

Articles - Design Patterns, Neural Networks, C#, Programming