This appendix describes the initialization parameters that are automatically configured after installing Tibero. For details about the parameter, refer to “Chapter 1. Introduction to Initialization Parameters”.
The following is an example of an initialization parameter configuration file.
<$TB_SID.tip>
DB_NAME=$TB_SID LISTENER_PORT=8629 CONTROL_FILES="$TB_HOME/database/tibero/c1.ctl" DB_CREATE_FILE_DEST="$TB_HOME/instance/$TB_SID/database" DBWR_CNT=1 DBMS_LOG_TOTAL_SIZE_LIMIT=300M TRACE_LOG_TOTAL_SIZE_LIMIT=300M WTHR_PROC_CNT=1 _WTHR_PER_PROC=10 TOTAL_SHM_SIZE=320M DB_BLOCK_SIZE=8K DB_CACHE_SIZE=256M LOG_BUFFER=10M LOG_LVL=4 SQL_LOG_ON_MEMORY=Y
The following describes each parameter configured based on the Horde configuration from the previous example.
| Parameter | Description |
|---|---|
DB_NAME | Database name.(Default value: tibero) |
CONTROL_FILES | Absolute path where a control file is located. |
DB_CREATE_FILE_DEST | Absolute path where a data file is located. |
DBWR_CNT | Number of the processes that use database blocks on the disk. (Default value:1) |
DBMS_LOG_TOTAL_SIZE_LIMIT | Maximum DBMS log file size. |
TRACE_LOG_TOTAL_SIZE_LIMIT | Maximum trace log file size. |
WTHR_PROC_CNT | Number of worker processes. |
_WTHR_PER_PROC | Number of worker processes to allocate to a single worker process. |
TOTAL_SHM_SIZE | Total shared memory size to use in the database instance. The shared pool size should be set to a value
that is slightly bigger than |
DB_BLOCK_SIZE | Block size of the database. |
DB_CACHE_SIZE | Cache buffer size of the database. |
LOG_BUFFER | Memory size to store logs. |
LOG_LVL | Logging level. The higher the level is, the more the logs are stored. Note that setting a higher logging level can affect database performance. |
SQL_LOG_ON_MEMORY | Option to store the SQL logs cached in the memory of each worker thread as a file when an error occurs.
|
According to the environment of the system, initialization parameters may vary and additional parameters can be specified.
1. According to the environment of the system, initialization parameters may vary and additional parameters can be specified.
2. To set TOTAL_SHM_SIZE and MEMORY_TARGET, enter M and G for megabyte and gigabyte units. For bytes, just enter numbers.