초기화 파라미터 소개

개요

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.

• Shared memory area

• Default value for the database and instances

• Database limits

• Location of the control file

• Location of the archive file

• Location of the trace file

Below is an example of the initialization parameter file.

AUTHENTICATION_TIMEOUT = 0
CLUSTER_DATABASE = N
EX_WORKAREA_CACHE_SIZE = 100

lass Attributes

This section explains the class attributes necessary for users to understand the information configured in the initialization parameter file.

Group	Class	Description
Static/Dynamic	Static	A parameter that cannot be modified during system operation.
	Dynamic	A parameter that can be modified during system operation.
Persistent/Adjustable	Persistent	A parameter that cannot be modified after database creation.
	Adjustable	A parameter that can be modified after database creation.
Mandatory/Optional	Mandatory	A parameter required to start up a system. If these parameter are not defined in the initialization parameter file, the system cannot be booted.
	Optional	A parameter that uses a default value if not defined in the initial ization parameter.
System/Session	System	A parameter that the entire system shares.
	Session	A parameter that can be configured separately for each session.

---

Initialization Parameter

This section describes initialization parameters in alphabetical order.

ACF_CMPT_CNT

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, Adjustable, Static, System
Range

ACF_NMGR_CM_AUTO_REVIVAL

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)

• Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

ACF_NMGR_PREVENT_REVIVAL_ON_IR

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'.

• Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Static, System
Range

ACTIVE_SESSION_HISTORY

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

ACTIVE_SESSION_TIMEOUT

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

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

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

AD_AUTH_KBR_SERVICE_NAME

kerberos service name for AD authentication.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

AD_AUTH_KEYTAB_FILE

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

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range
Syntax	AD_AUTH_KEYTAB_FILE=filename[:filename [...] ]

AD_AUTH_PREFIX

Prefix for AD authenticated user.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"AD$"
Class	Optional, Adjustable, Static, System
Range

ALL_LOGFILE_MEMBERS_SANITY_CHECK

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

AS_ADDR

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

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

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_DISK_AFFINITY_GROUP

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.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Static, System
Range

AS_DISK_REPAIR_WAIT_TIME

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)

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Dynamic, System
Range

AS_PORT

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_SCAN_SSVR_DISK

AS_SCAN_SSVR_DISK specifies whether or not to use storage server disk.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

AS_USE_DISK_AFFINITY

AS_USE_DISK_AFFINITY specifies whether disk affinity function will be used

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

AS_WTHR_CNT

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

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

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

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, Static, System
Range	100K -

AUDIT_SYS_OPERATIONS

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

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

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	100
Class	Optional, Adjustable, Dynamic, System
Range	0 - 100

AUTO_COALESCE

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

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)

AUTO_COALESCE_STOP

stop automatic coalesce for segment drop

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

BATCHUPDATE_MODE

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

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

BIND_VARIABLE_CAPTURE

determines whether to enable Bind Variable Capture.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

BIND_VARIABLE_CAPTURE_ALLOC_COUNT

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

BIND_VARIABLE_CAPTURE_INTERVAL

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	600
Class	Optional, Adjustable, Dynamic, System
Range	0 ~ 86400

BIND_VARIABLE_CAPTURE_KEEP_FIRST

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

BIND_VARIABLE_CAPTURE_MAX_COUNT

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

BIND_VARIABLE_CAPTURE_MAX_VAR_COUNT

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

BIND_VARIABLE_CAPTURE_POOL_PCTDEL

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

BIND_VARIABLE_CAPTURE_POOL_SIZE

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

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

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	Y
Class	Optional, Adjustable, Static, System
Range

BOOT_WITH_UNKNOWN_PARAMETER

BOOT_WITH_UNKNOWN_PARAMETER specifies whether to allow booting when unknown parameters are set in the tip file.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

BOOT_WITH_WALLET_CHECK

If TTE tablespace exists, DB must be booted with the wallet open beforehand. Recommendation: tbboot

-w.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Dynamic, System
Range

BTIP_FILE_PATH

BTIP_FILE_PATH specifies the binary parameter file that can be shared

● Parameter Format

Property	Description
Parameter Type	filename
Default Value	""
Class	Optional, Adjustable, Static, System
Range

CALLSTACK_DUMP_DEST

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

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	2
Class	Optional, Adjustable, Static, System
Range	1 - 64

CCC_MASTERING_UNIT

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, Adjustable, Static, System
Range

CCC_RECL_MAX_RESOURCES

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, Adjustable, Static, System
Range

CCC_RSBTBL_SIZE

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

CU_BLKCNT

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	1 - 32

CC_CU_PCTUSE

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_CU_WRITEOUT_THRESHOLD

CC_CU_WRITEOUT_THRESHOLD specifies the minimum percentage of a single block that must be met to proceed to write out. @range : 0 - 99

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	85
Class	Optional, Adjustable, Dynamic, Session
Range

CC_EXPECTED_RATE

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

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

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 [...] ]

CLOSE_REMOTE_SESSION_ON_SESSION_RESET

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

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

CMPT_CNT_FOR_RECONFIGURATION

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.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	MIN(8, MAX(1, ACF_CMPT_CNT/4))
Class	Optional, Adjustable, Dynamic, System
Range

CM_AUTO_RECONNECT_NODE_WITH_ACTIVE_FHB

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_AUTO_RECONNECT_TIMEOUT

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	6
Class	Optional, Adjustable, Static, System
Range

CM_AUTO_REVIVAL

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.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_AWS_FENCE_WAIT_CNT

Count(seconds) waiting for delay on EC2 state change in

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	10
Class	Optional, Adjustable, Static, System
Range

CM_CLUSTER_AUTO_RESTART

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_DOWN_ON_TIME_DISACCORDANCE

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_ENABLE_FAST_ACT_LOOP

CM_ENABLE_FAST_ACT_LOOP specifies whether CM action thread can be accelarated by bitq

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Static, System
Range

CM_ENABLE_FAST_MASTER_ELECTION

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.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_ENABLE_FAST_NET_ERROR_DETECTION

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	Y
Class	Optional, Adjustable, Static, System
Range

CM_ENABLE_SET_LIMITS_FOR_INSTANCE

If CM_ENABLE_SET_LIMITS_FOR_INSTANCE is on, CM automatically \

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_FENCE

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

CM_FILE_AUTO_RESTART_SSVR

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_FORCE_INSTANCE_KILL

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_GUARD_LOG_DEST

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

CM_HEARTBEAT_EXPIRE specifies the length of the heartbeat expire used to control TBCM. The length must be a multiple 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_LOCAL_IP_VERSION

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.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	4
Class	Optional, Adjustable, Static, System
Range	4 or 6

CM_LOG_DEST

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

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

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, Static, System
Range	100K - INT64_MAX

CM_LOOP_TIMEOUT

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	200
Class	Optional, Adjustable, Static, System
Range

CM_MODE_OBSERVER

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

CM_MST_SAFEGUARD_EXPIRE

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.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	5
Class	Optional, Adjustable, Static, System
Range

CM_NAME

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_NETWORK_AUTO_RESTART

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_NET_EXPIRE_MARGIN

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	5
Class	Optional, Adjustable, Static, System
Range

CM_OBSERVER_EXPIRE

CM_OBSERVER_EXPIRE specifies the length of the heartbeat expire used to check between TBCM Observer and TBCM. The length must be smaller than summation of IPARAM(CM _HEARTBEAT_EXPIRE) and CM_NET_EXPIRE_MARGIN. Heartbeat expire is the reference time that TBCM Observer uses to detect possible failures in other TBCM nodes.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	60
Class	Optional, Persistent, Static, System
Range

CM_OBSERVER_PORT

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Persistent, Static, System
Range	1024 - 65535

CM_PORT

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_REGARD_NETHB_AS_SERIOUS

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_RESOURCE_FILE

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

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

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_REVIVAL_WAIT_INST_TIMEOUT

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	30
Class	Optional, Adjustable, Static, System
Range

CM_REVIVAL_WAIT_NODE_TIMEOUT

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	20
Class	Optional, Adjustable, Static, System
Range

CM_REVIVAL_WAIT_TIMEOUT

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.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	5
Class	Optional, Adjustable, Static, System
Range

CM_SVC_AUTO_START_ON_BOOT

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_TAS_VM_ADDR

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.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"127.0.0.1"
Class	Optional, Adjustable, Static, System
Range

CM_TAS_VM_PORT

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.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"32000"
Class	Optional, Adjustable, Static, System
Range

CM_TIME_UNIT

CM_TIME_UNIT specifies the length of the time tick to be used to control TBCM. Other time-related pa rameters 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

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_USE_ASENV

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.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_USE_AWS_EC2

Whether to use amazon AWS EC2 virtual machine.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_USE_AWS_EC2_PRIVATE

Whether to use amazon AWS EC2 virtual machine in private subnet.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_USE_AWS_EC2_PUBLIC

Whether to use amazon AWS EC2 virtual machine in public subnet.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_USE_TAS5_STORAGE

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

CM_VIP_FAILOVER_BASED_ON_SVC_STATUS

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.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Dynamic, System
Range

CM_VIP_RESTART_COUNT

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.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	1
Class	Optional, Adjustable, Static, System
Range

CM_VIP_STAT_CHECK_INTERVAL

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	1
Class	Optional, Adjustable, Static, System
Range

CM_WATCHDOG_EXPIRE

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_HEART BEAT_EXPIRE.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	290
Class	Optional, Persistent, Static, System
Range

COMMIT_FLUSH_REQUEST

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

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

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

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

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

CREATE_STORED_OUTLINES

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

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)

CURSOR_SHARING

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_DDD_TIMEOUT_ON_SLOG

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

CWS_RECL_MAX_RESOURCES

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_RE SOURCES_RATIO)
Class	Optional, Adjustable, Static, System
Range

CWS_RESOLVE_CVT_DEADLK_FORCE

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.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Dynamic, System
Range

CWS_RSBTBL_SIZE

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

DBLINK_BATCH_UPDATE_ROW_COUNT

Number of rows to be processed at the same time during batch update through a database link. If set to the default value 0, batch update is disabled.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Dynamic, Session
Range

DBLINK_CONN_TIMEOUT

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	100
Class	Optional, Adjustable, Dynamic, Session
Range	0 - INT32_MAX

DBLINK_CONN_VALIDATION_SKIP_INTERVAL

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

DBLINK_QUERY_TIMEOUT

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	0
Class	Optional, Adjustable, Dynamic, Session
Range	0 - INT32_MAX

DBMS_LOG_DEST

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

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

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, Static, System
Range	100K -

DBWR_CNT

DBWR_CNT specifies the number of threads 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

DBWR_USE_AIO

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	(USE_ACTIVE_STORAGE || strcmp(INSTANCE_TYPE, "AS") == 0 || strcmp(IN STANCE_TYPE, "ACTIVE_STORAGE") == 0) ? N : iparam_dbwr_aio_as_de fault()
Class	Optional, Adjustable, Static, System
Range

DB_BLOCK_SIZE

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

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.

● 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)) - MEMORY_TABLESPACE_SIZE
Class	Optional, Adjustable, Static, System
Range

DB_CREATE_FILE_DEST

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

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	USE_ACTIVE_STORAGE ? 128 : 32
Class	Optional, Adjustable, Dynamic, Session
Range	1-1024

DB_KEEP_CACHE_SIZE

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

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

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

DB_RECYCLE_CACHE_SIZE specifies the size of the RECYCLE buffer pool.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Static, System
Range

DB_UNIQUE_NAME

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

● Parameter Format

Property	Description
Parameter Type	String
Default Value	DB_NAME
Class	Optional, Persistent, Static, System
Range

DD_CACHE_MAX

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

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

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

DIRTY_BLOCK_WRITE_ISSUE_TIME

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.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	1800
Class	Optional, Adjustable, Dynamic, System
Range

DISK_PATH

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

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

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

DUMP_EXSTAT_ON_STMT_CANCEL

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

ENCRYPTION_WALLET_FILE

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 [...] ]

ENCRYPT_GLOBAL_KEY_FILE

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

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Static, System
Range
Syntax	_ENCRYPT_GLOBAL_KEY_FILE=filename[:filename [...] ]

EXTRA_LISTENER_PORTS

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

EXTRA_LISTENER_PORTS_6

Multiple ipv6 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

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

EX_MEMORY_COMPENSATE_INTERVAL

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 -

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-

EX_MEMORY_DRIFT_RATIO

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

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

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	MIN( MAX(WTHR_PROC_CNT * WTHR_PER_PROC * 4 * (!!CLUS TER_DATABASE + 1), 128), 100000)
Class	Optional, Adjustable, Static, System
Range

FLASHBACK_LOG_ARCHIVE_DEST

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

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

FLASHBACK_LOG_ARCHIVE_FORMAT

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

FLASHBACK_LOG_BUFFER

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.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Static, System
Range	(DB_BLOCK_SIZE) * 4 - 1G

FLASHBACK_MARKER_INTERVAL

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.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	86400
Class	Optional, Adjustable, Dynamic, System
Range

GATHER_SQL_EXEC_TIME

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

ATHER_SQL_PLAN_STAT

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

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 * DFLT_DB_FILE_MULTIBLOCK_READ_COUNT) -

HBASE_CONNECTOR_SCAN_CACHE

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

HSM_LIB_FILE

Absolute library path with the library file name. It is used for linking with an HSM device.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Static, System
Range
Syntax	HSM_LIB_FILE=filename[:filename [...] ]

HSM_NOT_USE_WRAPPING

Option to use the PKCS #11 wrapping key option for linking an HSM device.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

HSM_TTE_KEY_BACKUP_FILE_PATH

HSM_TTE_KEY_BACKUP_FILE_PATH specifies/determines the location of the tte key backup file. It must be specified as an absolute path.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Static, System
Range
Syntax	HSM_TTE_KEY_BACKUP_FILE_PATH=filename[:filename [...] ]

IFF_STORAGE_PROCESSING

INDEX FAST FULL STORAGE 사용 여부

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

ILOG_DEST

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

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. Other wise, 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

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

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

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 or tibero boot, the oldest file (included backup directory) 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

INMEMORY_QUERY

Specifies whether in-memory columns allowed.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Dynamic, Session
Range

INMEMORY_SIZE

In-memory column store로 할당하는 memory size

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Static, System
Range	100M -

INSTANCE_NUMBER

INSTANCE_NUMBER specifies the instance number.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	THREAD
Class	Optional, Adjustable, Static, System
Range	0

INSTANCE_TYPE

INSTANCE_TYPE specifies whether an instance is a database instance or a Active Storage instance.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"TIBERO"
Class	Optional, Persistent, Static, System
Range	TIBERO | AS | ACTIVE_STORAGE

IP_VERSION

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. If use both IPv4 and IPv6, set the configuration to 10.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	4
Class	Optional, Adjustable, Static, System
Range	0, 4, 6, or 10

JAVA_CLASS_PATH

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_CRE ATE_FILE_DEST/java.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Static, System
Range

JOB_HISTORY_LOG

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_SCHEDULING_MAX_TIMEOUT

JOB_SCHEDULING_MAX_TIMEOUT specifies the maximum interval of time (in seconds) to execute the JOB SCHEDULER.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	3600
Class	Optional, Adjustable, Dynamic, System
Range	1 ~ 999999

JOB_TRACE_LOG

JOB_TRACE_LOG determines whether to write a internal log 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

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

LGWR_USE_AIO

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

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	(USE_ACTIVE_STORAGE || strcmp(INSTANCE_TYPE, "AS") == 0 || strcmp(IN STANCE_TYPE, "ACTIVE_STORAGE") == 0) ? N : iparam_aio_as_default()
Class	Optional, Adjustable, Static, System
Range

LIBRARY_CACHE_MAX

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

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

LISTENER_IP specifies the IP used by listener. IPv4 addresses are supported.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"-1"
Class	Optional, Adjustable, Static, System
Range

LISTENER_IP_6

LISTENER_IP_6 specifies the IP used by listener. IPv6 addresses are supported.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"-1"
Class	Optional, Adjustable, Static, System
Range

LISTENER_PORT

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

LISTENER_PORT_6

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

LISTENER_VIP_PORT

LISTENER_VIP_PORT is a port used by a listener for VIP. If LISTENER_VIP_PORT is set differently from LISTENER_PORT, the listener can accept connections from both ports. When connecting to a database through VIP, a client must use LISTENER_VIP_PORT so that sessions are cleaned up during the VIP failback process. When using an active cluster, it is recommended to set to the same value for all database instances.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	LISTENER_PORT
Class	Optional, Adjustable, Static, System
Range	1024 - 65535

LOAD_METRIC_AUTO_INTERVAL

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

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

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

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, Adjustable, Static, System
Range

LOCAL_CLUSTER_ADDR

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

LOCAL_CLUSTER_ADDR_IPV6

LOCAL_CLUSTER_ADDR_IPV6 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

LOCAL_CLUSTER_IP_VERSION

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	4
Class	Optional, Adjustable, Static, System
Range	4 or 6

LOCAL_CLUSTER_PORT

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

LOCAL_CLUSTER_PORT_IPV6

LOCAL_CLUSTER_PORT_IPV6 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

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

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

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

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

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

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

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

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

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

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

LOG_ARCHIVE_FORMAT specifies the format of the archive log file. (%d:db id, %r:resetlog tsn, %s:se quence number, %S:zero filled sequence number, %t:thread number, %T:time YYYYMMDD_HH24MISS)

● 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

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, Adjustable, Dynamic, System
Range

LOG_ARCHIVE_RETRY_TIME

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

Size of the memory space where redo logs are stored. @range : (DB_BLOCK_SIZE) * 4 - 1G

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	10 * 1024 * 1024
Class	Optional, Adjustable, Static, System
Range

LOG_CHECKPOINT_INTERVAL

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

LOG_CHECKPOINT_TIMEOUT specifies a time interval, in seconds, at which the checkpoint will occur.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Dynamic, System
Range	0 - INT32_MAX

LOG_DEFAULT_DEST

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_FILE_WITH_GROUP_READ_PERM

If set to Y, newly created redo and archive log files have the group read permission.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

LOG_LVL_AS

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

LONGOPS_KEEP_INTERVAL specifies the retention time (in minutes) for history of long-running opera tions.

● 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

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

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, Adjustable, Static, System
Range

LSNR_DENIED_IP

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_DE NIED_IP will be ignored.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

LSNR_DENIED_IP_FILE

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

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_INVIT ED_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

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

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

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

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

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, Static, System
Range	100K - INT64_MAX

LSNR_SCHEDULE_SAME_PROC_FIRST

Scheduling method for passing a new session to a working process when a listener gets the session. There are two methods. If set to Y, sessions are sent to a working process until all wthr of the process are in busy state. If set to N, sessions are evenly distributed to multiple working processes.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Static, System
Range

MAX_BG_SESSION_COUNT

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_SES SION_COUNT and must be divisible by WTHR_PER_PROC.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	(MAX_SESSION_COUNT - MAX_FG_SESSION_COUNT)
Class	Optional, Adjustable, Static, System
Range	0 ~ INT32_MAX

MAX_FG_SESSION_COUNT

Number of sessions for user connections requested by LSNR among MAX_SESSION_COUNT. As many as MAX_SESSION_COUNT - MAX_FG_SESSION_COUNT sessions can be started by internal tasks. MAX_FG_SESSION_COUNT must be less than or equal to MAX_SESSION_COUNT and must be divis ible by WTHR_PER_PROC.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	MAX_SESSION_COUNT
Class	Optional, Adjustable, Static, System
Range	0 ~ INT32_MAX

MAX_SESSION_COUNT

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). In Windows NT. Windows Server 2003 and below, MAX_SESSION_COUNT should be set to an appropriate value of 1500 or less.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	20
Class	Mandatory, Adjustable, Static, System
Range	1 ~ INT32_MAX

MEMORY_MAX_TARGET

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

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

MEMORY_TABLESPACE_SIZE

MEMORY_TABLESPACE_SIZE specifies the maximum size of the memory tablespace.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Static, System
Range	0

MEMORY_TARGET

Specifies the current total amount of usable memory (shared memory plus private memory) of an instance, in bytes.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Mandatory, Adjustable, Dynamic, System
Range	1M -

MEM_LOG_DEST

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

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

NBU_ARCHIVELOG_SEARCH

Whether to search archive logs in NetBackup to show in v$archive_dest_files or restore them for Media Recovery.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

NBU_ARCHIVE_POLICY_NAME

NetBackup policy name for archivelogs

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"TIBERO_ARCHIVE_POLICY"
Class	Optional, Adjustable, Dynamic, System
Range

NBU_ARCHIVE_RETRY_CNT

Retry counts when fails to create an archivelog at NetBackup.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	2
Class	Optional, Adjustable, Dynamic, System
Range

NBU_BACKUP_INST_SID

SID of instance performing rmgr backup operations

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_BACKUP_POLICY_NAME

NetBackup policy name for backupsets

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"TIBERO_BACKUP_POLICY"
Class	Optional, Adjustable, Dynamic, System
Range

NBU_BSA_API_VERSION

Backup service API version for NetBackup connection.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"1.1.0"
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_COUNT

the number of NetBackup clients

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_0

hostname of NetBackup client 0

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_1

hostname of NetBackup client 1

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_2

hostname of NetBackup client 2

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_3

hostname of NetBackup client 3

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_4

hostname of NetBackup client 4

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_5

hostname of NetBackup client 5

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_6

hostname of NetBackup client 6

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_7

hostname of NetBackup client 7

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_8

hostname of NetBackup client 8

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOSTNAME_9

hostname of NetBackup client 9

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_CLIENT_HOST_NAME

Hostname of the system where NetBackup client locates.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_MASTER_HOST_NAME

Hostname of the system where NetBackup master locates.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_OBJ_OWNER_GROUP_NAME

Owner group name which can access to NetBackup.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_OBJ_OWNER_NAME

Owner name who can access to NetBackup.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_PROC_WTHR_CNT

Number of NetBackup working processes. Its name should be NBU_PROC_CNT. RMGR parallel back up/recover uses 1 lock_slave + rv slaves for DF, not --archive-only.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	(RECO_PROC_WTHR_CNT-_CACHE_RECO_DOP-3)/2
Class	Optional, Adjustable, Static, System
Range	1 - 4096

NBU_SCHEDULE_NAME

NetBackup schedule name

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

NBU_SKIP_HOST_CHECK

skip the consistency check between hostname and SID

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

NBU_TWO_PHASE_CF_BACKUP

Whether to create a backup as a local file before sending the cf backup to Netbackup. @range :

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Dynamic, System
Range

NLS_CALENDAR

NLS_CALENDAR specifies which calendar system Tibero uses.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"GREGORIAN"
Class	Optional, Adjustable, Dynamic, Session
Range	GREGORIAN | JAPANESE IMPERIAL | THAI BUDDHA

NLS_COMP

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

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 10 characters in length

NLS_DATE_FORMAT

NLS_DATE_FORMAT specifies the default date format for date display.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"YYYY/MM/DD"
Class	Optional, Adjustable, Dynamic, Session
Range	Any valid date format mask up to 64 characters in length

NLS_DATE_LANGUAGE

NLS_DATE_LANGUAGE specifies the language to use the spelling of date format elements.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"KOREAN"
Class	Optional, Adjustable, Dynamic, Session
Range	KOREAN | AMERICAN | JAPANESE | VIETNAMESE | BRAZILIAN POR TUGUESE | TRADITIONAL CHINESE | RUSSIAN | SIMPLIFIED CHINESE | THAI | GERMAN | SPANISH | ITALIAN | BULGARIAN | CATALAN | DANISH | DUTCH | FINNISH | POLISH | FRENCH | NORWEGIAN | LITHUANIAN | CROATIAN | CZECH | ESTONIAN | HEBREW | HUNGARIAN | ICELANDIC | LATVIAN | PORTUGUESE | ROMANIAN | SLOVAK | SWEDISH | TURKISH | ENGLISH

NLS_DUAL_CURRENCY

NLS_DUAL_CURRENCY specifies the dual currency symbol string for the 'U' number format.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"$"
Class	Optional, Adjustable, Dynamic, Session
Range	Maximum 10 characters in length

NLS_ISO_CURRENCY

NLS_ISO_CURRENCY determines the international currency symbol string for the 'C' number format.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"KOREA"
Class	Optional, Adjustable, Dynamic, Session
Range	Any valid NLS_TERRITORY value

NLS_LANGUAGE

NLS_LANGUAGE specifies the current language for the session.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"KOREAN"
Class	Optional, Adjustable, Dynamic, Session
Range	AMERICAN | KOREAN | JAPANESE | SIMPLIFIED CHINESE | BRAZILIAN PORTUGUESE | BULGARIAN | CATALAN | CZECH | DANISH | DUTCH | EN GLISH | ESTONIAN | FINNISH | FRENCH | GERMAN | HEBREW | HUNGARIAN | ICELANDIC | ITALIAN | LITHUANIAN | NORWEGIAN | POLISH | POR TUGUESE | ROMANIAN | RUSSIAN | SLOVAK | SPANISH | SWEDISH | THAI | TRADITIONAL CHINESE | TURKISH | VIETNAMESE

NLS_LANG_AT_BOOT

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

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

NLS_NUMERIC_CHARACTERS specifies the characters for the thousand group separator and decimal character for the session.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	".,"
Class	Optional, Adjustable, Dynamic, Session
Range	Two different single-byte characters, excluding the following characters: +, -, <, >

NLS_SORT

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 | EBCDIC | GERMAN | FRENCH | DUTCH | THAI_DICTIONARY | SCHINESE_PINYIN | UNICODE_BINARY

NLS_TERRITORY

NLS_TERRITORY specifies the name of the territory for the session.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"KOREA"
Class	Optional, Adjustable, Dynamic, Session
Range	AMERICA | KOREA | JAPAN | CHINA | AUSTRALIA | AUSTRIA | BELGIUM | BRAZIL | CANADA | CZECH REPUBLIC | EGYPT | FILAND | FRANCE | GER MANY | GREECE | HONG KONG | HUNGARY | INDONESIA | IRAQ | ITALY | MALAYSIA | MEXICO | POLAND | RUSSIA | SINGAPORE | SPAIN | SWEDEN | TAIWAN | THAILAND | THE NETHERLANDS | TURKEY | UKRAINE | UNITED KINGDOM | VIETNAM

NLS_TIMESTAMP_FORMAT

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

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

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

NLS_TIME_TZ_FORMAT

NLS_TIME_TZ_FORMAT specifies the default time time zone format to be used when the database is started.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"HH24:MI:SSXFF TZR"
Class	Optional, Adjustable, Dynamic, Session
Range	Maximum 64 characters in length

NTF_LISTEN_PORT

Listening port for NTF sender. Server event subscriber connects to this port.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	LISTENER_PORT + 6
Class	Optional, Adjustable, Static, System
Range	1024 ~ 65535

OMIT_PSM_SQL_LOG_ON_MEMORY

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

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_CAPTURE_SQL_PLAN_BASELINES

Enables or disables to capture and save repeated SQL statements for SQL plan baselines.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES_DURA TION

Time interval within which an already existing SQL statement is not captured.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Dynamic, Session
Range	0 -

OPTIMIZER_LOG_OUTLINE

Specifies whether or not to log the plan outline.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

OPTIMIZER_MODE

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

optimizer trace dump

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

OPTIMIZER_USE_INVISIBLE_INDEXES

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

OPTIMIZER_USE_SQL_PLAN_BASELINES

Enables or disables to use the created SQL plan baselines.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

OPTIMIZER_USE_SQL_PROFILES

Specifies whether or not to use the profile.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

OS_AUTH_PREFIX

Prefix for OS authenticated user.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"OSA$"
Class	Optional, Adjustable, Static, System
Range

PARALLEL_DEFAULT_DOP

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	4
Class	Optional, Adjustable, Dynamic, Session
Range

PARALLEL_GRANULE_SIZE

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

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

PEP_PROC_CNT specifies the number of pe processes.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	6
Class	Optional, Adjustable, Static, System
Range	0 - 10000

PP_SAVE_SYS_BINDVAR

Specifies whether or not to save system bind variables in PP cache when cursor_sharing is set to 'force'.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Dynamic, Session
Range

PRIVKEY_FILE

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

PSM_CODE_TYPE specifies the interpreter mode in which PSM is implemented. It is efficient to use in terpreter mode for anonymous blocks.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"INTERPRETED"
Class	Optional, Adjustable, Dynamic, Session
Range	INTERPRETED

PSM_DEBUG

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

PSM_ERROR_CONV

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

PSM_SHLIB_DIR

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. (deprecated)

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

PSM_SQL_RESULT_CACHE

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

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

QUERY_REWRITE_INTEGRITY

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

it specifies the number of recovery working processes.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	35 + _CACHE_RECO_DOP
Class	Optional, Adjustable, Static, System
Range	1 - INT32_MAX

RESULT_CACHE_MAX_RATIO

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

RESULT_CACHE_MAX_SIZE

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

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

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

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

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

RMGR_CATALOG_SID

DB SID of the catalog database.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

RMGR_NBU_BACKUP_DEST

RMGR_NBU_BACKUP_DEST specifies the directory where RMGR backup files are stored when USE_NBU_FOR_BACKUPSET=Y.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

RMGR_PRIMARY_SID

DB SID of the primary database. When tbrmgr connected to the standby database and RMGR_PRIMA RY_SID is defined, tbrmgr also connects to the primary database.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

RMGR_RESTORE_BACKUP_CF

Always restores CF, although CF exists.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

RMGR_TAR_PATH

tar path for RMGR

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

RSBTBL_BUCKET_CNT_PER_ROOT_LIST_FOR_RECON FIGURATION

RSBTBL_BUCKET_CNT_PER_ROOT_LIST_FOR_RECONFIGURATION specifies the number of rsb table buckets in a root list.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	100
Class	Optional, Adjustable, Dynamic, System
Range

RSRC_CHECK_INTERVAL

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

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

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

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

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

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

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 pa rameter 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

SEM_SET_COUNT

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

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, Adjustable, Static, System
Range

SERVER_LOAD_TOLERANCE

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

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

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|IM MEDIATE|ABORT|SWITCHOVER|ABNORMAL}

SESS_IGNORE_INVALID_CLIENT_NLS_SETTING

SESS_IGNORE_INVALID_CLIENT_NLS_SETTING specifies whether to ignore result of format validation check for client's NLS parameter.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

SHARED_PARAMETER_FILE

SHARED_PARAMETER_FILE specifies the parameter file that can be shared. (deprecated)

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Static, System
Range

SHM_KEY

SHM_KEY specifies the key of the shared memory to be used by each instance. In general, if this param eter 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

SHP_ALLOC_DUMP_IDX

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

SHP_ALLOC_FULL_DUMP

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

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

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_DISPLAY_YEAR

Option to output a year in sys.log generated by Tibero. If set to Y, the log format is YYYY/MM/DD. If set to N, it is MM/DD.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Static, System
Range

SLOG_FILE_SIZE

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

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

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

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

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 -

SLOG_VIEW_SIZE

SLOG_VIEW_SIZE specifies the maximum size of logs to load on v$slog. If the value is set to 0, all logs in sys.log will be loaded on v$slog.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	1048576
Class	Optional, Adjustable, Dynamic, System
Range	0 - 1G

SMR_DELAY_TIME

Delay redo apply in SMR by this time. (in minutes)

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Dynamic, System
Range	0 - 525600

SMR_SGMT_DROP_TIMEOUT

Number of seconds to wait for cursors that are using segments that need to be dropped. SMR will invalidate those cursors after the number of seconds defined in SMR_SGMT_DROP_TIMEOUT. If SMR_SGMT_DROP_TIMEOUT is defined as 0, SMR will wait until those cursors are closed.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Dynamic, System
Range	0 ~ UINT64_MAX

SORT_AREA_SIZE

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 * DFLT_DB_FILE_MULTIBLOCK_READ_COUNT) -

SQLTUNE_CATEGORY

SQL tuning category. The Optimizer applies a profile that matches this category.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"DEFAULT"
Class	Optional, Adjustable, Dynamic, Session
Range	up to 128 characters

SQL_LOG_ON_MEMORY

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

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

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

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

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

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 recom mended 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

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

SQL_TRACE_LEVEL

Controls the amount of information saved in the SQL trace. [1]: Traces basic information (default), [4]: Level 1 + Bind information, [8]: Level 1 + Wait information, [12]: Level 1 + Level 4 + Level 8

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	1
Class	Optional, Adjustable, Dynamic, Session
Range	1 | 4 | 8 | 12

SQL_TRANSLATION_PROFILE

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, Session
Range

SSVR_FC_DIRTY_BIN_RATIO_MAX

SSVR_FC_DIRTY_BIN_RATIO_MAX specifies the maximum ratio of dirty bin to keep in the storage server flash cache.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	80
Class	Optional, Adjustable, Dynamic, System
Range

SSVR_FC_FREE_BIN_RATIO

SSVR_FC_FREE_BIN_RATIO specifies the ratio of fre bin to keep in the storage server flash cache.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	10
Class	Optional, Adjustable, Dynamic, System
Range

SSVR_FC_WS_CNT

SSVR_FC_WS_CNT specifies the number of working sets per device in the storage server flash cache.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	MAX(1, get_ncpu())
Class	Optional, Adjustable, Static, System
Range
Syntax	1 ~ INT32_MAX

SSVR_RECV_PORT_START

SSVR_RECV_PORT_START specifies the listening port of the storage server.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	Depending on system environment
Class	Optional, Adjustable, Static, System
Range	1024 - 65535

SSVR_TPM_SENDER_INTERVAL

Specifies the interval (in 0.1 s) for checking/retrying sender connections when TPM is activated in SSVR (Storage Server).

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	50
Class	Optional, Adjustable, Dynamic, System
Range

SSVR_USE_AGNT

Specifies whether or not to activate AGNT process that enables background utilities, such as callstack dump, in SSVR (Storage Server).

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

SSVR_USE_FC

SSVR_USE_FC specifies whether or not the storage server uses flash cache.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Static, System
Range

SSVR_USE_IB

SSVR_USE_IB specifies whether or not to use InfiniBand for server connections.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	!SSVR_USE_TCP
Class	Optional, Adjustable, Static, System
Range

SSVR_USE_SDM

SSVR_USE_SDM specifies whether or not the storage server uses Storage Data Map (SDM).

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Static, System
Range

SSVR_USE_TCP

SSVR_USE_TCP specifies whether or not to use TCP for server connections.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

SSVR_USE_TPM

Specifies whether or not to activate TPM (Tibero Performance Monitor) in SSVR (Storage Server).

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

SSVR_WTHR_CNT

ssvr worker threads count

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	MAX(1, get_ncpu())
Class	Optional, Adjustable, Static, System
Range

STANDBY_ENABLE_CASCADING

Allows LNW to send Redo Log to another node in recovery mode

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

STANDBY_ENABLE_LOG_RECOVERY

Determines whether to send redo log for a dead node in TAC standby.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

STANDBY_ENABLE_TAC_MULTINODE

Enable two nodes or more to boot for standby in TAC-standby.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

TANDBY_FILE_NAME_CONVERT

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>}, ...

STANDBY_FLUSH_WAIT

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

STANDBY_LOG_ARCHIVE_DEST

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

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

STANDBY_LOG_ARCHIVE_FORMAT

Specifies the format of the standby archive log file.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"st-t%t-r%r-s%s.arc"
Class	Optional, Adjustable, Dynamic, System
Range

STANDBY_USE_OBSERVER

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

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

STORAGE_PROCESSING

STORAGE_PROCESSING specifies whether or not the databases use smart scan.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

SUMMARY_FIRST_IN_GROUPBY_CUBE

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

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

TAS5_STORAGE_MODE

TAS5_STORAGE_MODE specifies whether or not to use TAS5 with databases or storage servers.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

TAS_DB_UUID

TAS_DB_UUID specifies a unique ID to access cloud storage VM.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"DBUUID00"
Class	Optional, Adjustable, Static, System
Range

TAS_OPEN_FILE_MAX

TAS_OPEN_FILE_MAX specifies the maximum number of files that can be opened in the cloud storage.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	4096
Class	Optional, Adjustable, Static, System
Range

TAS_SERVER_IP

TAS_SERVER_IP specifies the IP of databases or storage servers used in TCS configuration.

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"127.0.0.1"
Class	Optional, Persistent, Static, System
Range

TAS_VM_ADDR

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"127.0.0.1"
Class	Optional, Adjustable, Static, System
Range

TAS_VM_PORT

● Parameter Format

Property	Description
Parameter Type	String
Default Value	"32000"
Class	Optional, Adjustable, Static, System
Range

TCP_RCVBUF_SIZE

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

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

TDE_HASH_VERIFICATION

Verify data integrity during decryption.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

TDE_SELF_UPDATE_MODIFICATION_DEFENCE

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

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_TS_CNT_MAX

The maximum number of temp tablespace that can be created.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	10
Class	Optional, Adjustable, Static, System
Range

THREAD

THREAD specifies the redo thread number to be used by instances.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	0
Class	Optional, Adjustable, Static, System
Range	0 - 1024

THROW_WHEN_GETTING_OSSTAT_FAIL

THROW_WHEN_GETTING_OSSTAT_FAIL specifies whether or not to throw an error when a call to get the 'osstat' information fails because the file doesn't exist in the system.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

TIBERO_PERFORMANCE_REPOSITORY

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

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

TOTAL_SHM_SIZE specifies the current total size of shared memory size used by instances.

● 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

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

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

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

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

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

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

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

TPR_SQL_PLAN_STAT

TPR_SQL_PLAN_STAT determines whether to collect statistics on an instance in the SQL statement execution plan at the time an SQL query is executed (only for TPR).

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

TRACE_DUMP_DEST

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

TSAM_PREFETCH_SIZE

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

TSN_SYNC_UDP_PORT

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

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

UNDO_RETENTION

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

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_ACCURATE_NUMERIC_FUNC

Performs more accurate calculations on numeric functions.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

USE_ACTIVE_STORAGE

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_AD_AUTH

Using AD authentication or NOT (for user authentication)

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

USE_BINARY_UPDATE

USE_BINARY_UPDATE determines wheter use or not auto-binary-update when main svr booting.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

USE_HSM

Option to use Hardware Security Module (HSM) to save data encryption keys.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

USE_HUGE_PAGE

Option to enable the SHM_HUGETLB flag in Linux to get shared memory segments with huge pages by using shmget().

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

USE_ILOG

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_NBU_FOR_ARCHIVELOG

Whether to create archive logs at NetBackup directly. If Y, no archive logs are created at local. For searching or restoring, use NBU_ARCHIVELOG_SEARCH.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

USE_NBU_FOR_BACKUPSET

When using RMGR, whether to create a backupset at NetBackup or restore the backupset from NetBackup.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

USE_NET_KEEPALIVE

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

USE_PROFILE

Determines whether to use the PROFILE feature.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	Y
Class	Optional, Adjustable, Dynamic, System
Range

USE_PROFILE_LOGIN_LOGOUT_TIME

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

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

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_SERVER_EVENT_NOTIFICATION

whether use server event notification or not.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

USE_STANDBY_REDO_LOG

Whether to use standby redo log or not.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Static, System
Range

USE_STORED_OUTLINES

Determines whether to apply created outline.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, Session
Range

USE_TRUNCATE_PRIVILEGE

Determines whether to use the TRUNCATE PRIVILEGE feature.

● Parameter Format

Property	Description
Parameter Type	Boolean
Default Value	N
Class	Optional, Adjustable, Dynamic, System
Range

USE_TS_QUOTA

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

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

USGMT_ONLINE_MAX

Maximum number of undo segments created during database

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	1000
Class	Optional, Adjustable, Dynamic, System
Range

USGMT_ONLINE_MIN

Number of undo segments to create when the database starts.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	11
Class	Optional, Adjustable, Static, System
Range

UTL_FILE_DIR

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. (deprecated)

● Parameter Format

Property	Description
Parameter Type	String
Default Value	""
Class	Optional, Adjustable, Dynamic, System
Range

WALLET_FILE

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_PER_PEP

WTHR_PER_PEP specifies the number of worker threads per PE process(PEP) .

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	16
Class	Optional, Adjustable, Static, System
Range	1 ~ 10000

WTHR_PER_PROC

Number of worker threads in a worker process.

● Parameter Format

Property	Description
Parameter Type	Integer
Default Value	10
Class	Optional, Adjustable, Static, System
Range	1 ~ 10000

WTHR_PROC_CNT

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

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

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

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)