Skip to content

Instantly share code, notes, and snippets.

@jzi96
Created May 11, 2015 13:35
Show Gist options
  • Save jzi96/dac53d58dbd52dadfd09 to your computer and use it in GitHub Desktop.
Save jzi96/dac53d58dbd52dadfd09 to your computer and use it in GitHub Desktop.
Oracle Managed Data Provider .NET enable options (tested with 4.121.2.0)
<configuration>
<configSections>
<section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler,Oracle.ManagedDataAccess" />
</configSections>
<oracle.manageddataaccess.client>
<version number="*">
<settings>
<setting name="PerformanceCounters" value="4095"/>
<setting name="TraceFileLocation" value="c:\temp"/>
<setting name="TraceLevel" value="7"/>
<setting name="TraceOption" value="0"/>
</settings>
</version>
</oracle.manageddataaccess.client>
<!--
https://docs.oracle.com/html/E41125_02/featConfig.htm
ODP.NET, Managed Driver configuration settings that are supported:
* DbNotificationPort
* DemandOraclePermission
* FetchSize
* MaxStatementCacheSize
* MetaDataXml
* NAMES.DIRECTORY_PATH: The default search order is TNSNAMES and EZCONNECT. TNSNAMES, LDAP, and EZCONNECT are the only name resolution methods supported, but their precedence order can be modified.
* NAMES.LDAP_AUTHENTICATE_BIND
* NAMES.LDAP_CONN_TIMEOUT
* NODELAY
* ORACLE_SID
* PerformanceCounters
* SelfTuning
* SQLNET.AUTHENTICATION_SERVICES : Only supported values are NTS and null, empty, or not-specified.
* StatementCacheSize
* SSL_VERSION
* TNS_ADMIN : Location where either one or more of tnsnames.ora, ldap.ora, and sqlnet.ora are located.
* TraceFileLocation : Trace file destination location. This is different from ODP.NET, Unmanaged Driver, which supports TraceFileName.
* TraceLevel : 1 = public APIs; 2 = private APIs; 4 = network APIs/data. These values can be ORed. To enable everything, set TraceLevel to 7. Errors will always be traced.
* TraceOption
* TCP.CONNECT_TIMEOUT
* WALLET_LOCATION : Microsoft Certificate Store (MCS) and file system wallets are supported
-->
</configuration>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment