6.4.1 OracleConfiguration Members

OracleConfiguration members are listed in the following tables.

OracleConfiguration Connection Properties

OracleConfiguration Connection properties are listed in Table 6-24.

Table 6-24 OracleConfiguration Connection Properties

Property Description

DatabaseEditionName

Specifies the Oracle edition name for the connection object

DisableOOB

Specifies whether to enable Oracle Net Services to send or receive out-of-band break messages using urgent data provided by the underlying protocol

DrcpConnectionClass

Specifies a logical name that identifies the DRCP connection pool that the ODP.NET connection will use

HostnameDefaultServiceIsHost

Specifies whether to default the service name to the hostname in Oracle Easy Connect Naming so that the service name does not need to be specified

NamesDirectoryPath

Specifies the naming method order used for client name resolution lookups

OracleDataSources

Returns a collection of TNS entries added through OracleConfiguration

TcpConnectTimeout

Specifies the time, in seconds, for a client to establish a TCP connection (PROTOCOL=tcp in the TNS connect address) to the database server before it can time out

TnsAdmin

Specifies the tnsnames.ora and/or sqlnet.ora directory location

OracleConfiguration Secure Connection Properties

OracleConfiguration Secure Connection Properties are listed in Table 6-25.

Table 6-25 OracleConfiguration Secure Connection Properties

Property Description

SqlNetAuthenticationServices

Enables one or more authentication services, such as TCP/IP with SSL

SqlNetEncryptionClient

Specifies the encryption client behavior

SqlNetEncryptionTypesClient

Specifies encryption algorithms that the client can use

SqlNetCryptoChecksumClient

Specifies the checksum client behavior

SqlNetCryptoChecksumTypesClient

Specifies the crypto-checksum algorithms the client can use

SqlNetWalletOverride

Specifies whether the client overrides the strong authentication credential with the stored wallet password credential for the database connection

SSLServerDNMatch

Enforces the database server distinguished name (DN) matches its service name

SSLVersion

Enforces the connection to use a specific SSL/TLS version

WalletLocation

Specifies the location of wallets

OracleConfiguration Command Properties

OracleConfiguration Command properties are listed in Table 6-26.

Table 6-26 OracleConfiguration Command Properties

Property Description

BindByName

Specifies whether the binding method used for the parameter collection is by name or by position

CommandTimeout

Specifies the number of seconds the command is allowed to execute before terminating the execution with an exception

OracleConfiguration High Availability Properties

OracleConfiguration High Availability properties are listed in Table 6-27.

Table 6-27 OracleConfiguration High Availability Properties

Property Description

DbNotificationAddress

Specifies the address that the provider listens to for all notifications sent by the database for continuous query notification feature.

DbNotificationPort

Specifies the port number that the provider listens to for all notifications sent by the database for continuous query notification, Fast Connection Failover, and/or Runtime Connection Load Balancing features

HAEvents

Enables the application to receive Fast Connection Failover events for maintaining application high availability

OnsConfigFile

Specifies the configuration file to define Oracle Notification Service (ONS) behavior

OnsMode

Specifies the ONS daemon mode as either local or remote

OracleOnsServers

Returns a collection of logical ONS servers added through OracleConfiguration

ServiceRelocationConnectionTimeout

Specifies the time to wait before retrying connecting to a service that becomes unavailable.

OracleConfiguration Performance Properties

OracleConfiguration Performance properties are listed in Table 6-28.

Table 6-28 OracleConfiguration Performance Properties

Property Description

FetchSize

Specifies the total memory size, in bytes, that the provider allocates to cache data fetched in one database round-trip

LoadBalancing

Enables the application to receive runtime connection load balancing information

MaxStatementCacheSize

Specifies the maximum number of statements that can be cached when self-tuning is enabled

ReceiveBufferSize

Specifies the buffer space limit for receive operations of sessions

SelfTuning

Specifies whether self-tuning is enabled for an ODP.NET application

SendBufferSize

Specifies the buffer space limit for send operations of sessions

StatementCacheSize

Specifies the number of cursors or statements to be cached for each database connection

TcpNoDelay

Preempts delays in buffer flushing within the TCP/IP protocol stack

OracleConfiguration Debug Tracing Properties

OracleConfiguration Debug Tracing properties are listed in Table 6-29.

Table 6-29 OracleConfiguration Debug Tracing Properties

Property Description

TraceFileLocation

Specifies the destination directory to output provider traces

TraceLevel

Specifies the generated trace level to trace ODP.NET calls and diagnose provider issues

TraceOption

Specifies whether to generate a single trace file or multiple trace files for multithreaded applications