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. |