ACF_CMPT_CNT specifies the number of cluster message processing threads used by the ACSD (Active Cluster Service Deamon) process in parallel.

ACF_NMGR_CM_AUTO_REVIVAL specifies whether or not to apply the logic for CM and CM_GUARD to revive one another when the other is killed. (instance side)

ACF_NMGR_PREVENT_REVIVAL_ON_IR specifies whether or not to execute the Revival function when a DBWR loses its connection with CM even if the status of DBWR is 'IR HOLD' or 'IR WAITING'.

ACTIVE_SESSION_HISTORY determines whether to gather statistics on active sessions.

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.

ACT_LOG_DEST specifies the directory where activity log files are stored. It must be specified as an absolute path.

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.

kerberos service name for AD authentication.

AD_AUTH_KEYTAB_FILE specifies the location of the keytab files. It must be specified as an absolute path.

Prefix for AD authenticated user.

When scanning logfiles during recovery, check all members in a logfile group to check lost or damaged precisely.

AS_ADDR specifies the network address of the Active Storage instance to be accessed by the database instance.

AS_ALLOW_ONLY_RAW_DISKS specifies whether the Active Storage instance will only discover raw devices.

AS_DISKSTRING specifies the absolute path of the disks that the Active Storage instance discovers.

AS_USE_DISK_AFFINITY specifies the affinity group name to be used by instance. It must be equal to one of the disk failgroup names.

Waiting time until the disk is automatically dropped when the AS disk monitor finds that the disk fails. (in minutes when set to 0, don't drop)

size of fine-grained stripe

AS_PORT specifies the TCP port number of the Active Storage instance to be accessed by the database instance.

AS_SCAN_SSVR_DISK specifies whether or not to use storage server disk.

AS_USE_DISK_AFFINITY specifies whether disk affinity function will be used

AS_USE_USER_FUNCTION specifies whether the Active Storage instance will use USER and USERGROUP functions.

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.

AUDIT_FILE_DEST specifies the directory where AUDIT TRAIL files are stored. It must be specified as an absolute path.

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.

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.

AUDIT_SYS_OPERATIONS determines whether to enables auditing for the SYS user.

AUDIT_TRAIL specifies the method of auditing when the database auditing function is enabled.

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.

Specifies the automatic coalesce. 0: Do not use. 1: Only LOB indexes. 2: All indexes.

AUTO_COALESCE_INTERVAL specifies the auto coalesce interval. The unit is 0.1 second.

Set the batch update operation mode.

BATCH_INSERT_ROWCNT_THRESHOLD specifies the number of rows for inserting the same information into multiple tables and indexes using the BATCH INSERT protocol.

determines whether to enable Bind Variable Capture.

specifies the number of slave allocators for bind variable capture.

specifies the time interval, in seconds, at which Bind Variable Capure will execute.

determines whether to keep first bind variables of plans

specifies the maximum number of bind variables that Bind Variable Capture can store.

specifies the maximum number of bind variables that can be captured from a query.

a percentage of variables to be deleted from Bind Variable Capture pool.

specifies the size of pool for Bind Variable Capture.

BLOCK_CHANGE_TRACKING enables block change tracking for incremental backups.

BOOT_WITH_AUTO_DOWN_CLEAN specifies whether or not to automatically enable the tbdown clean process during tbboot.

BTIP_FILE_PATH specifies the binary parameter file that can be shared

CALLSTACK_DUMP_DEST specifies the directory to which callstack dump files are stored. It must be specified as an absolute path.

CCC_CATH_CNT specifies the number of asynchronous cache task threads used by the CCC(Cluster Cache Control) in parallel.

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.

CCC_RECL_MAX_RESOURCES specifies the maximum number of CCC resource blocks to be maintained in memory.

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.

CC_CU_BLKCNT specifies the maximum CC unit size in blocks.

CC_CU_PCTUSE specifies the percentage of a single block that can be used in a compression unit. This will be adjusted while loading.

CC_CU_WRITEOUT_THRESHOLD specifies the minimum percentage of a single block that must be met to proceed to write out. @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.

CC_TYPICAL_ROW_SIZE specifies the size of a typical row in a compression unit.

CERTIFICATE_FILE specifies the location of the certificate files. It must be specified as an absolute path.

Determines whether to close remote sessions that are connected using a database link when resetting sessions (logical disconnection).

CLUSTER_DATABASE determines whether to configure TAC (Tibero Active Cluster) or not.

CMPT_CNT_FOR_RECONFIGURATION specifies the number of cluster message processing threads during a reconfiguration. A reconfiguration will be executed in parallel by the threads.

If CM_AUTO_RECONNECT_NODE_WITH_ACTIVE_FHB is on, CM automatically reconnects with nodes with active FHB.

CM_AUTO_RECONNECT_TIMEOUT specifies the waiting (after sending a reconn msg) timeout for the auto reconnection.

CM_AUTO_REVIVAL specifies whether or not to apply the logic for CM and CM_GUARD to revive one another when the other is killed.

CM_CLUSTER_AUTO_RESTART specifies whether or not to automatically restart the cluster when the network resource connection is restored.

If this is Y, CM will be down on time disaccordance between other CMs.

CM_ENABLE_FAST_ACT_LOOP specifies whether CM action thread can be accelarated by bitq

CM_ENABLE_FAST_MASTER_ELECTION specifies whether to turn on the function to rapidly elect a node as the cluster master when the old master is in a dysfunctional situation.

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.

CM_FENCE determines whether to execute the CM fence daemon. To use this option, CM must be started with root privileges.

CM_FILE_AUTO_RESTART_SSVR specifies whether or not to automatically restart a file resource when it is downed in an SSVR environment.

CM_FORCE_INSTANCE_KILL specifies whether CM forcibly kills the instances when they are needed to be down.

Save location of the TBCM Guard log file. The location must be set as an absolute path in the local disk.

Configure an IP protocol family to be used for the local CM UI. To use IPv4, set the configuration to 4. To use IPv6, set the configuration to 6.

CM_LOG_DEST specifies the directory to which TBCM log files are stored. It must be specified as an absolute path.

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.

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.

CM_LOOP_TIMEOUT specifies how much is the CTHR/Action thread loop timeout.

CM_MODE_OBSERVER specifies whether or not to start up CM in observer mode.

M_MST_SAFEGUARD_EXPIRE is provided to prevent split brain when the CM_FAST_NET_DETECTION parameter is turned on. When the connection between the master and the slave is lost, turn on the master safeguard. If the master file H/B remains abnormal during this duration, turn off the master safeguard and immediately start the master election. If the master safeguard is turned on and the master file H/B is valid after waiting for 2 * CM_MST_SAFEGUARD, it terminates its own cluster.

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.

CM_NETWORK_AUTO_RESTART specifies whether or not to automatically restart CM when the network resource connection is restored.

CM_NET_EXPIRE_MARGIN specifies the network heartbeat expire for controlling CM. The value must be a multiple of CM_TIME_UNIT.

CM_OBSERVER_PORT specified the listening port to be used by CM in observer mode.

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.

If this parameter is on, Net H/B timeout is regarded as serious as File H/B timeout.

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.

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.

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.

CM_REVIVAL_WAIT_INST_TIMEOUT specifies the timeout to wait for status info sharing between instances during a force reboot by CM_Guard.

CM_REVIVAL_WAIT_NODE_TIMEOUT specifies the timeout to wait for resource sharing between nodes during a force reboot by CM_Guard.

CM_REVIVAL_WAIT_INST_TIMEOUT specifies the timeout for an existing Guard to wait for the initialization of a new CM during a force reboot by CM_Guard.

CM_SVC_AUTO_START_ON_BOOT specifies whether or not to automatically restart services together with network and cluster when CM boots.

CM_TAS_VM_ADDR specifies the IP information of the TAS5 Master (volume manager) that is needed by CM when the CM file is stored in TAS5.

CM_TAS_VM_PORT specifies the PORT information of the TAS5 Master (volume manager) that is needed by CM when the CM file is stored in TAS5.

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.

CM_UI_PORT specifies the port information that CM uses to receive user commands.

CM_USE_ASENV specifies whether or not to use the AS commands and environment settings when using cmrctl from CM to control an AS instance.

Whether to use amazon AWS EC2 virtual machine.

CM_USE_TAS5_STORAGE specifies whether or not to create CM files in TAS5 storage.

CM_VIP_FAILOVER_BASED_ON_SVC_STATUS specifies when to alias VIP (when the service instance is up or down). Y means aliasing when the service instance is up, and N means aliasing when CM is booting.

CM_VIP_RESTART_COUNT specifies the number of times the VIP resource in the DOWN state performs automatic start. Automatic start is performed once per second.

CM_VIP_STAT_CHECK_INTERVAL specifies the interval to check the status of the VIP resource in the UP state.

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.

COMMIT_FLUSH_REQUEST determines whether to flush the logs after every transaction commit or not.

COMMIT_FLUSH_WAIT determines whether database commits wait for log flushes or not.

COMMIT_POINT_STRENGTH specifies the value determining the commit point site in a distributed transaction.

CONTROL_FILES specifies the location of the control files. It must be specified as an absolute path.

CPU_COUNT specifies the number of CPUs allowed for this instance.

Determines whether to create outline.

CTHR_CHECK_CONNECTION_INTERVAL specifies the time interval (in seconds) that CTHR checks client connections.

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.

CWS_DDD_TIMEOUT_ON_SLOG specifies whether or not to record a 'DDD timedout' SLOG message.

CWS_RECL_MAX_RESOURCES specifies the maximum number of CWS (Cluster Wait-lock Service) resource blocks to be maintained in memory.

CWS_RESOLVE_CVT_DEADLK_FORCE specifies whether or not to enable CWS (Cluster Wait-lock Service) to force cancellation of requests that could potentially cause a conversion deadlock.

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.

Number of rows to be processed at the same time during batch

Number of seconds for a CLI connect to timeout to a DB that will be connected through a DB link.

Interval to check whether a DB link is valid after the last message to a connected DB has been sent through a DB link.

Number of seconds to wait for a response after sending SQL to a DB that is connected through a DB link.

DBMS_LOG_DEST specifies the directory where the database log files are stored. It must be specified as an absolute path.

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.

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.

DBWR_CNT specifies the number of threads that use database blocks on disk.

Option for DBWR to use AIO. Must be set to N in active storage mode.

DB_BLOCK_SIZE specifies the size of database blocks.

DB_CACHE_SIZE specifies the size of the database cache buffer. It can be adjusted so that each DB writer manages the same number of blocks.

DB_CREATE_FILE_DEST specifies the directory where the data files are stored. It must be specified as an absolute path.

DB_FILE_MULTIBLOCK_READ_COUNT specifies the number of blocks which can be read in one I/O operation.

DB_KEEP_CACHE_SIZE specifies the size of the KEEP buffer pool.

DB_MULTIBLOCK_PREFETCH_COUNT specifies prefetch count

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.

DB_RECYCLE_CACHE_SIZE specifies the size of the RECYCLE buffer pool.

DB_UNIQUE_NAME specifies a globally unique name for the database. Databases with the same DB_NAME, for example, copies of a database created for testing or physical standby databases, must have a unique DB_UNIQUE_NAME to be distinguished. Every database's DB_UNIQUE_NAME must be unique within the enterprise. @range : Limited to 40 characters and is case sensitive

DD_CACHE_MAX specifies the maximum size of DD cache (automatically adjusted). Deprecated.

DEFAULT_SEQ_CACHE_SIZE specifies the default value of sequence cache size.

DF_HDRBLK_START_OFFSET specifies the data file's start offset.

Time period within which a dirty cache block must be issued to be written to disk. (Unit: second) This cannot be used concurrently with "LOG_CHECKPOINT_TIMEOUT". If set to 0, this parameter is ignored.

Sets the paths to AS disks. Use absolute path.

DONT_USE_FILE_BUFFERING determines whether to use file cache in Windows.

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.

DUMP_EXSTAT_ON_STMT_CANCEL specifies whether or not to dump the current SQL, bind parameters and execution stat when a statement is cancelled

ENCRYPTION_WALLET_FILE specifies the location of wallet files used by TDE only. It must be specified as an absolute path. deprecated

ENCRYPT_GLOBAL_KEY_FILE specifies the location of global key file used to recover encrypted tablespaces.

Multiple ports can be specified to configure additional ports. Use a semi-colon, ';', as the delimiter, e.g., '8900;8901;'.

Multiple ipv6 ports can be specified to configure additional ports. Use a semi-colon, ';', as the delimiter, e.g., '8900;8901;'.

EX_MEMORY_AUTO_MANAGEMENT enables either automatic PGA memory allocation with memory tuner or manual memory allocation.

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.

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.

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%)

FDPOOL_HASH_SIZE specifies the hash size to be used in the fdpool.

Specifies the absolute path of the directory where the flashback archive logs.

Specifies the format of the flashback archive log file.

Size of the memory space where flashback logs are buffered. Value must be set when flashback logging is set on. Recommended twice the value of LOG_BUFFER.

Time period of making flashback database marker (in sec). Smaller it is, faster the DB can flashback. However, DB gets slower due to the heavy flashback logging during usual operation and also flashback logs takes up more disk space.

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.

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.

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.

HBASE_CONNECTOR_SCAN_CACHE specifies the HBase Connector scanner row size.