Summary of Oracle driver resources and environment variables
These types of resources and environment variables are available to use with the LN Oracle database driver:
- Client and server resources that are used by all LN database drivers.
- Client resources that are used by all LN database drivers.
- Server resources hat are used by all LN database drivers.
- Resources that are used only by the LN Oracle database driver.
- Resources that are passed to the Oracle database server.
The tables provide a summary of each of these resources and environment variables. Detailed descriptions of each entry in the tables are available later.
| Client and server resources that are used by all LN database drivers | ||
|---|---|---|
| Resource name | Environment variable | Description |
baan_sql_cacherows |
BAAN_SQL_CACHEROWS |
Defines the size of internal buffers in the query processor |
baan_sql_trace |
BAAN_SQL_TRACE |
To view SQL query information |
enable_refmsg |
ENABLE_REFMSG |
Causes logging of denied updates of delete actions |
rds_full |
RDS_FULL |
Sets maximum number of rows that are transferred in one block |
tt_sql_trace |
TT_SQL_TRACE |
To view SQL query information |
use_shm_info |
USE_SHM_INFO |
Enables or disables shared memory use |
| Client resources that are used by all LN database drivers | ||
|---|---|---|
| Resource name | Environment variable | Description |
baan_sql_stmt_cache_size |
BAAN_SQL_STMT_CACHE_SIZE |
Defines the size of the query cache |
bdb_debug |
BDB_DEBUG |
Sets the debugging link between client and server |
bdb_driver |
BDB_DRIVER |
Sets database specifications |
bdb_max_server_schedule |
BDB_MAX_SERVER_SCHEDULE |
Defines the mechanism to stop idle database drivers |
bdb_use_row_version |
Use a row version column to optimize delayed row locking. | |
ssts_set_rows |
SSTS_SET_ROWS |
Sets number of rows read ahead, single table single row |
| - | USR_DBC_RES |
Specifies alternative resource file for client |
| Server resources that are used by all LN database drivers | ||
|---|---|---|
| Resource name | Environment variable | Description |
bdb_max_sessions |
BDB_MAX_SESSIONS |
Defines the number of sessions per driver |
bdb_max_session_schedule |
BDB_MAX_SESSION_SCHEDULE |
Defines the mechanism to close idle driver sessions |
dbslog |
DBSLOG |
To perform driver profiling |
| - | DBSLOG_LOCK_PROF |
Specifies the lock time after which locks are logged |
dbslog_name |
DBSLOG_NAME |
To specify the file name for logging |
dbsinit |
DBSINIT |
Deprecated |
hint_index_weight_equal |
HINT_INDEX_WEIGHT_EQUAL |
Defines the equal-weight parameter for the query hint generation |
hint_index_weight_range |
HINT_INDEX_WEIGHT_RANGE |
Defines the range-weight parameter for the query hint generation |
hint_index_weight_factor |
HINT_INDEX_WEIGHT_FACOR |
Defines the weight-factor parameter for the query hint generation |
max_sql_input_binds |
MAX_SQL_INPUT_BINDS |
To adjust the size of internal ‘where bind’ buffers. |
shm_max_dd_cache_size |
SHM_MAX_DD_CACHE_SIZE |
Defines the maximum size of the database driver DD cache |
mle_join_type |
MLE_JOIN_TYPE |
Specifies join type between data table and shadow table, with translations, in a Multi Language Enabled (MLE) environment. |
query_comments |
QUERY_COMMENTS |
To trace used connections in the database server. |
table_load_array_size |
TABLE_LOAD_ARRAY_SIZE |
Defines the maximum number of rows that are inserted during data load. |
| - | USR_DBS_RES |
Specifies alternative resource file for server |
| Resources that are used only by the LN Oracle database driver | ||
|---|---|---|
| Resource name | Environment variable | Description |
ansi_outer_join |
ANSI_OUTER_JOIN |
To alter the generated SQL syntax for outer-joins. |
baan_oracle_prefetch |
BAAN_ORACLE_PREFETCH |
To alter Oracle’s pre-fetch behavior. |
connection_pooling |
CONNECTION_POOLING |
To choose between shared or dedicated Oracle sessions. |
ora_alter_session |
ORA_ALTER_SESSION |
To change Oracle session settings. |
ora_init |
ORA_INIT |
Defines several driver behaviors |
ora_max_array_fetch |
ORA_MAX_ARRAY_FETCH |
Defines the maximum number of rows that are fetched |
ora_max_array_insert |
ORA_MAX_ARRAY_INSERT |
Defines the maximum number of rows that are inserted |
ora_parallel_degree |
ORA_PARALLEL_DEGREE |
Enables parallel index creation and statistics generation |
oraprof |
ORAPROF |
Enables profiling |
orastat |
ORASTAT |
To gather statistics. |
ora_hint_no_hints |
ORA_HINT_NO_HINTS |
Disable the generation of query hints |
ora_timeout |
ORA_TIMEOUT |
Sets the time-out value |
ora_use_varchar |
ORA_USE_VARCHAR |
Use the Oracle VARCHAR2/NVARCHAR2 data type for string data |
os_authent_prefix |
OS_AUTHENT_PREFIX |
Defines prefix for Oracle’s operating system authentication |
retained_cursors |
RETAINED_CURSORS |
Defines the number of retained cursors |
sql_trace |
SQL_TRACE |
Enables Oracle’s trace facility |
| Resources that are used only by the LN Oracle maintenance program | ||
|---|---|---|
| Resource name | Environment variable | Description |
ora_default_tablespace |
ORA_DEFAULT_TABLESPACE |
To set a default tablespace for newly created Oracle users. |
ora_temporary_tablespace |
ORA_TEMPORARY_TABLESPACE |
To set a temporary tablespace for newly created Oracle users |
| Resources that are passed to the LN Oracle database server | ||
|---|---|---|
| Resource name | Environment variable | Description |
nls_comp |
NLS_COMP |
Sets Oracles nls_comp parameters |
nls_lang |
NLS_LANG |
Sets Oracles NLS parameters |
nls_sort |
NLS_SORT |
The type of sort to use |
oracle_home |
ORACLE_HOME |
Sets Oracle’s
|
oracle_local_template |
ORACLE_LOCAL_TEMPLATE |
Oracle8 only: The default connect template to connect to a local database |
oracle_service_name |
ORACLE_SERVICE_NAME |
Specifies the Oracle database to connect to |
oracle_sid |
ORACLE_SID |
Sets Oracle’s ORACLE_SID |