OracleConnection Properties

OracleConnection properties are listed in Table 7-48

Table 7-48 OracleConnection Properties

Property Description

AccessToken

Used to get or set OracleAccessToken on the connection

ActionName

Specifies the action name for the connection

ChunkMigrationConnectionTimeout

This setting pauses the connection request until the migration completes or fails to migrate in the specified time, then connect to the correct shard with the data requested.

Not Available in ODP.NET, Unmanaged Driver

ClientId

Specifies the client identifier for the connection

ClientInfo

Specifies the client information for the connection

ConnectionString

Specifies connection information used to connect to an Oracle database

ConnectionTimeout

Indicates the maximum amount of time that the Open method can take to obtain a pooled connection before the request is terminated

ConnectionType

Determines whether a particular connection object is associated with a TimesTen database connection, an Oracle database connection, or no physical connection

Not Available in ODP.NET, Managed Driver and ODP.NET Core

Container

Inherited from System.ComponentModel.Component

Credential

Used to get or set an OracleCredential object on the connection

Database

Not Supported

DatabaseDomainName

Specifies the name of the database domain to which the connection is set

DatabaseEditionName

Sets or gets the edition name for the OracleConnection object

DatabaseName

Specifies the name of the database to which the connection is set

DataSource

Specifies the Oracle Net Services Name, Connect Descriptor, or an easy connect naming that identifies the database to which to connect

DRCPConnectionClass

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

DRCPPurity

Specifies whether an application can reuse a pooled session (Pooled) or must use a new session (New)

HostName

Specifies the name of the host to which the connection is set

InstanceName

Specifies the name of the instance to which the connection is set

KeepAlive

Specifies whether to keep an idle connection alive.

Not Available in ODP.NET, Unmanaged Driver

KeepAliveInterval

Specifies the time interval after an unacknowledged probe before a new probe is sent.

Not Available in ODP.NET, Unmanaged Driver

KeepAliveTime

Specifies the idle time before a keepalive probe is sent.

Not Available in ODP.NET, Unmanaged Driver

ModuleName

Specifies the module name for the connection

PDBName

Used to set and get the name of the pluggable database to which the session is connected to

ProviderVersion

Specifies the ODP.NET assembly version

ServerVersion

Specifies the version number of the Oracle database to which the OracleConnection has established a connection

ServiceName

Specifies the name of the service to which the connection is set

Site

Inherited from System.ComponentModel.Component

State

Specifies the current state of the connection

StatementCacheSize

Specifies the current size of the statement cache associated with this connection

SwitchedConnection

If the returned pooled connection changed its service name (ServiceName) or pluggable database (PDBName) in order to connect to the desired pluggable database, then this property will consider the connection switched.

TnsAdmin

Specifies the directory location of tnsnames.ora or sqlnet.ora, or both

Not Available in ODP.NET, Unmanaged Driver

TokenAuthentication

Sets the value for TOKEN_AUTH parameter for the connection

TokenLocation

Gets or sets the token location path for the connection where the signature token and private key files are located

UseHourOffsetForUnsupportedTimezone

Specifies whether the hour offset can be used for the session time zone, when the Oracle time zone region name that is associated with the .NET locale is not supported by the Oracle database being used

Not Available in ODP.NET, Unmanaged Driver

WalletLocation

Specifies the location of wallets. Wallets are certificates, keys, and trustpoints processed by SSL/TLS

Not Available in ODP.NET, Unmanaged Driver