CacheType | Type of cache used to store the rowset data on the client. Possible values: Memory or File |
ChunkSize | Size of LONG or LONG RAW column data stored in the provider's cache. The range of allowed values is 1 … 65536, the default is 100. |
DistribTX | enable or disables distributed transaction enlistment capability. Possible values: 0 and 1 (1 being the default) |
FetchSize | number of rows that will be fetched at a time. Possible values seem to be 1 … 496 (?), default seems to be 100. |
OLEDB.NET | enables or disables compatibility with OLEDB.NET Data Provider. Values: True or False |
OSAuthent | whether operating system authentication will be used when connecting to an Oracle Database. Values: 0 or 1 , default being 1 |
PLSQLRSet | enable or disables the return of a rowset from PL/SQL stored procedures. |
PwdChgDlg | enable or disables displaying the password change dialog box when the password expires. |
UseSessionFormat | specifies whether to use the default NLS session formats or let OraOLEDB override some of these formats for the duration of the session. Possible values: 0 (default) and 1 (TRUE). This attribute does not appear under HKLM\SOFTWARE\ORACLE\KEY_HOMENAME\OLEDB . |
VCharNull | enables or disables the NULL termination of varchar2 out parameters from stored procedures. |
SPPrmDefVal | specifies whether to use the default value or a NULL value if the application has not specified a stored procedure parameter value. |
NDataType | whether any of the parameters bound to the command are of N data types, which include nchar , nvarchar2 or nclob . This attribute does not appear under HKLM\SOFTWARE\ORACLE\KEY_HOMENAME\OLEDB . |
SPPrmsLOB | whether one or more parameters bound to the stored procedures are of LOB data type. This attribute does not appear under HKLM\SOFTWARE\ORACLE\KEY_HOMENAME\OLEDB . |
StmtCacheSize | specifies the maximum number of statements that can be cached. |
MetaDataCacheSize | the maximum number of select statements for which the metadata can be cached. Possible values are 0 … 10 (default: 10) |
DeferUpdChk | whether or not to defer the updateability check to support updating read-only disconnected rowsets. Possible values are 0 and 1 |
DBNotifications | whether or not to subscribe to the high availability events. |
DBNotificationPort | port number which is opened to listen to the Database notifications. (Enhanced Failover Capability) |