Invantive Data Hub
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 |
✓ |
✓ |
✓ |
