Devart Forums

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.)

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.