Difference between the MaxPoolSize and the OciSessionMaxSize

histu · Post by **histu** » Tue 07 Sep 2010 08:56

Hello,

There are two properties which can be used in a connectionstring: MaxPoolSize, OciSessionPoolMaxSize. What is the difference between them? What is the difference between a connection and a session?

Thank you for your information in advance.

Istvan Hegyes
(L-Soft Kft.)

Shalex · Post by **Shalex** » Wed 08 Sep 2010 12:06

Pooling is a parameter of connection string that enables/disables provider's pooling. This pooling is implemented in dotConnect for Oracle and can be used in the Direct and OCI modes. By default, it is turned on.

Oci Session Pooling enables/disables pooling that is implemented in Oracle Client. By default, it is turned off. If Oci Session Pooling=true, the dotConnect for Oracle pool is disabled.

So, Max Pool Size is a setting for the dotConnect for Oracle pool, OciSessionPoolMaxSize is an option for the Oracle Client pool. For more information, please refer to our documentation.

Connection and session are synonyms.