Please enable JavaScript to view this site.

Navigation: Invantive SQL > Providers

Provider OracleManaged: Oracle .NET driver-based provider.

Oracle .NET driver-based provider.

Code for use in settings.xml: OracleManaged

Alias: oracle

Status: Production

Available in Editions: Paid

Additional Driver to install: https://support.invantive.com/download-driver-oracle

Provider Attributes

The following provider attributes are available for OracleManaged:

Code

Description

Default Value

Set from Connection String

Set from Set SQL-Statement

Set from Providers File

command-timeout-sec

Number of seconds after which a command times out.

 

connection-string-self-tuning-add

Should the 'Self Tuning' be added automatically to the connection string?

True

connection-string-self-tuning-value

Value of self tuning to be added to the connection string

True

connection-string-statement-cache-size-add

Should the 'Statement Cache Size' be added automatically to the connection string?

True

connection-string-statement-cache-size-value

Size of the statement cache size to be added to the connection string

250

force-case-sensitive-identifiers

Consider identifiers as case-sensitive independent of the platform capabilities.

False

forced-casing-identifiers

Forced casing of identifiers. Choose from Unset, Lower, Upper and Mixed.

 

invantive-sql-forward-filters-to-data-containers

Whether to forward filters to data containers.

True

invantive-sql-shuffle-fetch-results-data-containers

Whether to shuffle results fetched from data containers.

False

invantive-use-cache

Whether to cache the results of a query.

True

maximum-length-identifiers

Non-default maximum length in characters of identifier names.

 

maximum-number-of-pooled-connections

Maximum number of concurrent pooled connections.

 

maximum-sleep-acquire-pooled-connection-ms

Maximum time in ms to wait for acquiring a free connection from a pool of connections.

30000

maximum-sleep-acquire-unpooled-connection-ms

Maximum time in ms to wait for acquire a free connection when there is no connection pooling.

60000

preferred-number-of-pooled-connections

Preferred number of concurrent pooled connections.

 

prefix-bind-variable-in-list

Prefix for bind variables used in an IN-list

i

prefix-bind-variable-normal

Prefix for bind variables used in all cases except in an IN-list

w

prefix-renamed-columns

Prefix appended to columns whose names occur multiple times in the column list of a query

column

pre-request-delay-ms

Pre-request delay in milliseconds per request.

0

requests-parallel-max

Maximum number of parallel data requests from individual partitions on the data container.

32

return-null-on-ora-22288

Return a null value instead of an exception when Oracle returns ORA-22288 when querying a bfile column

False

slot-based-rate-limit-length-ms

Length in ms of a slot-based rate limit.

60000

 

slot-based-rate-limit-slots

Number of slots of a slot-based rate limit. Null means no slot-based rate limit

 

 

standardize-identifiers

Rewrite all identifiers to the preferred standards as configured by standardize-identifiers-casing and maximum-length-identifiers.

True

standardize-identifiers-casing

Rewrite all identifiers to the recommended standard platform-specific casing when changing a data model on a case-dependent platform.

True

trace-native-calls

Trace native calls to data container backend.

False