[ C# ] Provider=OraOLEDB.Oracle Connection Pool

From oracle site that link to MS site,

Default services enabled DBPROP_INIT_OLEDBSERVICES

property value

All services (default) DBPROPVAL_OS_ENABLEALL
All except pooling and automatic transaction enlistment (DBPROPVAL_OS_ENABLEALL & ~DBPROPVAL_OS_TXNENLISTMENT & ~DBPROPVAL_OS_RESOURCEPOOLING)
All except pooling (DBPROPVAL_OS_ENABLEALL &

~DBPROPVAL_OS_RESOURCEPOOLING)

All except automatic transaction enlistment (DBPROPVAL_OS_ENABLEALL &

~DBPROPVAL_OS_TXNENLISTMENT)

All except Client Cursor Engine (DBPROPVAL_OS_ENABLEALL & ~DBPROPVAL_OS_CLIENTCURSOR)
All except pooling, automatic transaction enlistment, and Client Cursor Engine (DBPROPVAL_OS_ENABLEALL & ~DBPROPVAL_OS_RESOURCEPOOLING & ~DBPROPVAL_OS_TXNENLISTMENT & ~DBPROPVAL_OS_CLIENTCURSOR)
Pooling and automatic transaction enlistment only, session level aggregation only DBPROPVAL_OS_TXNENLISTMENT & DBPROPVAL_OS_RESOURCEPOOLING
No services DBPROPVAL_OS_DISABLEALL
Default services enabled Value in connection string
All services (default) “OLE DB Services = -1;”
All except pooling and automatic transaction enlistment “OLE DB Services = -4;”
All except Client Cursor Engine “OLE DB Services = -5;”
All except pooling, automatic transaction enlistment, and Client Cursor Engine “OLE DB Services = -8;”
Pooling and automatic transaction enlistment only, session level aggregation only “OLE DB Services = 3;”
No services “OLE DB Services = 0;”

We noticed that Oracle pooling is enabled by default.

Quote from Oracle site, “By default, the OLEDB_SERVICES registry entry for OraOLEDB is set, under the CLSID of OraOLEDB, to 0xffffffff (that is, -1), which enables all services. Certain OLE DB Services can also be disabled or enabled programmatically through the DBPROP_INIT_OLEDBSERVICES property setting.”

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s