Table of Contents
An initialization parameter describes a Tibero instance and database configuration. It is provided with a text file and required to create a Tibero.
An initialization parameter file is a text file, with a filename in the form XX.tip (where XX is the name of the database), needed when creating a database. It can be edited using a document editor provided with the operating system. Once the initialization parameter file is modified, the database must be restarted to apply the modification to the entire system.
However, not all initialization parameters require the restarting of the database after their modification. Some parameters can be modified while being used by an instance. These parameters are applied only to the current instance, not the initialization parameter file.
The following is the list of information that can be configured in the initialization parameter file.
Below is an example of the initialization parameter file.
AUTHENTICATION_TIMEOUT = 0 CLUSTER_DATABASE = N EX_WORKAREA_CACHE_SIZE = 100
This section explains the class attributes necessary for users to understand the information configured in the initialization parameter file.
This section describes initialization parameters in alphabetical order.
ACF_CMPT_CNT specifies the number of cluster message processing threads used by the ACSD (Active Cluster Service Deamon) process in parallel.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MAX(32, MIN(get_ncpu() * 3, 160)) |
Class | Optional, Persistent, Static, System |
Range |
ACTIVE_SESSION_HISTORY determines whether to gather statistics on active sessions.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
The maximum time, in seconds, that a session will remain active and wait for a client request. If there is no client request during this time, the server will disconnect the session. If this is set to 0, the server will never disconnect the session.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Dynamic, Session |
Range |
ACT_LOG_DEST specifies the directory where activity log files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
ACT_LOG_FILE_SIZE specifies the maximum size of each activity log file. If a single log file grows more than the size specified in this parameter, the current log file will be closed and a new file will be created.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 104857600 |
Class | Optional, Adjustable, Static, System |
Range | 100K - 1G |
AS_ADDR specifies the network address of the Active Storage instance to be accessed by the database instance.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "127.0.0.1" |
Class | Optional, Adjustable, Static, System |
Range |
AS_ALLOW_ONLY_RAW_DISKS specifies whether the Active Storage instance will only discover raw devices.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
AS_DISKSTRING specifies the absolute path of the disks that the Active Storage instance discovers.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | AS_DISKSTRING = discovery_string [, discovery_string] ... |
AS_PORT specifies the TCP port number of the Active Storage instance to be accessed by the database instance.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Static, System |
Range | 1024 - 65535 |
AS_WTHR_CNT specifies the number of threads used for Active Storage instance rebalancing. Increasing the number of threads increases rebalancing speeds but consumes more system resources.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Adjustable, Static, System |
Range |
AUDIT_FILE_DEST specifies the directory where AUDIT TRAIL files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Dynamic, System |
Range |
AUDIT_FILE_SIZE specifies the maximum size of each AUDIT TRAIL file. If a single AUDIT TRAIL file grows more than the size specified in this parameter, the current audit trail file will be closed and a new file will be created.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 104857600 |
Class | Optional, Adjustable, Static, System |
Range | 100K - 1G |
AUDIT_LOG_TOTAL_SIZE_LIMIT specifies the maximum total file size that can be stored in the directory set in AUDIT_LOG_DEST. Use this parameter to prevent database log files from growing endlessly by deleting the oldest files when the file size exceeds the specified value and hence reusing the database space.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 300 * 1024 * 1024 |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K - |
AUDIT_SYS_OPERATIONS determines whether to enables auditing for the SYS user.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
AUDIT_TRAIL specifies the method of auditing when the database auditing function is enabled.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "NONE" |
Class | Optional, Adjustable, Dynamic, System |
Range | NONE | DB | DB_EXTENDED | OS |
AUTHENTICATION_TIMEOUT specifies the timeout (in seconds) for client authentication when a client initializes a session. If a client has not completed the authentication protocol in the time specified, the server will close the connection.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0 - 100 |
Specifies the automatic coalesce. 0: Do not use. 1: Only LOB indexes. 2: All indexes.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 2 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0~2 |
AUTO_COALESCE_INTERVAL specifies the auto coalesce interval. The unit is 0.1 second.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 100 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0 ~ 3600000 (OFF / 0.1 second ~ 100 hours) |
Set the batch update operation mode.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1 |
Class | Optional, Adjustable, Dynamic, System |
Range |
BATCH_INSERT_ROWCNT_THRESHOLD specifies the number of rows for inserting the same information into multiple tables and indexes using the BATCH INSERT protocol.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 5 |
Class | Optional, Adjustable, Dynamic, System |
Range |
determines whether to enable Bind Variable Capture.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
specifies the number of slave allocators for bind variable capture.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 4 |
Class | Optional, Adjustable, Static, System |
Range |
specifies the time interval, in seconds, at which Bind Variable Capture will execute.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 600 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0 ~ 86400 |
determines whether to keep first bind variables of plans
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
specifies the maximum number of bind variables that Bind Variable Capture can store.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1000 |
Class | Optional, Adjustable, Dynamic, System |
Range | 10 ~ 1000000 |
specifies the maximum number of bind variables that can be captured from a query.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 512 |
Class | Optional, Adjustable, Dynamic, System |
Range |
a percentage of variables to be deleted from Bind Variable Capture pool.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Adjustable, Static, System |
Range |
specifies the size of pool for Bind Variable Capture.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 4*1024*1024 |
Class | Optional, Adjustable, Static, System |
Range |
BLOCK_CHANGE_TRACKING enables block change tracking for incremental backups.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range | |
Syntax | file |
BOOT_WITH_AUTO_DOWN_CLEAN specifies whether or not to automatically enable the tbdown clean process during tbboot.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
CALLSTACK_DUMP_DEST specifies the directory to which callstack dump files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Static, System |
Range |
CCC_CATH_CNT specifies the number of asynchronous cache task threads used by the Cluster Cache Control (CCC) in parallel.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1 |
Class | Optional, Persistent, Static, System |
Range |
CCC_MASTERING_UNIT specifies the number of continuous blocks to be specified in a single Master of the CCC (Cluster Cache Control) module. A base of 2 will be raised to the power of the integer specified in this parameter.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 7 |
Class | Optional, Persistent, Static, System |
Range |
CCC_RECL_MAX_RESOURCES specifies the maximum number of CCC resource blocks to be maintained in memory.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | (TB_CEIL_DIV((_CCC_RECL_MAX_DB_CACHE_SIZE / DB_BLOCK_SIZE), 100) * _CCC_RECL_MAX_RESOURCES_RATIO) |
Class | Optional, Persistent, Static, System |
Range |
CCC_RSBTBL_SIZE specifies the number of hash table buckets used for the CCC resource block. The number of blocks must be a square of 2.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | TB_CEIL(_DB_BLOCK_HASH_BUCKETS/8, 256) |
Class | Optional, Adjustable, Static, System |
Range |
CC_CU_BLKCNT specifies the maximum CC unit size in blocks.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 4 |
Class | Optional, Adjustable, Dynamic, System |
Range | 4 - 32 |
CC_CU_PCTUSE specifies the percentage of a single block that can be used in a compression unit. This will be adjusted while loading.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 99 |
Class | Optional, Adjustable, Dynamic, Session |
Range | 0 - 99 |
CC_EXPECTED_RATE specifies the percentage of a single block that can be used for row data. This will be adjusted while loading.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 25 |
Class | Optional, Adjustable, Dynamic, Session |
Range | 1 - 100 |
CC_TYPICAL_ROW_SIZE specifies the size of a typical row in a compression unit.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 100 |
Class | Optional, Adjustable, Dynamic, Session |
Range | 3 - 1000 |
CERTIFICATE_FILE specifies the location of the certificate files. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range | |
Syntax | CERTFICATE_FILE=filename[:filename [...] ] |
Determines whether to close remote sessions that are connected using a database link when resetting sessions (logical disconnection).
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
CLUSTER_DATABASE determines whether to configure TAC (Tibero Active Cluster) or not.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Persistent, Static, System |
Range |
CM_ENABLE_FAST_NET_ERROR_DETECTION specifies whether to turn on the function that rapidly recognizes the status change of other CM by detecting a network error.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
CM_FENCE determines whether to execute the CM fence daemon. To use this option, CM must be started with root privileges.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Persistent, Static, System |
Range |
Save location of the TBCM Guard log file. The location must be set as an absolute path in the local disk.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
CM_HEARTBEAT_EXPIRE specifies the length of the heartbeat expire used to control TBCM. The length must be a square of CM_TIME_UNIT. Heartbeat expire is the reference time that TBCM uses to detect possible failures in other nodes.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 300 |
Class | Optional, Adjustable, Static, System |
Range |
CM_LOG_DEST specifies the directory to which TBCM log files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
CM_LOG_FILE_SIZE specifies the maximum size of each TBCM log file. If a single log file grows more than the size specified in this parameter, the current log file will be closed and a new file will be created.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10485760 |
Class | Optional, Adjustable, Static, System |
Range | 100K - 1G |
CM_LOG_TOTAL_SIZE_LIMIT specifies the maximum total file size of logs files that can be stored in the directory set in CM_LOG_DEST. Use this parameter to prevent database log files from growing endlessly by deleting the oldest files when the file size exceeds the specified value and hence reusing the database space.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 300 * 1024 * 1024 |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K - INT64_MAX |
CM_MODE_OBSERVER determines whether to start CM in observer mode.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
CM_NAME specifies the name which identifies a local node in the cluster environment that consists of TBCM. The name must not be the same as the name of another node and is limited to 31 bytes in length. And a semicolon cannot be used in names. If not specified, it is set to tbcm by default.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Mandatory, Adjustable, Static, System |
Range |
CM_NET_EXPIRE_MARGIN specifies the network heartbeat expire for controlling CM. The value must be multiples of CM_TIME_UNIT.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 5 |
Class | Optional, Adjustable, Static, System |
Range |
CM_OBSERVER_PORT specifies the listen port to be used when CM starts in observer mode.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Persistent, Static, System |
Range | 1024 - 65535 |
CM_PORT specifies the port number to be used by TBCM. If two or more instances are running on a machine, the port number must be different from other instance.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | LISTENER_PORT + 3 |
Class | Optional, Adjustable, Static, System |
Range | 1024 - 65535 |
CM_RESOURCE_FILE specifies the path to the file that contains information about the resources registered in CM. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | filename |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
CM_RESOURCE_FILE_BACKUP specifies the path to back up the file in the CM_RESOURCE_FILE path. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | filename |
Default Value | "" |
Class | Optional, Persistent, Static, System |
Range |
CM_RESOURCE_FILE_BACKUP_INTERVAL specifies the interval (in minutes) for backing up the file in the CM_RESOURCE_FILE path to CM_RESOURCE_FILE_BACKUP path. If set to 0, backup is disabled.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Persistent, Static, System |
Range | 0 - 1440 |
CM_TIME_UNIT specifies the length of the time tick to be used to control TBCM. Other time-related parameters are represented in a multiple valued set in CM_TIME_UNIT and specified based on a 0.1 second time base.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Adjustable, Static, System |
Range |
CM_UI_PORT specifies the port information that CM uses to receive user commands.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Mandatory, Persistent, Static, System |
Range | 1024 - 65535 |
CM_VIP_FAILOVER_BASED_ON_SVC_STATUS determines the condition at which a VIP alias is created. If set to Y, the alias is created when a service instance is running.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
CM_WATCHDOG_EXPIRE specifies the expiration period used when the watchdog function between RDBMS and TBCM is enabled. If TBCM does not run for the specified time, RDBMS will be automatically terminated. The value set in this parameter should be smaller than the one specified in CM_HEARTBEAT_EXPIRE.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 290 |
Class | Optional, Persistent, Static, System |
Range |
COMMIT_FLUSH_REQUEST determines whether to flush the logs after every transaction commit or not.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, Session |
Range |
COMMIT_FLUSH_WAIT determines whether database commits wait for log flushes or not.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, Session |
Range |
COMMIT_POINT_STRENGTH specifies the value determining the commit point site in a distributed transaction.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1 |
Class | Optional, Persistent, Static, System |
Range | 0 - 255 |
CONTROL_FILES specifies the location of the control files. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Mandatory, Adjustable, Static, System |
Range | 1 - 8 files |
Syntax | CONTROL_FILES=filename[:filename [...] ] |
CPU_COUNT specifies the number of CPUs allowed for this instance.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Static, System |
Range |
Determines whether to create outline.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
CTHR_CHECK_CONNECTION_INTERVAL specifies the time interval (in seconds) that CTHR checks client connections.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 60 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 - 120 (s) |
CURRENT_SESSION_TEMP_TS specifies the name of the temporary tablespace that the current session is using. (Deprecated)
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, Session |
Range |
CURSOR_SHARING determines the kind of SQL statement which can share the same cursor. EXACT: Cursors can be shared only when the SQL text matches exactly. FORCE: Setting this parameter to FORCE forces similar SQL statements to share cursors as long as only their literals are different.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "EXACT" |
Class | Optional, Adjustable, Dynamic, Session |
Range | EXACT | FORCE |
CWS_RECL_MAX_RESOURCES specifies the maximum number of CWS (Cluster Wait-lock Service) resource blocks to be maintained in memory.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | (TB_CEIL_DIV(_WLOCK_POOL_INIT_SIZE, 100) * _CWS_RECL_MAX_RESOURCES_RATIO) |
Class | Optional, Persistent, Static, System |
Range |
CWS_RSBTBL_SIZE specifies the number of hash table buckets used for the CWS resource block. The number of buckets must be a square of 2.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | (_WLOCK_BUCKET_PER_SET*_WLOCK_BUCKETSET_CNT) |
Class | Optional, Adjustable, Static, System |
Range |
Number of seconds for a CLI connect to timeout to a DB that will be connected through a DB link.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | _DBLINK_CONN_TIMEOUT |
Class | Optional, Adjustable, Dynamic, Session |
Range | 0 - INT32_MAX |
Interval to check whether a DB link is valid after the last message to a connected DB has been sent through a DB link.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Dynamic, Session |
Range | 0 - INT32_MAX |
Number of seconds to wait for a response after sending SQL to a DB that is connected through a DB link.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | _DBLINK_QUERY_TIMEOUT |
Class | Optional, Adjustable, Dynamic, Session |
Range | 0 - INT32_MAX |
DBMS_LOG_DEST specifies the directory where the database log files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Dynamic, System |
Range |
DBMS_LOG_FILE_SIZE specifies the maximum size of each database log file. If a single log file grows more than the size specified in this parameter, the current log file will be closed and a new file will be created.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 104857600 |
Class | Optional, Adjustable, Static, System |
Range | 100K - 1G |
DBMS_LOG_TOTAL_SIZE_LIMIT specifies the maximum total file size that can be stored in the directory set in DBMS_LOG_DEST. Use this parameter to prevent database log files from growing endlessly by deleting the oldest files when the file size exceeds the specified value and hence reusing the database space.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 300 * 1024 * 1024 |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K - |
DBWR_CNT specifies the number of processes that use database blocks on disk.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | _DBWR_USE_AIO ? 1 : MAX(1, get_ncpu()/4) |
Class | Optional, Adjustable, Static, System |
Range | 1 - 1024 |
DB_BLOCK_SIZE specifies the size of database blocks.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 8 * 1024 |
Class | Optional, Persistent, Static, System |
Range | 2K - 32K |
DB_CACHE_SIZE specifies the size of the database cache buffer.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | CLUSTER_DATABASE ? TB_CEIL(TOTAL_SHM_SIZE * 1 / 2, 1) : TB_CEIL(TOTAL_SHM_SIZE * 2 / 3, 1) |
Class | Optional, Adjustable, Static, System |
Range | 360K - |
DB_CREATE_FILE_DEST specifies the directory where the data files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
DB_FILE_MULTIBLOCK_READ_COUNT specifies the number of blocks which can be read in one I/O operation.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MAX(1, MIN(DB_CACHE_SIZE / DB_BLOCK_SIZE / _DB_BLOCK_LRU_LATCHES * _DB_BLOCK_MAX_SCAN_PCT / 100 / 2, 64)) |
Class | Optional, Adjustable, Dynamic, System |
Range |
DB_KEEP_CACHE_SIZE specifies the size of the KEEP buffer pool.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Static, System |
Range |
DB_MULTIBLOCK_PREFETCH_COUNT specifies prefetch count
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1 |
Class | Optional, Adjustable, Dynamic, System |
Range |
DB_NAME specifies the name of the database. It must correspond to the name specified in the DB_NAME parameter of the $TB_SID.tip file. If a database name is not specified, the database will be created with the TB_SID environment variable. When the system is restarted after database creation, an error may occur if the specified database name does not match the one specified in DB_NAME of the $TB_SID.tip file.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Mandatory, Persistent, Static, System |
Range | Limited to 40 characters |
DB_RECYCLE_CACHE_SIZE specifies the size of the RECYCLE buffer pool.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | DB_CACHE_SIZE * _CACHE_BATCH_AREA_PCT / 100.0 |
Class | Optional, Adjustable, Static, System |
Range |
DD_CACHE_MAX specifies the maximum size of DD cache (automatically adjusted). Deprecated.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MAX(10 << 20, (TOTAL_SHM_SIZE - DB_CACHE_SIZE) * 0.3) |
Class | Optional, Adjustable, Dynamic, System |
Range | 10M - |
DEFAULT_SEQ_CACHE_SIZE specifies the default value of sequence cache size.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 20 |
Class | Optional, Adjustable, Dynamic, System |
Range | 2 - 99999999 |
DF_HDRBLK_START_OFFSET specifies the data file's start offset.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Persistent, Static, System |
Range | 0 - 65536 |
Sets the paths to AS disks. Use absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range | |
Syntax | DISK_PATH=pathname[:pathname [...] ] |
DONT_USE_FILE_BUFFERING determines whether to use file cache in Windows.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
DPL_INDEX_METHOD specifies the DPL (Direct Path Loading) operation mode in the table with the index. 1: NORMAL INSERT, index keys are inserted one by one. 2: MULTI INSERT, multiple index keys are inserted at a time. 3: FAST BUILD, index keys are retrieved in key sequence and inserted per unit of block.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 2 |
Class | Optional, Adjustable, Dynamic, Session |
Range | 1 | 2 | 3 |
ENCRYPTION_WALLET_FILE specifies the location of wallet files used by TDE only. It must be specified as an absolute path. deprecated
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range | |
Syntax | ENCRYPTION_WALLET_FILE=filename[:filename [...] ] |
EVENT_TRACE determines the method for recording binary trace log. If this parameter is set to 0, the server does not leave trace logs. If it is set to 1 or 2, binary trace logs are recorded with the mmap method or the buffered write method, respectively. (Deprecated)
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Static, System |
Range | 0~2 |
EVENT_TRACE_DEST specifies the directory in which the event trace file is saved. The absolute path should be specified. (Deprecated)
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
EVENT_TRACE_FILE_BACKUP_ON_BOOT determines if old event trace files will be backed up when RDBMS boots. If it is set to 'N', event records will continue to be written to an existing event trace file. Otherwise, all old event trace files will be backed up to a new backup directory. (Deprecated)
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Static, System |
Range |
EVENT_TRACE_FILE_SIZE specifies the maximum size of the event trace file. If the size of a trace file is larger than this size, the current file is backed up and a new trace file is created. (Deprecated)
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10485760 |
Class | Optional, Adjustable, Static, System |
Range | 100K ~ 10M |
EVENT_TRACE_MAP specifies the location of the configuration file which specifies on/off of the event trace. It must be specified as an absolute path. (Deprecated)
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
EVENT_TRACE_TOTAL_SIZE_LIMIT specifies the maximum size of all trace files accumulated in the directory specified as EVENT_TRACE_DEST. If this size is exceeded when a new trace file is created, the oldest file is deleted to prevent trace files from being generated endlessly. (Deprecated)
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | ((MAX_SESSION_COUNT + 50L) * (int64_t)(EVENT_TRACE_FILE_SIZE)) |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K ~ UINT64_MAX |
Multiple ports can be specified to configure additional ports. Use a semi-colon, ';', as the delimiter, e.g., '8900;8901;'.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
EX_MEMORY_AUTO_MANAGEMENT enables either automatic PGA memory allocation with memory tuner or manual memory allocation.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, Session |
Range |
The memory tuner uses the interval specified in this parameter to check the total amount of available PGA memory and the maximum amount of PGA memory available to each operation. The interval is specified in 0.1 seconds.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 30 |
Class | Optional, Adjustable, Dynamic, System |
Range | EX_MEMORY_DRIFT_CHECK_INTERVAL - |
To cope with rapid changes in the amount of memory, RDBMS checks whether changes in the amount of PGA memory has exceeded 10% of the total amount of PGA memory at every interval specified in this parameter. The interval is specified in 0.1 seconds.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 2 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 - |
The memory difference RATIO for DRIFT CHECK. DRIFT will be generated when the change is EX_MEMORY_SOFT_LIMIT * EX_MEMORY_DRIFT_RATIO. (unit of 0.001%)
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10000 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 ~ 100000 |
FDPOOL_HASH_SIZE specifies the hash size to be used in the fdpool.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MAX(WTHR_PROC_CNT * _WTHR_PER_PROC * 4 * (!!CLUSTER_DATABASE+1), 128) |
Class | Optional, Adjustable, Static, System |
Range |
ratio of the space flashback buffer occupies within log buffer
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 30 |
Class | Optional, Adjustable, Static, System |
Range | 1 - 50 |
specifies the format of the flashback archive log file.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "fb-t%t-r%r-s%s.arc" |
Class | Optional, Adjustable, Dynamic, System |
Range |
GATHER_SQL_EXEC_TIME determines whether to measure the time spent to execute SQL statements. This parameter is used to enable EXEC_TIME of _VT_OPEN_CURSOR.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
GATHER_SQL_PLAN_STAT determines whether to collect statistics on each node in the SQL statement execution plan at the time an SQL query is executed.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
HASH_AREA_SIZE specifies the maximum size of memory to be used for creating a hash table. If HASH_AREA_SIZE is large, hash joins can be completed in memory in a one-pass hash join. If HASH_AREA_SIZE is not large enough for a particular hash join, a two-pass hash join will be executed.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | (MEMORY_TARGET - TOTAL_SHM_SIZE) * 0.3 |
Class | Optional, Adjustable, Dynamic, Session |
Range | (DB_BLOCK_SIZE * DB_FILE_MULTIBLOCK_READ_COUNT) - |
HBASE_CONNECTOR_SCAN_CACHE specifies the HBase Connector scanner row size.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1000 |
Class | Optional, Adjustable, Dynamic, System |
Range |
ILOG_DEST specifies the directory in which the internal log file is saved. The absolute path should be specified.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Static, System |
Range |
ILOG_FILE_BACKUP_ON_BOOT determines if old internal log files will be backed up when RDBMS boots. If it is set to 'N', internal log records will continue to be written to an existing internal log file. Otherwise, all old internal log files will be backed up to a new backup directory.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Static, System |
Range |
ILOG_FILE_SIZE specifies the maximum size of the internal log file. If the size of a log file is larger than this size, the current file is backed up and a new log file is created.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10485760 |
Class | Optional, Adjustable, Static, System |
Range | 100K ~ 10M |
ILOG_MAP specifies the location of the configuration file which specifies on/off of the internal log. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
ILOG_TOTAL_SIZE_LIMIT specifies the maximum size of all internal log files accumulated in the directory specified as ILOG_DEST. If this size is exceeded when a new log file is created, the oldest file is deleted to prevent log files from being generated endlessly.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | ((MAX_SESSION_COUNT + 50L) * (int64_t)(ILOG_FILE_SIZE)) |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K ~ UINT64_MAX |
INSTANCE_NUMBER specifies the instance number.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | THREAD |
Class | Optional, Persistent, Static, System |
Range | 0 |
INSTANCE_TYPE specifies whether an instance is a database instance or an Active Storage instance.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "TIBERO" |
Class | Optional, Persistent, Static, System |
Range | TIBERO | AS | ACTIVE_STORAGE |
Configure an IP protocol family to be used for network communications with a client. To use IPv4, set the configuration to 4. To use IPv6, set the configuration to 6. To automatically select and use an available protocol, set the configuration to 0.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Static, System |
Range | 0, 4, or 6 |
JAVA_CLASS_PATH specifies the default directory used to store a class file in Java stored procedure. It must be specified as an absolute path. If not specified, the class file will be stored in DB_CREATE_FILE_DEST/java.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
JOB_HISTORY_LOG determines whether to write a job history after every job start or not.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
JOB_TRACE_LOG determines whether to write a tracelog after every job start or not.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
KEEP_STAT_PER_SQL determines whether to maintain statistical information on execution time for each SQL statement.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LIBRARY_CACHE_MAX specifies the maximum size of library cache (automatically adjusted). Deprecated.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MAX(10 << 20, (TOTAL_SHM_SIZE - DB_CACHE_SIZE) * 0.3) |
Class | Optional, Adjustable, Dynamic, System |
Range | 10M - |
LIBRARY_DD_CACHE_MAX specifies the maximum size of library cache and DD cache (automatically adjusted).
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MAX(10 << 20, (TOTAL_SHM_SIZE - DB_CACHE_SIZE) * 0.6) |
Class | Optional, Adjustable, Dynamic, System |
Range | 10M - |
LISTENER_IP specifies the IP used by listener. Both IPv4 and IPv6 addresses are supported.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "-1" |
Class | Optional, Persistent, Static, System |
Range |
LISTENER_PORT specifies the port number to be used by listener. If two or more instances are running on a machine, the port number must be different for each instance. The same rule is in effect for SHM_KEY parameter.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Static, System |
Range | 1024 - 65535 |
LOAD_METRIC_AUTO_INTERVAL determines whether to enable auto interval to collect the information about server load balancing.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOAD_METRIC_COLLECT_INTERVAL_MAX specifies the maximum interval of time to collect server load balancing information.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Adjustable, Dynamic, System |
Range | 5 - 60 (s) |
LOAD_METRIC_COLLECT_INTERVAL_MIN specifies the minimum interval of time to collect server load balancing information.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 - 5 (s) |
LOAD_METRIC_HISTORY_COUNT specifies the number of data to be gathered on server load-balancing.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Persistent, Static, System |
Range |
LOCAL_CLUSTER_ADDR specifies the network address to be used for communication between instances in the TAC node.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
Configure an IP protocol family to be used for cluster network communications. To use IPv4, set the configuration to 4. To use IPv6, set the configuration to 6.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MAX(IP_VERSION, 4) |
Class | Optional, Adjustable, Static, System |
Range | 4 or 6 |
LOCAL_CLUSTER_PORT specifies the port number to be used for communication between instances in the TAC node.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Static, System |
Range | 1024 - 65535 |
LOG_ARCHIVE_DEST specifies the directory where the archive logs are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_1 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_2 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_3 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_4 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_5 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_6 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_7 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_8 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_DEST_9 specifies the directory where the archive logs are duplicated.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_FORMAT specifies the format of the archive log file.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "log-t%t-r%r-s%s.arc" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ARCHIVE_OVERWRITE determines whether to overwrite the pre-existing archive log file with the current archive log file.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Persistent, Dynamic, System |
Range |
LOG_ARCHIVE_RETRY_TIME specifies wait time (in seconds) to retry when it is failed to make an archive log file.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 3 |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_BUFFER specifies the size of the memory space where logs are stored.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 * 1024 * 1024 |
Class | Optional, Adjustable, Static, System |
Range | (DB_BLOCK_SIZE) * 4 - 1G |
LOG_CHECKPOINT_INTERVAL specifies the maximum number of blocks which have to be written before a checkpoint is forced.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0 - INT32_MAX |
LOG_CHECKPOINT_TIMEOUT specifies a time interval, in seconds, at which the checkpoint will occur.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1800 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0 - INT32_MAX |
LOG_DEFAULT_DEST specifies the directory to which server log files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
LOG_LVL_AS specifies the logging level of AS. The higher the log level, the more log records the listener stores.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 5 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 - 6 |
LOG_LVL_CM specifies the logging level of TBCM. The higher the log level, the more log records CM stores.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 2 |
Class | Optional, Adjustable, Static, System |
Range | 1 - 6 |
LOG_LVL_LIS specifies the logging level of the listener. The higher the log level, the more log records the listener stores.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 6 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 - 6 |
LOG_ON_MEMORY determines whether to write per-thread logs in cacheable memory on file when an error occurs.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_ON_MEMORY_SIZE specifies the size of the buffer which each thread will use to write logs to file when the LOG_ON_MEMORY parameter is enabled.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 102400 |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K - 10M |
LOG_REPLICATION_1_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_2_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_3_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_4_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_5_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_6_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_7_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_8_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_9_ENABLE enables the Standby db active.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
LOG_REPLICATION_DEST_1 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_DEST_2 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_DEST_3 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_DEST_4 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_DEST_5 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_DEST_6 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_DEST_7 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_DEST_8 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_DEST_9 enables writing the Standby db information on the primary database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | <ip>:<port> {LGWR|ARCH} {SYNC|ASYNC} |
LOG_REPLICATION_MODE allows user to manage the operation mode of the Primary DB.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "UNPROTECTED" |
Class | Optional, Adjustable, Dynamic, System |
Range | |
Syntax | {UNPROTECTED|PROTECTION|AVAILABILITY|PERFORMANCE} |
LONGOPS_KEEP_INTERVAL specifies the retention time (in minutes) for history of long-running operations.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10080 |
Class | Optional, Adjustable, Dynamic, System |
Range | 10(10 min) - 40320(4 weeks) |
LONGOPS_THRESHOLD_SEC specifies timeout (in seconds) of performing an operation. If it takes longer than this time to handle an operation, the operation is regarded as a long-running operation and registered in v$session_longops.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Dynamic, Session |
Range | 0(sec) ~ 10000(sec) |
LONG_OPERATION_KEEP_COUNT specifies the number of high-load SQL statements on which to gather statistics.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Persistent, Static, System |
Range |
LSNR_DENIED_IP specifies the list of IPs that cannot connect to the listener. This parameter can be set with the same method for setting LSNR_INVITED_IP. If LSNR_INVITED_IP is set, setting in LSNR_DENIED_IP will be ignored.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LSNR_DENIED_IP_FILE specifies the file containing the list of IPs that cannot connect to the listener. If the LSNR_INVITED_IP or the LSNR_INVITED_IP_FILE is set, setting in LSNR_DENIED_IP_FILE will be ignored.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LSNR_INVITED_IP specifies the list of IPs that can connect to the listener. Use a semicolon (;) to distinguish each IP. The IP format is address/number of bits as follows. (Ex) LSNR_INVITED_IP="192.168.20.0/24;192.168.10.101" 192.168.20.0/24 : Accept all IP connections starting with 192.168.20.xxx. 192.168.10.101 : If the number of bits is omitted, accept only the corresponding IP.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LSNR_INVITED_IP_FILE specifies the file containing the list of IPs that can connect to the listener. A single IP address is written in each line of the file. The IP format is address/number of bits like LSNR_INVITED_IP. @range :
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
LSNR_LISTEN_BACKLOG specifies the maximum length of the queue of pending connections.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 250 |
Class | Optional, Adjustable, Static, System |
Range |
LSNR_LOG_DEST specifies the directory where the listener log files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Static, System |
Range |
LSNR_LOG_FILE_SIZE specifies the maximum size of each listener log file. If a single log file grows more than the size specified in this parameter, the current log file will be closed and a new file will be created.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10485760 |
Class | Optional, Adjustable, Static, System |
Range | 100K - 1G |
LSNR_LOG_TOTAL_SIZE_LIMIT specifies the maximum total file size that can be stored in the directory set in LSNR_LOG_DEST. Use this parameter to prevent database log files from growing endlessly by deleting the oldest files when the file size exceeds the specified value and hence reusing the database space.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 300 * 1024 * 1024 |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K - INT64_MAX |
Number of sessions for processing internal tasks and jobs among MAX_SESSION_COUNT that are not sessions requested by LSNR. As many as MAX_SESSION_COUNT - MAX_BG_SESSION_COUNT sessions can be started from LSNR. MAX_BG_SESSION_COUNT must be smaller than MAX_SESSION_COUNT and must be divisible by _WTHR_PER_PROC.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Static, System |
Range | 0 ~ INT32_MAX |
Specifies the maximum number of sessions provided by a server. If necessary, the number of worker processes configuring a session and the number of worker threads per process can be manually specified using WTHR_PROC_CNT and _WTHR_PER_PROC respectively. WTHR_PROC_CNT times _WTHR_PER_PROC must be MAX_SESSION_COUNT. If a user does not manually specify WTHR_PROC_CNT and _WTHR_PER_PROC, the default values of the number of worker threads per process (_WTHR_PER_PROC) is 10, and the number of worker processes (WTHR_PROC_CNT) is MAX_SESSION_COUNT/_WTHR_PER_PROC (round up if there is a remainder).
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 20 |
Class | Mandatory, Adjustable, Static, System |
Range | 1 ~ INT32_MAX |
Specifies the potential total amount of usable memory (shared memory plus private memory) of an instance for the foreseeable future, in bytes.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MEMORY_TARGET |
Class | Optional, Adjustable, Static, System |
Range | 1M - |
MEMORY_MODEL specifies the memory model predefined by size.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | TOTAL_SHM_SIZE <= 2147483648 ? "SMALL" : TOTAL_SHM_SIZE <= 34359738368 ? "MEDIUM" : "LARGE" |
Class | Optional, Adjustable, Static, System |
Range | SMALL | MEDIUM | LARGE |
Specifies the current total amount of usable memory (shared memory plus private memory) of an instance, in bytes. The default unit is bytes. Append 'M' for megabytes or 'G' for gigabytes after the value.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Mandatory, Adjustable, Dynamic, System |
Range | 1M - |
MEM_LOG_DEST specifies the directory in which the memory log file is saved. The absolute path should be specified.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Static, System |
Range |
NAMED_PIPE_DIR specifies the directory where named pipes used between processes are created while starting and closing the system.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
NLS_CALENDAR specifies which calendar system Tibero uses.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "GREGORIAN" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 64 characters in length |
NLS_COMP specifies the comparison behavior of SQL operations. The characters are compared according to their binary sequence or linguistic sequence defined in NLS_SORT.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "BINARY" |
Class | Optional, Adjustable, Dynamic, Session |
Range | BINARY | LINGUISTIC |
NLS_CURRENCY specifies the local currency symbol string for the 'L' number format.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "$" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 5 characters in length |
NLS_DATE_FORMAT specifies the default date format to be used when the database is started.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "YYYY/MM/DD" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 64 characters in length |
NLS_DATE_LANGUAGE specifies the default NLS date language to be used when the database is started.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "KOREAN" |
Class | Optional, Adjustable, Dynamic, Session |
Range | KOREAN | AMERICAN | JAPANESE | VIETNAMESE | BRAZILIAN PORTUGUESE | TRADITIONAL CHINESE |
NLS_ISO_CURRENCY specifies the international currency symbol.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "DEFAULT" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 64 characters in length |
NLS_LANGUAGE specifies the current languages for the session.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "DEFAULT" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 64 characters in length |
NLS_LANG_AT_BOOT specifies the default character set before the database is mounted.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | MSWIN949 |
Class | Optional, Adjustable, Static, System |
Range | Available Character Set |
NLS_LENGTH_SEMANTICS specifies the default character length semantics.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "BYTE" |
Class | Optional, Adjustable, Dynamic, Session |
Range | CHAR | BYTE |
NLS_NUMERIC_CHARACTERS specifies the characters for the group separator and decimal character.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | ".," |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 2 characters in length |
NLS_SORT specifies the collating sequence used by ORDER BY queries.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "BINARY" |
Class | Optional, Adjustable, Dynamic, Session |
Range | BINARY |
NLS_TERRITORY specifies current territory for the session.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "DEFAULT" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 64 characters in length |
NLS_TIMESTAMP_FORMAT specifies the default timestamp format to be used when the database is started.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "YYYY/MM/DD HH24:MI:SSXFF" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 64 characters in length |
NLS_TIMESTAMP_TZ_FORMAT specifies the default timestamp time zone format to be used when the database is started.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "YYYY/MM/DD HH24:MI:SSXFF TZR" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 64 characters in length |
NLS_TIME_FORMAT specifies the default time format to be used when the database is started.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "HH24:MI:SSXFF" |
Class | Optional, Adjustable, Dynamic, Session |
Range | Maximum 64 characters in length |
OMIT_PSM_SQL_LOG_ON_MEMORY determines whether to write per-thread SQL of PSM unit logs in cacheable memory on file when an error occurred.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
OPEN_CURSORS specifies the maximum number of cursors that a single session can open at once.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 50 |
Class | Optional, Adjustable, Dynamic, System |
Range | 10 - 1000 |
Syntax | OPEN_CURSORS=50 |
OPTIMIZER_MODE specifies the goal of the SQL query optimizer.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "ALL_ROWS" |
Class | Optional, Adjustable, Dynamic, Session |
Range | 10 - 1000 |
Syntax | { FIRST_ROWS_[1 | 10 | 100 | 1000] | ALL_ROWS } |
optimizer trace dump
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
OPTIMIZER_USE_INVISIBLE_INDEXES specifies the availability of invisible indexes
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
Prefix for OS authenticated user.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "OSA$" |
Class | Optional, Adjustable, Static, System |
Range |
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 4 |
Class | Optional, Adjustable, Dynamic, Session |
Range |
PARALLEL_GRANULE_SIZE specifies the number of segment blocks (granule size) read into memory in a single SQL query performing a full table scan.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 3 |
Class | Optional, Adjustable, Dynamic, System |
Range |
PARALLEL_THREADS_PER_CPU specifies the number of parallel execution threads per CPU.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 2 |
Class | Optional, Adjustable, Dynamic, System |
Range |
PEP_PROC_CNT specifies the number of pe processes.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 4 |
Class | Optional, Adjustable, Static, System |
Range | 0 - 10000 |
PRIVKEY_FILE specifies the location of the private key files. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range | |
Syntax | PRIVKEY_FILE=filename[:filename [...] ] |
PSM_CODE_TYPE specifies the interpreter mode in which PSM is implemented. It is efficient to use interpreter mode for anonymous blocks.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "INTERPRETED" |
Class | Optional, Adjustable, Dynamic, Session |
Range | INTERPRETED |
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
Option to automatically convert the err_no in pragma exception_init (exception, err_no).
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
When a PSM subprogram or anonymous block is implemented in compile mode, PSM_SHLIB_DIR creates a shared library by converting PSM code into C code. The shared library location is stored as an absolute path. If not specified, the shared library will be stored in the DB_CREATE_FILE_DEST/psm directory.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
PSM_SQL_RESULT_CACHE determines whether to enable the PSM's feature for caching the SQL results.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, Session |
Range |
QUERY_REWRITE_ENABLED enables or disables query rewrite which is globally applied for the database.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "TRUE" |
Class | Optional, Adjustable, Dynamic, Session |
Range | FALSE | TRUE | FORCE |
Sets the level of query rewrite integrity.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "ENFORCED" |
Class | Optional, Adjustable, Dynamic, Session |
Range | STALE_TOLERATED | ENFORCED |
RECO_PROC_WTHR_CNT specifies the number of recovery working processes.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 16 |
Class | Optional, Adjustable, Static, System |
Range | 1 - 100 |
The maximum size ratio of a query that can be cached. For example, if RESULT_CACHE_MAX_SIZE is 10MB and this value is set to 5, the maximum query size that can be cached will be 500KB, which is 5% of 10MB.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 5 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 - 100 |
The maximum memory size that can be used by the result cache in shared memory. If this value is set to 0, the result cache function will be disabled.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | TOTAL_SHM_SIZE / 100 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0 - |
RESULT_CACHE_MODE determines which query results to store in cache. If this value is set to MANUAL, the query result will be stored only when the "RESULT_CACHE" hint is used. If this value set to FORCE, all query results will be stored in cache.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "MANUAL" |
Class | Optional, Adjustable, Dynamic, Session |
Range | MANUAL | FORCE |
RESUMABLE_SPACE_ALLOC determines whether to enable the resumable space allocation feature.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
RESUMABLE_SPACE_ALLOC_TIMEOUT specifies a time interval in seconds at which the resumable space allocation will occur.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Dynamic, Session |
Range | 0 - INT32_MAX seconds |
RMGR_BACKUP_DEST specifies the directory where RMGR backup files are stored. It must be specified as an absolute path outside active storage.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
tar path for RMGR
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
RSRC_CHECK_INTERVAL specifies the resource manager thread check interval in seconds.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 3 |
Class | Optional, Adjustable, Dynamic, System |
Range |
RSRC_CONTROL_THRESHOLD specifies the resource manager control threshold in percentage.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 90 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0 ~ 100 |
RT_AWAKE_WAITER_INTERVAL specifies the time interval (in 0.1 seconds) that the flow control resource tuner awakes waiting WTHR.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Adjustable, Dynamic, System |
Range | 10 - 600 (1 - 60 seconds) |
RT_UPDATE_ALLOWABLE_INFLOW_CNT_INTERVAL specifies the time interval (in 0.1 seconds) that the flow control resource tuner updates a desired control value.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 10 |
Class | Optional, Adjustable, Dynamic, System |
Range | 10 - 600 (1 - 60 seconds) |
SANITY_CHECK_DURING_LOG_SWITCH determines whether to check lost or damaged log files during LOG SWITCH.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
SEGMENT_EXTEND_LAST enables the submission of the extension request on segment of a size smaller than the one of the previous request which failed due to shortages of segment space.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
SEM_KEY specifies the key of the semaphore to be used by each instance. In general, if this parameter is not defined, it will be automatically assigned a value. This is the same as in the SHM_KEY parameter. However, this can cause a conflict between programs using the same semaphore set and thus this parameter should be used to give a unique semaphore key for each instance.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Static, System |
Range |
The number of semaphore sets which apply to the communication between processes and threads. If _SEM_APR is set to Y, the SEM_SET_COUNT value will be set to the total number of server processes or threads. If_SEM_ARR is set to N, the SEM_SET_COUNT value will be set to a user-defined value or the default value.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1 |
Class | Optional, Adjustable, Static, System |
Range |
SEPARATION_OF_DUTIES creates SYSADM, SYSSEC and SYSAUD users such that the duties of SYS are separated and assigned to three users. SYSSEC manages user accounts and controls user profiles. SYSAUD can audit anything on the database. SYSADM has all privileges except for those of SYSSEC and SYSAUD. These administrator accounts are created during installation, and SYS account becomes locked and cannot be unlocked.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Persistent, Static, System |
Range |
SERVER_LOAD_TOLERANCE specifies the maximum limit to be used for server load balancing.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 5 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0 - (ms/#) |
SERVER_SIDE_LOAD_BALANCE specifies server load-balancing behavior. NONE: Server load balancing is not performed. SHORT: The load is balanced based on differences in the processing speed of servers. LONG: The load is balanced based on differences in the session count of servers.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "NONE" |
Class | Optional, Adjustable, Dynamic, System |
Range | NONE | SHORT | LONG |
SERVICE_CONTROL_STOP_DOWNMODE specifies a server down mode used to suspend a DBMS service from Windows Service Manager.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "IMMEDIATE" |
Class | Optional, Adjustable, Static, System |
Range | |
Syntax | {normal|post_tx|immediate|abort|switchover|abnormal|NORMAL|POST_TX|IMMEDIATE|ABORT|SWITCHOVER|ABNORMAL} |
SHARED_PARAMETER_FILE specifies the parameter file that can be shared.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range |
SHM_KEY specifies the key of the shared memory to be used by each instance. In general, if this parameter is not defined, it will be automatically assigned a value. However, this can cause a conflict between programs using the same shared memory key and thus this parameter should be used to give a unique shared memory key for each instance.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Static, System |
Range |
The allocator index to dump when SHP_ALLOC_FULL_DUMP=N. (Deprecated)
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Dynamic, System |
Range |
Determines whether to record detailed information when dumping the shared pool allocator.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
SLAB_BLOCK_RESERVED_COUNT specifies the number of blocks maintained in the slab allocator.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 4 |
Class | Optional, Adjustable, Dynamic, System |
Range | 2 - 1024 |
SLOG_DEST specifies the directory where system log files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Dynamic, System |
Range |
SLOG_FILE_SIZE specifies the maximum size of each system log file. If a single system log file grows more than the size specified in this parameter, the current system log file will be closed and a new file will be created.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 104857600 |
Class | Optional, Adjustable, Static, System |
Range | 100K - 1G |
SLOG_HISTORY determines whether to gather system log history.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Static, System |
Range |
SLOG_HISTORY_BUFSIZE specifies the size of a system log history buffer.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 256 |
Class | Optional, Adjustable, Static, System |
Range |
SLOG_HISTORY_QSIZE specifies the number of system log on which histories are to be gathered.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 4 |
Class | Optional, Adjustable, Static, System |
Range |
SLOG_TOTAL_SIZE_LIMIT specifies the maximum total file size that can be stored in the directory set in SLOG_DEST. Use this parameter to prevent database log files from growing endlessly by deleting the oldest files when the file size exceeds the specified value and hence reusing the database space.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 300 * 1024 * 1024 |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K - |
SORT_AREA_SIZE specifies the maximum size of memory that RDBMS will allow for a one-pass sorting. The data which exceeds the specified range is sorted using two-pass sorting. If this parameter is specified too large, all sort operations will be performed using a one-pass sort, which leads to a drastic decrease in the number of SQL queries that can be simultaneously handled. If it is specified too small, all operations will be performed using two-pass and thus SQL queries take longer to execute. It is recommended to run a test with SQL queries to determine the memory usage required to execute each SQL query and check its frequency and degree of importance using the trace file. After determining an appropriate value based on this information, 10% - 50% should be added to the value for the proper memory size.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | (MEMORY_TARGET - TOTAL_SHM_SIZE) * 0.3 |
Class | Optional, Adjustable, Dynamic, Session |
Range | (DB_BLOCK_SIZE * DB_FILE_MULTIBLOCK_READ_COUNT) - |
The feature of automatically adjusting the spinlock parameter
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
Determines whether to separately specify the spinlock parameter by type.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
SQL_LOG_ON_MEMORY determines whether to write per-thread SQL logs in cacheable memory on file when an error occurs.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
SQL_LOG_ON_MEMORY_SIZE specifies the size of the buffer which each thread will use to write logs to file when the SQL_LOG_ON_MEMORY parameter is enabled.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 102400 |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K - 10M |
SQL_STAT_HISTORY determines whether to gather statistics on SQL statements.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
SQL_STAT_HISTORY_QSIZE specifies the number of SQL statements per thread on which statistics are to be gathered.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 50 |
Class | Optional, Adjustable, Static, System |
Range |
SQL_STAT_HISTORY_THRESHOLD specifies the data gathering threshold for SQL statements. With SQL_STAT_HISTORY enabled, SQL statements are gathered if the specified execution period (ms) is exceeded.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 50 |
Class | Optional, Adjustable, Dynamic, System |
Range |
SQL_TRACE determines whether to record SQL trace information or not. The SQL trace enables profiling of SQL execution information. However, since using this function affects server performance, it is recommended not to use this function in a real server operating environment.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
SQL_TRACE_DEST specifies the directory where the SQL trace file will be stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Dynamic, System |
Range |
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, Session |
Range |
STANDBY_FILE_NAME_CONVERT specifies the prefix conversion rule used for converting the Primary DB path to the Standby DB path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range | |
Syntax | {<primary path>,<standby path>}, ... |
Determines whether to send an ack message after flushing the redo log received by standby.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
Option to enable observer in STANDBY
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
STAR_TRANSFORMATION_ENABLED enables or disables star transformation.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "FALSE" |
Class | Optional, Adjustable, Dynamic, Session |
Range | TRUE | FALSE |
Displays the summary row before the sub-total row of each group in the result set of Group By Cube().
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
TABLE_GLOBAL_COMPRESSION determines whether to perform compression using a global symbol table.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
TCP_RCVBUF_SIZE specifies the size of the TCP receive buffer
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Static, System |
Range |
TCP_SNDBUF_SIZE specifies the size of the TCP send buffer
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Static, System |
Range |
Verify data integrity during decryption.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
Defend against the self update modification attack. Update will be changed to delete and insert, and performance will be degraded. Rowid will also be changed: SELECT FOR UPDATE will not be supported.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
TEMP_GRANULE_SIZE specifies the number of blocks to be allocated for each node when managing the temporary tablespace of each node in the TAC environment.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1000 |
Class | Optional, Adjustable, Static, System |
Range |
TEMP_TABLESPACE specifies the temporary tablespace to be used in the database. If not specified, the first temporary tablespace is used by default.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
THREAD specifies the redo thread number to be used by instances.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Persistent, Static, System |
Range | 0 - 1024 |
TIBERO_PERFORMANCE_REPOSITORY determines whether to activate the TPR feature.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
TOTAL_SHM_MAX_SIZE specifies the potential total size of shared memory size used by instances.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | TOTAL_SHM_SIZE |
Class | Optional, Adjustable, Static, System |
Range | 32 bit machine: 1M - UINT32_MAX, 64 bit machine: 1 M - INT64_MAX |
TOTAL_SHM_SIZE specifies the current total size of shared memory size used by instances. The default unit is bytes. Append 'M' for megabytes or 'G' for gigabytes after the value.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Mandatory, Adjustable, Dynamic, System |
Range | 32 bit machine: 1M - UINT32_MAX, 64 bit machine: 1 M - INT64_MAX |
TPR_AGGREGATION determines whether to aggregate information of snapshots removed due to retention over into one predetermined snapshot.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
TPR_METRIC determines whether to collect metric statistics.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
TPR_SEGMENT_STATISTICS determines whether to collect segment statistics.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
TPR_SNAPSHOT_RETENTION specifies the period, in days, to retain TPR snapshot data.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 7 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 ~ 1500 |
TPR_SNAPSHOT_SAMPLING_INTERVAL specifies the interval, in minutes, to sample TPR snapshot data.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 60 |
Class | Optional, Adjustable, Dynamic, System |
Range | 1 ~ 50400 |
TPR_SNAPSHOT_TOP_SEGMENT_CNT specifies the count of segments to display in tpr report.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 5 |
Class | Optional, Adjustable, Static, System |
Range | 5 ~ 1000 |
TPR_SNAPSHOT_TOP_SQL_CNT specifies the count of SQLs to display in tpr report.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 5 |
Class | Optional, Adjustable, Dynamic, System |
Range | 5 ~ 1000 |
TRACE_DUMP_DEST specifies the directory to which trace dump files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Dynamic, System |
Range |
TRACE_LOG_DEST specifies the directory where trace log files are stored. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | Depending on system environment |
Class | Optional, Adjustable, Dynamic, System |
Range |
The TRACE_LOG_DISPLAY_YEAR parameter specifies whether the time field in the trace.log file created by the server displays the year. If this parameter is set to Y, the date is displayed as YYYY/MM/DD. Otherwise, it is displayed MM/DD.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
TRACE_LOG_FILE_SIZE specifies the maximum size of each trace log file. If a single trace log file grows more than the size specified in this parameter, the current trace log file will be closed and a new file will be created.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 104857600 |
Class | Optional, Adjustable, Static, System |
Range | 100K - 1G |
TRACE_LOG_FILE_TRUNC determines whether to delete the previous trace logs before recording new logs or keep the previous trace logs and record new logs following the previous logs each time the database system is rebooted.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Static, System |
Range |
TRACE_LOG_TOTAL_SIZE_LIMIT specifies the maximum total file size that can be stored in the directory set in TRACE_LOG_DEST. Use this parameter to prevent database log files from growing endlessly by deleting the oldest files when the file size exceeds the specified value and hence reusing the database space.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 300 * 1024 * 1024 |
Class | Optional, Adjustable, Dynamic, System |
Range | 100K - |
TSAM_PREFETCH_SIZE specifies the size of the buffer to be prefetched when db file sequential read is enabled in TSAM API.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 4096 |
Class | Optional, Adjustable, Dynamic, System |
Range | 0K - 64K |
The UDP port to be used between nodes for TSN synchronization.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 55901 |
Class | Optional, Adjustable, Static, System |
Range | 1024 - 65535 |
TX_FORCE_COMMIT_DUMP determines whether to dump undo records forcibly committed.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
TX_RECOVERY_SESSION_COUNT specifies the maximum number of sessions used for transaction recovery.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Dynamic, System |
Range |
UNDO_RETENTION specifies the minimum time period in seconds for which undo can be retained.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 900 |
Class | Optional, Adjustable, Dynamic, System |
Range |
UNDO_TABLESPACE specifies the undo tablespace to be used by a node. If this parameter is not specified, the first available undo tablespace will be used by default. This parameter must be defined in the TAC environment.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
USE_ACTIVE_STORAGE specifies whether a database instance uses the Active Storage function by connecting to the Active Storage instance.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
USE_ILOG determines whether to record internal log.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Static, System |
Range |
USE_NET_KEEPALIVE determines whether to activate the socket option of the 'TCP keepalive'.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
Determines whether to use the PROFILE feature.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
Determines whether to record login and logout time.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
USE_RECYCLEBIN determines whether to use the recyclebin function. If this feature is used, the drop table command does not actually delete a table. In order to actually delete a table, use the purge command or give the purge option in the drop table command. The flashback table feature can be used.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
USE_RESOURCE_MANAGER specifies whether to use the resource manager or not.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
USE_SSVR specifies whether the DB instance uses a storage server or not.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
Determines whether to apply created outline.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, Session |
Range |
Determines whether to use the TRUNCATE PRIVILEGE feature.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | N |
Class | Optional, Adjustable, Dynamic, System |
Range |
Determines whether to use the TABLESPACE QUOTA feature.
Parameter Format
Property | Description |
---|---|
Parameter Type | Boolean |
Default Value | Y |
Class | Optional, Adjustable, Dynamic, System |
Range |
USGMT_AUTO_SHRINK_INTERVAL specifies the interval (in minutes) of occurrence of automatic undo segment shrinkage. If this parameter is set to 0, automatic undo segment shrinkage never happens.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 0 |
Class | Optional, Adjustable, Dynamic, System |
Range |
UTL_FILE_DIR specifies the default directory used by the UTL_FILE package. If this parameter is not specified, the directory specified in PSM_SHLIB_DIR will be used by default.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Dynamic, System |
Range |
WALLET_FILE specifies the location of the wallet files. It must be specified as an absolute path.
Parameter Format
Property | Description |
---|---|
Parameter Type | String |
Default Value | "" |
Class | Optional, Adjustable, Static, System |
Range | |
Syntax | WALLET_FILE=filename[:filename [...] ] |
WTHR_PROC_CNT specifies the number of working processes.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | MAX_SESSION_COUNT/_WTHR_PER_PROC |
Class | Optional, Adjustable, Static, System |
Range | 1 - 10000 |
WTHR_PROC_CNT_MAX specifies the maximum number of working processes. With RDBMS started, as many working processes as defined in WTHR_PROC_CNT are implemented. If the number of working processes becomes insufficient during the operation of RDBMS, the number of working processes will be increased within the limit specified in this parameter. If the WTHR_PROC_CNT_MAX parameter is set to the default value, the number of working processes defined in WTHR_PROC_CNT will be used as the maximum number of processes to run.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | WTHR_PROC_CNT |
Class | Optional, Adjustable, Static, System |
Range | 1 - 10000 |
XA_MAX_BRANCH_CNT specifies the maximum number of XA transaction branches that can run one instance at a time. Setting this value too large could result in excessive memory usage.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 1024 |
Class | Optional, Adjustable, Static, System |
Range | 256 - 8192 |
XA_TIMER_INTERVAL specifies the interval for how often XA session timeouts are checked. The interval is specified in 0.1 seconds.
Parameter Format
Property | Description |
---|---|
Parameter Type | Integer |
Default Value | 100 |
Class | Optional, Adjustable, Dynamic, System |
Range | 10 - 600 (1 - 60 seconds) |