Oracle driver specific resources
| ansi_outer_join / ANSI_OUTER_JOIN | |
|---|---|
| Driver resource | ansi_outer_join |
| Environment variable | ANSI_OUTER_JOIN |
| Client/Server resource | Set for server only |
| Type | Boolean |
| Default | 1 |
| Description |
This resource is deprecated, and is removed in a future release. This variable influences the generated Oracle SQL for queries that contain outer joins. If you enable this variable, the database driver generates Oracle SQL that complies with the ANSI syntax. If the variable is disabled, the driver generates the Oracle proprietary syntax. This resource must be enabled when the applications uses the Document Authorization (DBCM) feature or the Multi Data Language (MLE) feature. |
| baan_oracle_prefetch / BAAN_ORACLE_PREFETCH | |
|---|---|
| Driver resource | baan_oracle_prefetch |
| Environment variable | BAAN_ORACLE_PREFETCH |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | 1: Equal to the Oracle default |
| Description | This variable influences the number of records that are pre-fetched by the Oracle client libraries used by the Oracle driver.
For more detailed information, see the Oracle documentation: OCI_ATTR_PREFETCH_ROWS |
| connection_pooling / CONNECTION_POOLING | |
|---|---|
| Driver resource | connection_pooling |
| Environment variable | CONNECTION_POOLING |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | 1 |
| Description | This resource controls the sharing of Oracle sessions between LN sessions. When enabled, all read-only database access shares a single Oracle session. Any access that causes a change or a lock in the database temporarily switches to another Oracle session.
When disabled all LN sessions have their own dedicated Oracle session. |
| ora_alter_session/ORA_ALTER_SESSION | |
|---|---|
| Driver resource | ora_alter_session |
| Environment variable | ORA_ALTER_SESSION |
| Client/Server resource | Set for server only |
| Type | String |
| Default | Not set |
| Description | After you set this resource, the Oracle driver issues an alter session <resource value> command directly after each logon to Oracle.
You can use this command for support purposes. You can change the Oracle session settings for a particular driver without having to change the generic Oracle settings. For a description of the supported SQL syntax, see the Oracle Server SQL reference document. |
| ora_hint_no_hints/ORA_HINT_NO_HINTS | |
|---|---|
| Driver resource | ora_hint_no_hints |
| Environment variable | ORA_HINT_NO_HINTS |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | 0 |
| Description | When set, this resource disables the query hint generation of the Oracle driver. Only queries that have explicit query hints specified in the application source get an Oracle hint. All other hints are suppressed, |
| ora_init / ORA_INIT | |
|---|---|
| Driver resource | ora_init |
| Environment variable | ORA_INIT |
| Client/Server resource | Set for server only |
| Type | Integer (octal) |
| Default | 0011000: Specifies fixed char type and explicit inserts. |
| Description | This resource defines several driver behaviors. To select multiple behaviors, you can add the octal values.
|
| ora_max_array_fetch / ORA_MAX_ARRAY_FETCH | |
|---|---|
| Driver resource | ora_max_array_fetch |
| Environment variable | ORA_MAX_ARRAY_FETCH |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | 5 |
| Description | This resource defines the maximum number of rows immediately fetched from the Oracle RDBMS. The query hint “array size <n>” overrules this default setting. To disable the array interface, set ora_max_array_fetch:1. |
| ora_max_array_insert / ORA_MAX_ARRAY_INSERT | |
|---|---|
| Driver resource | ora_max_array_insert |
| Environment variable | ORA_MAX_ARRAY_INSERT |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | 1 |
| Description | This environment variable defines the maximum number of rows immediately inserted in Oracle. Note that you cannot always enable this option. For example, you cannot perform an array insert in these situations:
See |
| ora_parallel_degree / ORA_PARALLEL_DEGREE | |
|---|---|
| Driver resource | ora_parallel_degree |
| Environment variable | ORA_PARALLEL_DEGREE |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | 4 |
| Description | If you specify a value greater or equal to 1, the database driver adds a PARALLEL <n> clause to the generated CREATE INDEX statements. The value is also passed to the SQL function that generates statistics for a table. This resource is introduced in porting set 9.0a.01 |
| oraprof / ORAPROF | |
|---|---|
| Driver resource | ora_prof |
| Environment variable | ORAPROF |
| Client/Server resource | Set for server only |
| Type | Floating point |
| Default | Not set |
| Description | If you specify a value in this variable, each phase in the SQL query processing that exceeds the number of seconds specified is logged. The maximum precision you can specify is 0.01 seconds. |
| orastat / ORASTAT | |
|---|---|
| Driver resource | orastat |
| Environment variable | ORASTAT |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | Not set |
| Description | With this variable you can report database driver statistics. If set to a value n greater than 0, statistics are logged every n seconds when the driver is active. If set to 0, a statistics report is generated when the driver terminates. |
| ora_timeout / ORA_TIMEOUT | |
|---|---|
| Driver resource | ora_timeout |
| Environment variable | ORA_TIMEOUT |
| Client/Server resource | Set for server only |
| Type | String |
| Default | None |
| Description | This resource specifies the lock wait period for specific actions. For more information on locking behavior and setting timeouts, see Statement and lock timeouts. |
| ora_use_varchar / ORA_USE_VARCHAR | |
|---|---|
| Driver resource | ora_use_varchar |
| Environment variable | ORA_USE_VARCHAR |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | 0 |
| Description | This variable controls the mapping between the LN string data type and the Oracle string data type. If this variable is set to 0, string columns are created and handled as the CHAR or NCHAR Oracle data type.
If this variable is set to 1, string columns are created and handled as the Because these Oracle data types have different functional behaviors, the LN Oracle driver interfaces differently to Oracle depending on the value of this resource. |
| os_authent_prefix / OS_AUTHENT_PREFIX | |
|---|---|
| Driver resource | os_authent_prefix |
| Environment variable | OS_AUTHENT_PREFIX |
| Client/Server resource | Set for server only |
| Type | String |
| Default | ops$ |
| Description | With this variable, you can define the prefix for Oracle's operating system authentication. You can define the prefix in the Oracle init<SID>.ora parameter file also. |
| retained_cursors / RETAINED_CURSORS | |
|---|---|
| Driver resource | retained_cursors |
| Environment variable | RETAINED_CURSORS |
| Client/Server resource | Set for server only |
| Type | Integer |
| Default | 50 |
| Description | This resource sets the number of inactive cursors that must be retained in the list for reuse by session.
For more information on cursor management, see Cursor management. Note that all application sessions, that share the same database connection, share the same inactive cursor pool. |
| sql_trace / SQL_TRACE | |
|---|---|
| Driver resource | sql_trace |
| Environment variable | SQL_TRACE |
| Client/Server resource | Set for server only |
| Type | String |
| Default | Not set |
| Description | With this resource you can enable the Oracle trace facility. To enable the facility, set the value to True. |