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
|