Difference between the MaxPoolSize and the OciSessionMaxSize

Difference between the MaxPoolSize and the OciSessionMaxSize

Postby 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.)
histu
 
Posts: 7
Joined: Fri 09 Oct 2009 08:57

Postby 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.
Shalex
Devart Team
 
Posts: 7343
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle