Server Property Information
For more information about SQL syntax to change properties, refer to the followings.
For more information about property types, refer to the followings.
V$PROPERTY: It displays the property list which can be altered while the system is operating or is restarting.
V$SPROPERTY: It is either the property which was set by reading the binary file, or the property list which is stored in the binary file.
V$DB_PROPERTY: It is a read-only property list which can be altered only when creating the database, and it can not be altered afterwards.
The followings describe basic information items of property in this manual.
Item | Description |
|---|---|
Name | Property name |
Summary | Short description of the property |
Data type | Data type of the property value |
Applicable phase | A startup phase which can be updated with ALTER SYSTEM or ALTER SESSION
|
Updatable | Whether property is updatable or not
|
ALTER SESSION | Whether property is updatable or not by using ALTER SESSION SET property_name |
ALTER SYSTEM | Whether property is updatable or not by using ALTER SYSTEM SET property_name
|
MIN | If the data type is BIGINT, it is the minimum value of property. If the data type is VARCHAR, the minimum value of property is N/A. |
MAX | If the data type is BIGINT, it is the maximum value of property. If the data type is VARCHAR, the maximum value of property is N/A. |
Default value | Default value of the property |
Property Alias Information
The information about the property alias is viewed through V$PROPERTY_ALIAS.
The basic information about the property alias written in this manual is as follows.
Item | Description |
|---|---|
Original name | It is the original name of the property. |
ALIAS | It is the name of the property alias. |
For more information about property alias list, refer to Property Alias.
CDISPATCHER_THREADS
It is an alias of CDISPATCHER_LOCKABLE_THREADS.
CLUSTER_COMMIT_SLAVES
It is an alias of CLUSTER_COMMIT_SLAVE_CSERVERS.
CLUSTER_SERVER_RESPONSE_ QUEUE_SIZE
It is an alias of CLUSTER_GSERVER_RESPONSE_QUEUE_SIZE.
CSERVER
It is an alias of CLUSTER_LOCKABLE_CSERVERS.
INCREMENTAL_CHECKPOINT_CRITERIA
It is an alias of BUFFER_DIRTY_PAGE_LIMIT.
LOCKLESS_CSERVERS
It is an alias of CLUSTER_LOCKLESS_CSERVERS.
MEMORY_MERGE_RUN_COUNT
It is an alias of INDEX_MERGE_RUN_COUNT.
MEMORY_SORT_RUN_SIZE
It is an alias of INDEX_SORT_RUN_SIZE.
SYSTEM_LOGGER_DIR
It is an alias of TRACE_SYSTEM_DIR.
ADMIN_SESSION_POOL_INIT_SIZE
Basic Information
Item | Description |
|---|---|
Name | ADMIN_SESSION_POOL_INIT_SIZE |
Summary | initial memory size for admin session pool |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1099511627776 (1T) |
Default value | 10485760 (10M) |
Description
It sets the initial memory size of the admin session pool.
ADMIN_SESSION_POOL_NEXT_SIZE
Basic Information
Item | Description |
|---|---|
Name | ADMIN_SESSION_POOL_NEXT_SIZE |
Summary | memory size to be expanded in admin session pool |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 131072 (128K) |
MAX | 1073741824 (1G) |
Default value | 1048576 (1M) |
Description
It sets how much to extend the memory size in the session pool when expanding the admin session pool space. It is valid only when ADMIN_SESSION_POOL_INIT_SIZE is bigger than 0.
AGING_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | AGING_INTERVAL |
Summary | aging interval time(ms) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 100000000 |
Default value | 10 |
Description
It sets the idle time (second) when an ager thread which deletes the previous version data does not have a job to process in MVCC based database.
AGING_PLAN_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | AGING_PLAN_INTERVAL |
Summary | aging plan interval time(s) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 31536000 |
Default value | 0 |
Description
The SQL plan which is older than AGING_PLAN_INTERVAL becomes the aging target.
ARCHIVELOG_DIR_1 ~ ARCHIVELOG_DIR_10
Basic Information
Item | Description |
|---|---|
Name | ARCHIVELOG_DIR_1 ~ ARCHIVELOG_DIR_10 |
Summary | archive log directory |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE(ARCHIVELOG_DIR_1), TRUE(ARCHIVELOG_DIR_2 ~ ARCHIVELOG_DIR_10) |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/archive_log |
Description
It specifies archiving directory of GOLDILOCKS database's online redo log file. Also, it specifies where to read of archive redo log file at media recovery. The online redo log file creates archive redo log file only in ARCHIVELOG_DIR_1.
ARCHIVELOG_DIR_1 sets only the system, but ARCHIVELOG_DIR_2 ~ ARCHIVELOG_DIR_10 sets the session.
ARCHIVELOG_FILE
Basic Information
Item | Description |
|---|---|
Name | ARCHIVELOG_FILE |
Summary | default archive log file |
Data type | VARCHAR |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | archive |
Description
It sets the prefix of the targeted file name stored in the archive directory when archiving the online redo logfile. The archive logfile's name consists of the prefix defined in ARCHIVELOG_FILE, followed by '_', the file sequence and the file extension 'log'. For example, the online logfile with a sequence number of 0 is archived as 'archive_0.log'.
ARCHIVELOG_MODE
Basic Information
Item | Description |
|---|---|
Name | ARCHIVELOG_MODE |
Summary | archive log mode(0:disable, 1:enable) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
The property is applied at database creation. The archivelog mode can be set to one of the following value.
0: NOARCHIVELOG
1: ARCHIVELOG
It does not affect archive log mode during operation after database is created. The archive log mode can be modified by using ALTER DATABASE {ARCHIVELOG | NOARCHIVELOG} in MOUNT phase.
BACKUP_DIR_1 ~ BACKUP_DIR_10
Basic Information
Item | Description |
|---|---|
Name | BACKUP_DIR_1 ~ BACKUP_DIR_10 |
Summary | backup directory |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE(BACKUP_DIR_1), TRUE(BACKUP_DIR_2 ~ BACKUP_DIR_10) |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/backup |
Description
A backup file is created when incremental backup is executed. Then it sets a directory of backup file to be read when restoring files using incremental backup. Incremental backups are created only in the directory set in BACKUP_DIR_1.
BACKUP_DIR_1 sets only the system, but BACKUP_DIR_2 ~ BACKUP_DIR_10 sets the session.
BLOCK_READ_COUNT
Basic Information
Item | Description |
|---|---|
Name | BLOCK_READ_COUNT |
Summary | value count for a block read |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 65536 |
Default value | 20 |
Description
The SQL executes operation by reading row in the unit of BLOCK_READ_COUNT which is a row bundle. BLOCK_READ_COUNT means the number of rows to be processed at a time when operation is executed. It is a basic unit of pipe-lining process of execution nodes which are used in SQL query processing.
If BLOCK_READ_COUNT value is big the processing performance improves, but many memory resources are used. The value between 10 and 100 is recommended. If the value becomes bigger than 100 the resource usage increases proportionately, but the performance improvement does not increase proportionately.
BROADCAST_INDEX_REBUILD_PROTOCOL
Basic Information
Item | Description |
|---|---|
Name | BROADCAST_INDEX_REBUILD_PROTOCOL |
Summary | broadcast index rebuild protocol |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to simultaneously rebuild the indexes on multiple members when rebuilding the index in cluster environment.
BROADCAST_REBALANCE_PROTOCOL
Basic Information
Item | Description |
|---|---|
Name | BROADCAST_REBALANCE_PROTOCOL |
Summary | broadcast rebalance protocol |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to simultaneously process protocol which can be processed on multiple members at the same time when performing table rebalancing in a cluster environment.
BUFFER_CACHE_SIZE
Basic Information
Item | Description |
|---|---|
Name | BUFFER_CACHE_SIZE |
Summary | buffer cache size ( byte ) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 MB |
MAX | 1 TB |
Default value | 64 MB |
Description
It sets the size of the buffer which cashes the page in the disk tablespace.
BUFFER_CHECKPOINT_LIST_COUNT
Basic Information
Item | Description |
|---|---|
Name | BUFFER_CHECKPOINT_LIST_COUNT |
Summary | number of buffer checkpoint lists |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 36 |
Default value | 1 |
Description
It is linked to the checklist when pages of disk tablespace cached to the buffer are updated. Each checkpoint list flushes updated pages linked to the checkpoint list by its own flush thread to the disk, and BUFFER_CHECKPOINT_LIST_COUNT sets the number of checkpoint lists and the number of flush threads.
BUFFER_DIRTY_PAGE_LIMIT
Basic Information
Item | Description |
|---|---|
Name | BUFFER_DIRTY_PAGE_LIMIT |
Summary | a limit on the number of dirty pages in the buffer cache |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 134217728 |
Default value | 0 |
Description
Pages updated in the system buffer cache is applied to the disk at checkpoint, and if the buffer cache size is big and updated pages are a lot, then the checkpoint takes a long time and it affects the service. GOLDILOCKS performs the incremental checkpoint which applies updated pages to the disk when the number of updated pages are over a specified number in the system. And BUFFER_DIRTY_PAGE_LIMIT sets the criteria to perform the incremental checkpoint.
For example, when this value is set to 1000, if the updated pages are less than 1000 in the system, then the updated pages are not applied to the disk. However, if the updated pages are 1000 or above, then the updated pages in the buffer are applied to the disk.
The default value is 0, and it means infinity. In this case, it does not perform the incremental checkpoint even when all cached pages in the buffer are updated.
Set the appropriate value for BUFFER_DIRTY_PAGE_LIMIT and INCREMENTAL_DATAFILE_HEADER_UPDATE_CRITERIA considering the restart recovery time and its effect on the service.
ALIAS
Item | Description |
|---|---|
Original name | BUFFER_DIRTY_PAGE_LIMIT |
ALIAS | INCREMENTAL_CHECKPOINT_CRITERIA |
BUFFER_FLUSH_THREADS
Basic Information
Item | Description |
|---|---|
Name | BUFFER_FLUSH_THREADS |
Summary | number of buffer flush threads |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 36 |
Default value | 1 |
Description
It is linked to the flush list then requests flush to the buffer flusher, to reuse bch which cached the updated pages in the buffer lru list. In this case, BUFFER_FLUSH_THREADS sets the number of buffer flushers and flush lists to be used in the database.
BUFFER_FLUSHING_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | BUFFER_FLUSHING_INTERVAL |
Summary | buffer flushing interval time (sec) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 86400 (1 day) |
Default value | 3 |
Description
It sets the idle time (sec) when the job to be processed by the buffer flusher flushing updated disk tablespace pages to the disk does not exist.
BUFFER_FREE_LIST_COUNT
Basic Information
Item | Description |
|---|---|
Name | BUFFER_FREE_LIST_COUNT |
Summary | number of buffer free lists |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 64 |
Default value | 16 |
Description
It sets the number of buffer free lists connecting bch which are instantly available to use in the buffer cache.
BUFFER_HASH_BUCKETS
Basic Information
Item | Description |
|---|---|
Name | BUFFER_HASH_BUCKETS |
Summary | number of buffer hash buckets |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1073741824 |
Default value | 0 |
Description
It sets the number of hash buckets for the disk tablespace pages cached in the buffer. It can be set from 0 to 1073741824, and 0 is set by calculating hash buckets as many as pages which can be cached to the buffer which is set according to BUFFER_CACHE_SIZE. If the buffer size is smaller than the specified value, then it adjusts the number of hash buckets to the buffer size.
BUFFER_HOT_REGION_CRITERIA
Basic Information
Item | Description |
|---|---|
Name | BUFFER_HOT_REGION_CRITERIA |
Summary | threshold touch count of hot region in the buffer lru list |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 2 |
MAX | 100 |
Default value | 2 |
Description
It sets touch count to transfer pages existing in the cold region to the hot region in buffer lru list.
BUFFER_HOT_REGION_PERCENT
Basic Information
Item | Description |
|---|---|
Name | BUFFER_HOT_REGION_PERCENT |
Summary | the percentage of hot region in the buffer lru list |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 80 |
Default value | 20 |
Description
It sets the proportion (percentage) of hot region pages to the entire page in the buffer lru list.
BUFFER_LRU_LIST_COUNT
Basic Information
Item | Description |
|---|---|
Name | BUFFER_LRU_LIST_COUNT |
Summary | number of buffer LRU lists |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 64 |
Default value | 16 |
Description
It sets the number of lru lists to select a victim among pages in use by caching when the free buffer for caching disk tablespace pages does not exist.
BUFFER_LRU_SCAN_PERCENT
Basic Information
Item | Description |
|---|---|
Name | BUFFER_LRU_SCAN_PERCENT |
Summary | the percentage of buffers to inspect when looking for free |
Data type | NO MOUNT or above |
Applicable phase | TRUE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 10 |
MAX | 100 |
Default value | 40 |
Description
If the free buffer available right now does not exist in the system, then it searches for the reusable buffer from the lru list to cache the disk tablespace page to the buffer. BUFFER_LRU_SCAN_PERCENT sets the percent of the buffer pages set in BUFFER_CACHE_SIZE, so that it can determine the number of pages to check to find the reusable buffer from lru list.
BUFFER_MULTIPAGE_READ_COUNT
Basic Information
Item | Description |
|---|---|
Name | BUFFER_MULTIPAGE_READ_COUNT |
Summary | maximum number of pages read in one I/O operation during a full scan |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 128 |
Default value | 32 |
Description
It sets the maximum number of pages to be used for one time disk IO when full scanning the disk table.
BUFFER_PREFETCH_PAGE_COUNT
Basic Information
Item | Description |
|---|---|
Name | BUFFER_PREFETCH_PAGE_COUNT |
Summary | the maximum number of pages to be prefetched to the buffer per I/O operation |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 128 |
Default value | 32 |
Description
It sets the maximum number of pages nearby to be prefetched per a disk I/O when accessing to the page in the disk tablespace which does not exist in the buffer.
BULK_IO_PAGE_COUNT
Basic Information
Item | Description |
|---|---|
Name | BULK_IO_PAGE_COUNT |
Summary | page count for bulk IO operation |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 128 |
MAX | 131072 |
Default value | 3840 |
Description
It is used when IO READ of the data file occurs during server restart, or when IO WRITE occurs during creating a data file.
The heap memory is allocated as big as BULK_IO_PAGE_COUNT * 8192 when server restarts or data file is created. If the session's PRIVATE_STATIC_AREA_SIZE is smaller than the heap memory size, an error of insufficient memory may occur. In this case, extend PRIVATE_STATIC_AREA_SIZE.
CDISPATCHER_HOT_POLICY_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | CDISPATCHER_HOT_POLICY_INTERVAL |
Summary | cdispatcher dequeue interval for busy waiting ( micro second ) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 86400000000 (1day) |
Default value | 0 |
Description
It is the time of the busy waiting when performing the dequeue in the cdispatcher. It is a micro second unit. If this value is big, it uses more cpu but the user response time (latency) is decreased. The default value is 0, and the busy waiting is not allowed.
CDISPATCHER_LOCKABLE_THREADS
Basic Information
Item | Description |
|---|---|
Name | CDISPATCHER_LOCKABLE_THREADS |
Summary | cdispatcher lockable sender, receiver thread count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 30 |
Default value | 1 |
Description
It sets the number of cdispatcher threads of lockble data sender and receiver. However, the number of cdispatcher threads of lockless data sender and receiver is set by using CDISPATCHER_LOCKLESS_THREADS.
ALIAS
Item | Description |
|---|---|
Original name | CDISPATCHER_LOCKABLE_THREADS |
ALIAS | CDISPATCHER_THREADS |
CDISPATCHER_LOCKLESS_THREADS
Basic Information
Item | Description |
|---|---|
Name | CDISPATCHER_LOCKLESS_THREADS |
Summary | cdispatcher lockless sender, receiver thread count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 30 |
Default value | 1 |
Description
It sets the number of cdispatcher threads of lockless data sender and receiver. However, the number of cdispatcher threads of lockable data sender and receiver is set by using CDISPATCHER_LOCKABLE_THREADS.
CDISPATCHER_MAX_PACKET_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | CDISPATCHER_MAX_PACKET_BUFFER_SIZE |
Summary | maximum packet buffer size for cdipatcher sender and receiver threads |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 10 Mega |
MAX | 32 Giga |
Default value | 1 Giga |
Description
It sets the maximum size of the buffer where the data sender and receiver of cdispatcher stores the sent/ received packets.
CDISPATCHER_SOCKET_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | CDISPATCHER_SOCKET_BUFFER_SIZE |
Summary | cdispatcher socket buffer(sender, receiver) size |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 64 |
MAX | 100 Mega |
Default value | 32768 |
Description
It is the socket buffer(sender, receiver) size of cdispatcher.
CDISPATCHER_SYNC_THREADS
Basic Information
Item | Description |
|---|---|
Name | CDISPATCHER_SYNC_THREADS |
Summary | cdispatcher sync thread count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 30 |
Default value | 1 |
Description
It is the thread count of cdispatcher sync.
CHANGE_TRACKING
Basic Information
Item | Description |
|---|---|
Name | CHANGE_TRACKING |
Summary | enable change tracking for incremental backup |
Data type | BOOLEAN |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to track the updated pages to perform the incremental backup of disk tablespace.
NO: disable change tracking
YES: enable change tracking
change tracking can be enabled by using ALTER DATABASE { ENABLE | DISABLE } CHANGE TRACKING on mount or above phase only when the database is operated in archivelog.CHANGE_TRACKING_EXTENT_SIZE
Basic Information
Item | Description |
|---|---|
Name | CHANGE_TRACKING_EXTENT_SIZE |
Summary | number of pages to track changed of incremental backup |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 16 |
MAX | 128 |
Default value | 32 |
Description
It sets the number of pages to display with one dirty flag when change tracking. For example, if it is set to 32, then one dirty flag is used per 32 pages, and if it is set to 128, then then one dirty flag is used per 128 pages.
CHANGE_TRACKING_FILE
Basic Information
Item | Description |
|---|---|
Name | CHANGE_TRACKING_FILE |
Summary | default change tracking file |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/backup/gl_change_tracking_file.ctf |
Description
It sets the file directory which stores the change tracking, and the file name.
CHAR_LENGTH_UNITS
Basic Information
Item | Description |
|---|---|
Name | CHAR_LENGTH_UNITS |
Summary | char length units |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | OCTETS |
Description
It is the value of char length units used when defining character string such as CHAR, VARCHAR and omitting char length unit as follows.
CREATE TABLE t1 ( id CHAR( 10 OCTETS ), name VARCHAR( 128 CHARACTERS ), addr VARCHAR( 128 ) );
id CHAR( 10 OCTETS ) means 10 bytes.
name VARCHAR( 128 CHARACTERS ) means 128 characters.
addr VARCHAR( 128 ) means that this value is referenced when char length unit is omitted.
When database is created, the property is set to either OCTETS or CHARACTERS. OCTETS is the number of bytes, and CHARACTERS is the number of characters.
The SQL standard defines CHARACTERS as default value. Other DBMS defines the default value of char length unit as follows.
Oracle and DB2 define OCTETS as default value.
MS-SQL, MySQL, PostgreSQL define CHARACTERS as default value.
CHARACTER_SET
Basic Information
Item | Description |
|---|---|
Name | CHARACTER_SET |
Summary | character set |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | UTF8 |
Description
It is a character set of database, and it is applied when database is created. The property is set to one of the following values.
Character set | Description |
|---|---|
SQL_ASCII | ASCII standards |
UTF8 | Unicode, 8-bit |
UHC | Unified Hangul code |
GB18030 | Chinese government standards |
CHECK_DEDICATE_CONNECTION_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | CHECK_DEDICATE_CONNECTION_INTERVAL |
Summary | check dedicate socket |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 100000 |
Default value | 1000 |
Description
It is the interval of checking for when the client forcibly cut the connection in C/S dedicate environment. The dedicate server(gserver) checks the socket, and it terminates it if it was cut. The default value is 1,000 millisecond (1 second).
CHECKPOINT_LIST_COUNT_PER_IO_GROUP
Basic Information
Item | Description |
|---|---|
Name | CHECKPOINT_LIST_COUNT_PER_IO_GROUP |
Summary | number of checkpoint lists per each io group |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 8192 |
Default value | 0 |
Description
It sets the number of checkpoint lists to be processed by each IO slave set by PARALLEL_IO_FACTOR. It specifies the appropriate value to efficiently process the concurrency when connecting the updated pages to the checkpoint lists. The default value is 0, and in this case, each IO slave creates the checkpoint lists as many as the number of CPU and processes it.
CLIENT_MAX_COUNT
Basic Information
Item | Description |
|---|---|
Name | CLIENT_MAX_COUNT |
Summary | maximum session count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 12 |
MAX | 65535 |
Default value | 128 |
Description
It sets the maximum number of sessions to connect.
CLIENT_NUMA_POLICY
Basic Information
Item | Description |
|---|---|
Name | CLIENT_NUMA_POLICY |
Summary | client numa policy( 0: by modualar, 1: by statistics , 2: by manunal ) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 2 |
Default value | 0 |
Description
It determines the policy to distribute client processes to NUMA nodes. This property is operated when NUMA property is set to on.
0: It determines the NUMA node to be connected by modularizing the session ID.
1: It connects to the NUMA node of which is the least connected based on the statistics information.
2: C/S client is determined by TCP_CLIENT_NUMA_NODE property, D/A client is determined by DA_CLIENT_ NUMA_NODE property.
CLOSE_PSM_CHILD_STMTS
Basic Information
Item | Description |
|---|---|
Name | CLOSE_PSM_CHILD_STMTS |
Summary | close child statements of PSM at the end of each execution |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It closes the child statement of PSM at the end of each execution.
CLUSTER_ASYNC_COMMIT
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_ASYNC_COMMIT |
Summary | enable asynchronous commit in cluster system |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
It determines whether to internally process the commit protocol on an async mode in cluster system.
If this property is set to on, it asynchronously commits each node, so the temporary inconsistency among nodes may occur. On the other hand, if it is set to off, it synchronizes everytime it commits, so it may reduce the performance. Therefore, it is required to determine the appropriate property depending on the purpose.
CLUSTER_CM_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_CM_BUFFER_SIZE |
Summary | communication buffer size for cluster |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 10 Mega |
MAX | 32 Giga |
Default value | 10 Mega |
Description
It is the communication buffer size for cluster.
CLUSTER_CM_READ_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_CM_READ_BUFFER_SIZE |
Summary | communication read block size |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 8192 |
MAX | 10485,760 |
Default value | 65536 |
Description
It is the communication read block size.
CLUSTER_COMMIT_SLAVE_CSERVERS
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_COMMIT_SLAVE_CSERVERS |
Summary | number of commit slave cservers |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 8 |
Default value | 0 |
Description
It is the number of commit slaves.
ALIAS
Item | Description |
|---|---|
Original name | CLUSTER_COMMIT_SLAVE_CSERVERS |
ALIAS | CLUSTER_COMMIT_SLAVES |
CLUSTER_COMMIT_STREAM_ISOLATION
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_COMMIT_STREAM_ISOLATION |
Summary | isolate cluster dispatcher stream for commit protocol |
Data type | BOOLEAN |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
It determines whether to internally perform the commit process flow in the cluster system separately from other protocol process. The performance may be improved when seperating the commit process according to the system environment.
CLUSTER_CONNECTION
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_CONNECTION |
Summary | connection mode for cluster ( socket:0, rdma:1 ) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | 0: socket |
Description
It is the connection mode for cluster. ( socket:0, rdma:1 )
CLUSTER_CONNECTION_TIMEOUT_SEC
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_CONNECTION_TIMEOUT_SEC |
Summary | connection timeout for cluster |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 86400 |
Default value | 10 |
Description
It is the connection timeout for cluster.
CLUSTER_DATA_SYNC_SERVERS
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_DATA_SYNC_SERVERS |
Summary | count of data synchronization server |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 128 |
Default value | 3 |
Description
It is the count of data synchronization server.
CLUSTER_DEADLOCK_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_DEADLOCK_TIMEOUT |
Summary | a time limit (sec) for resolving cluster deadlock |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 3600 (1 hour) |
Default value | 3600 (1 hour) |
Description
If the competition to occupy the cluster server becomes keen due to the lack of the lockable cluster server, then the cluster deadlock may occur. When cluster deadlock occurs, it waits for the deadlock to be resolved as long as the time set in this property. However, if it is not resolved, then CLUSTER_DEADLOCK_TIMEOUT error occurs.
CLUSTER_DISPATCHER_IN_QUEUE_SIZE
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_DISPATCHER_IN_QUEUE_SIZE |
Summary | in-queue size for cluster dispatcher |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1024 |
MAX | 32768 |
Default value | 1024 |
Description
It is the in-queue size for cluster dispatcher.
CLUSTER_DISPATCHER_NUMA_STREAM_MAP
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_DISPATCHER_NUMA_STREAM_MAP |
Summary | numa stream map for cluster dispatcher |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | 'x' : no binding |
Description
It determines a NUMA node to which the cluster dispatcher is to be connected. This property is operated when NUMA property is set to on.
If CLUSTER_COMMIT_STREAM_ISOLATION property is set to on, then the 0 stream is set to NUMA node of a commit stream.
The following is an example of three dispatchers. It connects number 0 stream to number 0 NUMA node, connects number 1 stream to number 1 NUMA node, and number 2 stream to number 2 NUMA node.
CLUSTER_DISPATCHER_NUMA_STREAM_MAP = '0:1:2'
CLUSTER_DISPATCHER_OUT_QUEUE_SIZE
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_DISPATCHER_OUT_QUEUE_SIZE |
Summary | out-queue size for cluster dispatcher |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1024 |
MAX | 32768 |
Default value | 1024 |
Description
It is the out-queue size for cluster dispatcher.
CLUSTER_GSERVER_RESPONSE_QUEUE_SIZE
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_GSERVER_RESPONSE_QUEUE_SIZE |
Summary | response queue size for cluster server |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 30 |
MAX | 32768 |
Default value | 30 |
Description
It sets the maximum queue size to receive the response from the remote server.
ALIAS
Item | Description |
|---|---|
Original name | CLUSTER_GSERVER_RESPONSE_QUEUE_SIZE |
ALIAS | CLUSTER_SERVER_RESPONSE_QUEUE_SIZE |
CLUSTER_HEARTBEAT_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_HEARTBEAT_INTERVAL |
Summary | interval seconds for health checking of cluster |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 86400 |
Default value | 3 |
Description
It is the interval seconds for health checking of cluster. 0 means that it is disabled.
CLUSTER_HEARTBEAT_RETRY_COUNT
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_HEARTBEAT_RETRY_COUNT |
Summary | retry count for health checking of cluster |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 65536 |
Default value | 5 |
Description
It is the retry count for health checking of cluster.
CLUSTER_IGNORE_INACTIVE_MEMBER
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_IGNORE_INACTIVE_MEMBER |
Summary | ignore in-active member for cluster |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It ignores in-active member for cluster.
CLUSTER_KEEPALIVE_IDLE_TIME
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_KEEPALIVE_IDLE_TIME |
Summary | The number of seconds a cluster connection needs to be idle |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 16383 |
Default value | 0 |
Description
It is the idle time which is the duration without sending or receiving TCP packets between a cluster session and a cdispatcher before sending a keep alive packet. In other words, if TCP packets are not exchanged during the seconds set in CLUSTER_KEEPALIVE_IDLE_TIME, then the keep alive mechanism is performed on cdispatcher side to detect the dead connection.
The default value is 0, in which case the keep alive feature is disabled.
CLUSTER_LOCKABLE_CSERVERS
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_LOCKABLE_CSERVERS |
Summary | number of lockable cserver processes |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 2048 |
Default value | 5 |
Description
It sets the number of cluster server processes performing the operation which acquires lock. However, the number of cluster server processes performing the operation which does not acquire lock is set by using CLUSTER_LOCKLESS_CSERVERS.
ALIAS
Item | Description |
|---|---|
Original name | CLUSTER_LOCKABLE_CSERVERS |
ALIAS | CSERVERS |
CLUSTER_LOCKLESS_CSERVERS
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_LOCKLESS_CSERVERS |
Summary | number of lockless cserver processes |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 2048 |
Default value | 5 |
Description
It sets the number of cluster server processes performing the operation which does not acquire lock. However, the number of cluster server processes performing the operation which acquires lock is set by using CLUSTER_LOCKABLE_CSERVERS.
ALIAS
Item | Description |
|---|---|
Original name | CLUSTER_LOCKLESS_CSERVERS |
ALIAS | LOCKLESS_CSERVERS |
CLUSTER_MAX_PACKET_SIZE
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_MAX_PACKET_SIZE |
Summary | maximum packet size for cluster session |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 10 Mega |
MAX | 32 Giga |
Default value | 100 Mega |
Description
It sets the maximum packet size of which the remote protocol can transfer at a time. If the column size to be remotely transferred exceeds the property size, then the property size should be set bigger than the column size.
CLUSTER_MAX_PAYLOAD_SIZE
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_MAX_PAYLOAD_SIZE |
Summary | maximum packet payload size for cluster session (byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 524288 |
MAX | 33554432 |
Default value | 524288 |
Description
The cluster packet which is remotely transferred may be delivered in pieces, and this property sets the maximum size of data to be stored in a piece.
CLUSTER_PACKET_ALLOCATION_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_PACKET_ALLOCATION_TIMEOUT |
Summary | a time limit (sec) for how long statemets will wait to allocate packet memory |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 100000000 |
Default value | 3 |
Description
It sets the maximum time (second) of waiting when allocating memory required for cluster packet configuration.
CLUSTER_PROTOCOL_FAILOVER_POLICY_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_PROTOCOL_FAILOVER_POLICY_TIMEOUT |
Summary | a time limit of failover policy to wait for a response from the cluster protocol |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 100000000 |
Default value | 0 |
Description
It is the maximum time of when waiting for the response after transferring the protocol in cluster. If it does not responds within the specified time, then GOLDILOCKS, depending on the protocol, may terminate the protocol or make the remote cluster member which does not responds to be failover. Specify the time limit by using CLUSTER_PROTOCOL_FAILOVER_POLICY_TIMEOUT property to use the failover policy. However, specify the time limit by using CLUSTER_PROTOCOL_SESSION_FATAL_POLICY_TIMEOUT property to use the policy terminating the session.
CLUSTER_PROTOCOL_SESSION_FATAL_POLICY_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_PROTOCOL_SESSION_FATAL_POLICY_TIMEOUT |
Summary | a time limit of session fatal policy to wait for a response from the cluster protocol |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 100000000 |
Default value | 0 |
Description
It is the maximum time of when waiting for the response after transferring the protocol in cluster. If it does not responds within the specified time, then GOLDILOCKS, depending on the protocol, may terminate the protocol or make the remote cluster member which does not responds to be failover. Specify the time limit by using CLUSTER_PROTOCOL_SESSION_FATAL_POLICY_TIMEOUT property to use the policy terminating the session. However, specify the time limit by using CLUSTER_PROTOCOL_FAILOVER_POLICY_TIMEOUT property to use the failover policy.
CLUSTER_SESSION_HASH_BUCKETS
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_SESSION_HASH_BUCKETS |
Summary | Number of hash buckets for cluster sessions |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 127 |
MAX | 1073741824 |
Default value | 127 |
Description
It sets the number of hash buckets to control the cluster session.
CLUSTER_SPLIT_BRAIN_RESOLUTION_POLICY
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_SPLIT_BRAIN_RESOLUTION_POLICY |
Summary | split brain resolution policy for cluster system |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 2 |
Default value | 0 |
Description
It sets the policy to resolve split-brain situation in the cluster system. If the value is set to 1 or over, it enquires the solution of a locator.
If the query for a locator is timed out, it tries to enquire as many times as CLUSTER_SPLIT_BRAIN_RETRY_COUNT. If the property value after the retry failure is 1, then it forcibly proceeds the failover. If it is 2, then it terminates the fatal.
CLUSTER_SPLIT_BRAIN_RETRY_COUNT
Basic Information
Item | Description |
|---|---|
Name | CLUSTER_SPLIT_BRAIN_RETRY_COUNT |
Summary | retry count for split brain resolution policy(1 ~ 65536) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 65536 |
Default value | 1 |
Description
It is used when CLUSTER_SPLIT_BRAIN_RESOLUTION_POLICY is set to 1 or over in cluster system. It sets the times of retrying to enquire when the query to a locator does not respond.
COMMITTER_HOT_POLICY_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | COMMITTER_HOT_POLICY_INTERVAL |
Summary | committer deque interval for busy waiting |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 86400000000 (1 day) |
Default value | 0 (cold policy) |
Description
It sets the timezone interval of busy waiting when the commit cserver is dequeing to read the commit protocol message. If it is set to 1,000,000 (1 second), and the time is not passed over 1 second from the last deque success to another deque retry, then it sets the timeout in deque to 0 and performs the busy waiting.
CONTROL_FILE_0 ~ CONTROL_FILE_7
Basic Information
Item | Description |
|---|---|
Name | CONTROL_FILE_0 |
Summary | control file name |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/wal/control_0.ctl |
Description
If a control file is corrupted, database can not be used. Therefore, the control file is multiplexed for stability of database. It specifies the directory and file name of which stores each control file.
CONTROL_FILE_COUNT
Basic Information
Item | Description |
|---|---|
Name | CONTROL_FILE_COUNT |
Summary | control file count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 2 |
MAX | 8 |
Default value | 2 |
Description
If a control file is corruped, database can not be used. The control file is multiplexed for stability of database. CONTROL_FILE_COUNT specifies the multiplexing number of control files. A control file is multiplexed at least 2 up to 8.
CONTROL_FILE_TEMP_NAME
Basic Information
Item | Description |
|---|---|
Name | CONTROL_FILE_TEMP_NAME |
Summary | temporary file name for control file |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/backup/control.tmp |
Description
During database operation, a control file is frequently changed, and its temporary copy can be made if necessary. CONTROL_FILE_TEMP_NAME specifies the directory and its file name to temporarily store the control file.
COORDINATOR_COMMIT_WRITE_MODE
Basic Information
Item | Description |
|---|---|
Name | COORDINATOR_COMMIT_WRITE_MODE |
Summary | coordinator commit write mode(0:disable, 1:wait mode) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
It is a commit write mode applied to a coordinator. If TRANSACTION_COMMIT_WRITE_MODE is no wait, and its property is wait, then the coordinator node is operated as wait, and other nodes are operated as no wait.
DA_CLIENT_NUMA_NODE
Basic Information
Item | Description |
|---|---|
Name | DA_CLIENT_NUMA_NODE |
Summary | numa node for DA clients |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | -1 |
MAX | 63 |
Default value | -1 |
Description
It sets the NUMA node ID to which the direct access (D/A) session is to be bound. This property is operated when NUMA property is set to ON.
DATA_STORE_MODE
Basic Information
Item | Description |
|---|---|
Name | DATA_STORE_MODE |
Summary | data store mode(cds:1,tds:2) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 2 |
Default value | 2 |
Description
It sets the storing method of database.
1: CDS mode supports the concurrency for multiple users but it does not guarantee the durability. It does not record logs for all update operations such as insert/ delete/ update data, consequentially a failure can not be recovered.
2: TDS mode guarantees the concurrency for multiple users and the durability using logs.
DATABASE_INSTANCE_NAME
Basic Information
Item | Description |
|---|---|
Name | DATABASE_INSTANCE_NAME |
Summary | database instance name |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | GOLDILOCKS |
Description
It is the database instance name.
DDL_AUTOCOMMIT
Basic Information
Item | Description |
|---|---|
Name | DDL_AUTOCOMMIT |
Summary | DDL auto commit |
Data type | BOOL |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to autocommit DDL operations which are not autocommitted yet. For example, autocommit is not applied to the operations such as creating/altering a table, so if DDL_AUTOCOMMIT is 0, a table creation and alteration can be undone by the rollback. On the other hand, if DDL_AUTOCOMMIT is 1, DDL to which autocommit is not applied is committed immediately.
DDL_LOCK_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | DDL_LOCK_TIMEOUT |
Summary | a time limit (sec) for how long DDL statemets will wait |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 100000000 |
Default value | 0 |
Description
It means the lock wait time when DDL operations occur to the same object at the same time. The default value is 0 second, and it does not wait for a lock when the DDL operation occurs.
When operations of altering a table structure simultaneously occur, they wait for the time specified in DDL_LOCK_TIMEOUT, without waiting for other transactions termination as follows.
• Transaction A
ALTER TABLE t1 ADD COLUMN ( new_column NUMBER );
• Transaction B
TRUNCATE TABLE t1;
If the waiting time exceeds DDL_LOCK_TIMEOUT, an error occurs as follows.
gSQL> TRUNCATE TABLE t1; ERR-HYT00(14026): resource busy or timeout expired
DEADLOCK_PRIORITY
Basic Information
Item | Description |
|---|---|
Name | DEADLOCK_PRIORITY |
Summary | importance to choose deadlock victim |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 9 |
Default value | 5 |
Description
When a deadlock occurs while simultaneously processing multiple transactions, a specific transaction with the low weight is selected as a victim among transactions which caused the deadlock, to solve the problem. If a deadlock occurs between a transaction started in sessions which have higher value for this property and a transaction started in sessions which have lower value for this property, then latter is selected as a deadlock victim. Therefore, set this property according to the priority of each transaction.
Start the transaction after setting this property value so that this value is applied as a weight of that transaction. The transaction weight is not altered if this value is changed after the transaction already has been started.
DEFAULT_GLOBAL_SECONDARY_INDEX_CREATION
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_GLOBAL_SECONDARY_INDEX_CREATION |
Summary | specifies whether or not create global secondary index at table creation |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
It sets whether to create the global secondary index when creating a table in cluster system. A non-deterministic query for the table which did not created the global secondary index fails. The global secondary index can be separately created after creating the table when the property is set to NO.
DEFAULT_INDEX_LOGGING
It is not supported after 3.2.
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_INDEX_LOGGING |
Summary | default logging flag of indexes |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
If LOGGING property is not explicitly set by a user when an index is created, then it is set to DEFAULT_INDEX_LOGGING value. If an index is created in LOGGING tablespace, the LOGGING property should be set.
DEFAULT_INDEX_PCTFREE
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_INDEX_PCTFREE |
Summary | default pctfree value of indexes ( % ) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 99 |
Default value | 10 |
Description
If a user does not explicitly specify PCTFREE syntax when creating an index. The PCTFREE is set to DEFAULT_INDEX_PCTFREE property value.
DEFAULT_INITRANS
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_INITRANS |
Summary | default initrans value of tables |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 32 |
Default value | 4 |
Description
If a user does not explicitly set INITRANS syntax when creating a table or an index, then it is set to DEFAULT_INITRANS property value.
DEFAULT_MAXTRANS
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_MAXTRANS |
Summary | default maxtrans value of tables |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 32 |
Default value | 32 |
Description
If a user does not explicitly set the MAXTRANS syntax when creating a table or an index, then it is set to DEFAULT_MAXTRANS property value.
DEFAULT_PCTFREE
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_PCTFREE |
Summary | default pctfree value of tables ( % ) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 99 |
Default value | 10 |
Description
If a user does not explicitly set the PCTFREE property when creating a table, it is set to DEFAULT_PCTFREE property value.
DEFAULT_PCTUSED
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_PCTUSED |
Summary | default pctused value of tables ( % ) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 99 |
Default value | 60 |
Description
If a user does not explicitly set the PCTUSED property when creating a table, it is set to DEFAULT_PCTUSED value.
DEFAULT_REMOVAL_BACKUP_FILE
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_REMOVAL_BACKUP_FILE |
Summary | default removal flag of incremental backup files |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It specifies whether to delete the backup file when deleting the backup list.
DEFAULT_REMOVAL_OBSOLETE_BACKUP_LIST
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_REMOVAL_OBSOLETE_BACKUP_LIST |
Summary | default removal flag of obsolete incremental backup lists |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It specifies whether to delete the previous obsoleted backup list when executing INCREMENTAL BACKUP.
DEFAULT_SHARDING
Basic Information
Item | Description |
|---|---|
Name | DEFAULT_SHARDING |
Summary | default sharding strategy (0: cloned, 1: hash sharding) |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets the default sharding strategy to be used if the sharding strategy is not determined when creating a table.
The following is an example of executing CREATE TABLE statement.
CREATE TABLE t1
(
id INTEGER,
name VARCHAR(128)
);If DEFAULT_SHARDING value is 0 (cloned), the table is created as a cloned table as follows.
CREATE TABLE t1
(
id INTEGER,
name VARCHAR(128)
)
CLONED
AT CLUSTER WIDE
;If DEFAULT_SHARDING value is 1 (hash sharding), the table is created as a hash-sharded table as follows.
CREATE TABLE t1
(
id INTEGER,
name VARCHAR(128)
)
SHARDING BY HASH (id)
SHARD COUNT 24
AT CLUSTER WIDE
;If DEFAULT_SHARDING is 1 (hash sharding) and <table sharding strategy> is not described, then the hash sharding key is determined based on the following order.
If PRIMARY KEY constraint is defined, primary key is used as a sharding key.
• The original message
CREATE TABLE t1 ( id INTEGER PRIMARY KEY, name VARCHAR(128) );
• Translation
CREATE TABLE t1 ( id INTEGER PRIMARY KEY, name VARCHAR(128) )
SHARDING BY HASH(id)
SHARD COUNT 24
AT CLUSTER WIDE;If UNIQUE constraint is defined, the firstly described UNIQUE constraint is used as the sharding key.
• The original message
CREATE TABLE t1 ( id INTEGER, name VARCHAR(128) UNIQUE );
• Translation
CREATE TABLE t1 ( id INTEGER, name VARCHAR(128) UNIQUE )
SHARDING BY HASH(name)
SHARD COUNT 24
AT CLUSTER WIDE;If key constraint is not defined, the first column except for the following excluded data type is used as a sharding key.
The excluded data type: LONG VARCHAR, LONG VARBINARY, BOOLEAN
• The original message
CREATE TABLE t1 ( is_man BOOLEAN, id INTEGER, name VARCHAR(128) );
• Translation
CREATE TABLE t1 ( is_man BOOLEAN, id INTEGER, name VARCHAR(128) )
SHARDING BY HASH(id)
SHARD COUNT 24
AT CLUSTER WIDE;DISABLE_DDL
Basic Information
Item | Description |
|---|---|
Name | DISABLE_DDL |
Summary | disable All DDL |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It prevents all DDL execution.
The SQL statements which are affected by DISABLE_DDL are queried as follows.
gSQL>
SELECT command
FROM v$sql_command
WHERE is_ddl = 'YES'
ORDER BY 1
;
COMMAND
---------------------------------------------------------
ALTER AUDIT POLICY
ALTER CLUSTER GROUP .. ADD CLUSTER MEMBER
ALTER CLUSTER GROUP .. OFFLINE CLUSTER MEMBER
ALTER DATABASE ADD LOGFILE GROUP
ALTER DATABASE ADD LOGFILE MEMBER
ALTER DATABASE ARCHIVELOG
ALTER DATABASE CLEAR PASSWORD HISTORY
ALTER DATABASE DATAFILE AUTOEXTEND ..
ALTER DATABASE DROP INACTIVE CLUSTER MEMBERS
ALTER DATABASE DROP LOGFILE GROUP
ALTER DATABASE DROP LOGFILE MEMBER
ALTER DATABASE NOARCHIVELOG
ALTER DATABASE OFFLINE INACTIVE CLUSTER MEMBERS
ALTER DATABASE RENAME GLOBAL TRANSACTION LOGFILE
ALTER DATABASE RENAME LOGFILE
ALTER DATABASE RESET LOCAL CLUSTER MEMBER
ALTER FUNCTION
ALTER INDEX .. REBUILD
ALTER INDEX .. RENAME
ALTER INDEX .. STORAGE
ALTER INDEX AGING
ALTER PACKAGE
ALTER PROCEDURE
ALTER PROFILE
ALTER SEQUENCE
ALTER SEQUENCE .. SYNCHRONIZE
ALTER SYSTEM SWITCH LOGFILE
ALTER TABLE .. ADD COLUMN
ALTER TABLE .. ADD CONSTRAINT
ALTER TABLE .. ADD GLOBAL SECONDARY INDEX
ALTER TABLE .. ADD SUPPLEMENTAL LOG
ALTER TABLE .. ALTER COLUMN .. AS IDENTITY
ALTER TABLE .. ALTER COLUMN .. DROP DEFAULT
ALTER TABLE .. ALTER COLUMN .. DROP IDENTITY
ALTER TABLE .. ALTER COLUMN .. DROP NOT NULL
ALTER TABLE .. ALTER COLUMN .. SET DATA TYPE
ALTER TABLE .. ALTER COLUMN .. SET DEFAULT
ALTER TABLE .. ALTER COLUMN .. SET NOT NULL
ALTER TABLE .. ALTER CONSTRAINT
ALTER TABLE .. ALTER GLOBAL SECONDARY INDEX
ALTER TABLE .. ALTER GLOBAL SECONDARY INDEX AGING
ALTER TABLE .. DROP CONSTRAINT
ALTER TABLE .. DROP GLOBAL SECONDARY INDEX
ALTER TABLE .. DROP OFFLINE SEGMENTS
ALTER TABLE .. DROP SUPPLEMENTAL LOG
ALTER TABLE .. MERGE SHARDS .. INTO ..
ALTER TABLE .. MOVE SHARD .. TO CLUSTER GROUP ..
ALTER TABLE .. READ ONLY
ALTER TABLE .. READ WRITE
ALTER TABLE .. REBALANCE ..
ALTER TABLE .. REBUILD GLOBAL SECONDARY INDEX
ALTER TABLE .. RENAME COLUMN
ALTER TABLE .. RENAME CONSTRAINT
ALTER TABLE .. RENAME SHARD .. TO ..
ALTER TABLE .. RENAME TO ..
ALTER TABLE .. SET UNUSED COLUMN
ALTER TABLE .. SPLIT SHARD .. INTO .. AT CLUSTER GROUP ..
ALTER TABLE .. STORAGE
ALTER TABLE .. SYNCHRONIZE ..
ALTER TABLE .. SYNCHRONIZE IDENTITY COLUMN
ALTER TABLESPACE .. ADD
ALTER TABLESPACE .. DROP
ALTER TABLESPACE .. OFFLINE
ALTER TABLESPACE .. ONLINE
ALTER TABLESPACE .. RENAME TO
ALTER TABLESPACE .. RENAME { DATAFILE | MEMORY }
ALTER USER
ALTER USER .. IDENTIFIED BY
ALTER VIEW
ANALYZE SYSTEM COMPUTE STATISTICS
ANALYZE SYSTEM DELETE STATISTICS
ANALYZE TABLE .. DELETE STATISTICS
ANALYZE TABLE .. [COMPUTE|ESTIMATE] STATISTICS
AUDIT POLICY
COMMENT ON .. IS
CREATE AUDIT POLICY
CREATE CLUSTER GROUP
CREATE FUNCTION
CREATE INDEX
CREATE PACKAGE
CREATE PACKAGE BODY
CREATE PROCEDURE
CREATE PROFILE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SYNONYM
CREATE TABLE
CREATE TABLE ... AS SELECT
CREATE TABLESPACE
CREATE USER
CREATE VIEW
DROP AUDIT POLICY
DROP CLUSTER GROUP
DROP FUNCTION
DROP INDEX
DROP PACKAGE
DROP PROCEDURE
DROP PROFILE
DROP SCHEMA
DROP SEQUENCE
DROP SYNONYM
DROP TABLE
DROP TABLESPACE
DROP USER
DROP VIEW
FLASHBACK TABLE
GRANT .. ON DATABASE
GRANT .. ON PACKAGE
GRANT .. ON PROCEDURE
GRANT .. ON SCHEMA
GRANT .. ON TABLE
GRANT .. ON TABLESPACE
GRANT USAGE ON ..
NOAUDIT POLICY
PURGE CONSTRAINT
PURGE DBA_RECYCLEBIN
PURGE INDEX
PURGE RECYCLEBIN
PURGE TABLE
PURGE TABLESPACE
REVOKE .. ON DATABASE
REVOKE .. ON PACKAGE
REVOKE .. ON PROCEDURE
REVOKE .. ON SCHEMA
REVOKE .. ON TABLE
REVOKE .. ON TABLESPACE
REVOKE USAGE ON ..
TRUNCATE TABLE
128 rows selected.DISABLE_DDL_CDC_GIVEUP
Basic Information
Item | Description |
|---|---|
Name | DISABLE_DDL_CDC_GIVEUP |
Summary | disable DDL which causing CDC give-up |
Data type | BOOLEAN |
Applicable phase | OPEN |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | TRUE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It prohibits DDL operation on the table of supplemental log, because it affects CDC's give up. For more information, refer to The occurrence of give up and whether to allow DDL statement according to DDL category.
DISABLE_SERIAL_DDL
Basic Information
Item | Description |
|---|---|
Name | DISABLE_SERIAL_DDL |
Summary | disable Serial DDL |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
DDL is executed for all cluster members after sequentially acquiring locks in cluster environment as described in Processing DDL in Cluster. The DDL which is performed in the serial lock method is called as the serial DDL.
DDL statements which are affected by DISABLE_SERIAL_DDL are queried as follows, and most of schema DDLs are affected.
gSQL>
SELECT command
, is_ddl
, cluster_lock_mode
FROM v$sql_command
WHERE is_ddl = 'YES'
AND cluster_lock_mode = 'SERIAL'
ORDER BY 1
;
SELECT command
, is_ddl
, cluster_lock_mode
FROM v$sql_command
WHERE is_ddl = 'YES'
AND cluster_lock_mode = 'SERIAL'
ORDER BY 1
;
COMMAND IS_DDL CLUSTER_LOCK_MODE
------------------------------------------------- ------ -----------------
ALTER AUDIT POLICY YES SERIAL
ALTER DATABASE CLEAR PASSWORD HISTORY YES SERIAL
ALTER DATABASE DATAFILE AUTOEXTEND .. YES SERIAL
ALTER FUNCTION YES SERIAL
ALTER INDEX .. RENAME YES SERIAL
ALTER INDEX .. STORAGE YES SERIAL
ALTER INDEX AGING YES SERIAL
ALTER PACKAGE YES SERIAL
ALTER PROCEDURE YES SERIAL
ALTER PROFILE YES SERIAL
ALTER SEQUENCE YES SERIAL
ALTER TABLE .. ADD COLUMN YES SERIAL
ALTER TABLE .. ADD CONSTRAINT YES SERIAL
ALTER TABLE .. ADD GLOBAL SECONDARY INDEX YES SERIAL
ALTER TABLE .. ADD SUPPLEMENTAL LOG YES SERIAL
ALTER TABLE .. ALTER COLUMN .. AS IDENTITY YES SERIAL
ALTER TABLE .. ALTER COLUMN .. DROP DEFAULT YES SERIAL
ALTER TABLE .. ALTER COLUMN .. DROP IDENTITY YES SERIAL
ALTER TABLE .. ALTER COLUMN .. DROP NOT NULL YES SERIAL
ALTER TABLE .. ALTER COLUMN .. SET DATA TYPE YES SERIAL
ALTER TABLE .. ALTER COLUMN .. SET DEFAULT YES SERIAL
ALTER TABLE .. ALTER COLUMN .. SET NOT NULL YES SERIAL
ALTER TABLE .. ALTER CONSTRAINT YES SERIAL
ALTER TABLE .. ALTER GLOBAL SECONDARY INDEX YES SERIAL
ALTER TABLE .. ALTER GLOBAL SECONDARY INDEX AGING YES SERIAL
ALTER TABLE .. DROP CONSTRAINT YES SERIAL
ALTER TABLE .. DROP GLOBAL SECONDARY INDEX YES SERIAL
ALTER TABLE .. DROP OFFLINE SEGMENTS YES SERIAL
ALTER TABLE .. DROP SUPPLEMENTAL LOG YES SERIAL
ALTER TABLE .. READ ONLY YES SERIAL
ALTER TABLE .. READ WRITE YES SERIAL
ALTER TABLE .. RENAME COLUMN YES SERIAL
ALTER TABLE .. RENAME CONSTRAINT YES SERIAL
ALTER TABLE .. RENAME SHARD .. TO .. YES SERIAL
ALTER TABLE .. RENAME TO .. YES SERIAL
ALTER TABLE .. SET UNUSED COLUMN YES SERIAL
ALTER TABLE .. STORAGE YES SERIAL
ALTER TABLESPACE .. ADD YES SERIAL
ALTER TABLESPACE .. DROP YES SERIAL
ALTER TABLESPACE .. OFFLINE YES SERIAL
ALTER TABLESPACE .. ONLINE YES SERIAL
ALTER TABLESPACE .. RENAME TO YES SERIAL
ALTER TABLESPACE .. RENAME { DATAFILE | MEMORY } YES SERIAL
ALTER USER YES SERIAL
ALTER USER .. IDENTIFIED BY YES SERIAL
ALTER VIEW YES SERIAL
ANALYZE SYSTEM COMPUTE STATISTICS YES SERIAL
ANALYZE SYSTEM DELETE STATISTICS YES SERIAL
ANALYZE TABLE .. DELETE STATISTICS YES SERIAL
ANALYZE TABLE .. [COMPUTE|ESTIMATE] STATISTICS YES SERIAL
AUDIT POLICY YES SERIAL
COMMENT ON .. IS YES SERIAL
CREATE AUDIT POLICY YES SERIAL
CREATE FUNCTION YES SERIAL
CREATE INDEX YES SERIAL
CREATE PACKAGE YES SERIAL
CREATE PACKAGE BODY YES SERIAL
CREATE PROCEDURE YES SERIAL
CREATE PROFILE YES SERIAL
CREATE SCHEMA YES SERIAL
CREATE SEQUENCE YES SERIAL
CREATE SYNONYM YES SERIAL
CREATE TABLE YES SERIAL
CREATE TABLE ... AS SELECT YES SERIAL
CREATE TABLESPACE YES SERIAL
CREATE USER YES SERIAL
CREATE VIEW YES SERIAL
DROP AUDIT POLICY YES SERIAL
DROP FUNCTION YES SERIAL
DROP INDEX YES SERIAL
DROP PACKAGE YES SERIAL
DROP PROCEDURE YES SERIAL
DROP PROFILE YES SERIAL
DROP SCHEMA YES SERIAL
DROP SEQUENCE YES SERIAL
DROP SYNONYM YES SERIAL
DROP TABLE YES SERIAL
DROP TABLESPACE YES SERIAL
DROP USER YES SERIAL
DROP VIEW YES SERIAL
FLASHBACK TABLE YES SERIAL
GRANT .. ON DATABASE YES SERIAL
GRANT .. ON PACKAGE YES SERIAL
GRANT .. ON PROCEDURE YES SERIAL
GRANT .. ON SCHEMA YES SERIAL
GRANT .. ON TABLE YES SERIAL
GRANT .. ON TABLESPACE YES SERIAL
GRANT USAGE ON .. YES SERIAL
NOAUDIT POLICY YES SERIAL
PURGE CONSTRAINT YES SERIAL
PURGE DBA_RECYCLEBIN YES SERIAL
PURGE INDEX YES SERIAL
PURGE RECYCLEBIN YES SERIAL
PURGE TABLE YES SERIAL
PURGE TABLESPACE YES SERIAL
REVOKE .. ON DATABASE YES SERIAL
REVOKE .. ON PACKAGE YES SERIAL
REVOKE .. ON PROCEDURE YES SERIAL
REVOKE .. ON SCHEMA YES SERIAL
REVOKE .. ON TABLE YES SERIAL
REVOKE .. ON TABLESPACE YES SERIAL
REVOKE USAGE ON .. YES SERIAL
TRUNCATE TABLE YES SERIAL
103 rows selected.DDL statements which are not affected by DISABLE_SERIAL_DDL are queried as follows, and most of cluster DDLs are affected.
gSQL>
SELECT command
, is_ddl
, cluster_lock_mode
FROM v$sql_command
WHERE is_ddl = 'YES'
AND cluster_lock_mode <> 'SERIAL'
ORDER BY 1
;
COMMAND IS_DDL CLUSTER_LOCK_MODE
--------------------------------------------------------- ------ -----------------
ALTER CLUSTER GROUP .. ADD CLUSTER MEMBER YES MANUAL
ALTER CLUSTER GROUP .. OFFLINE CLUSTER MEMBER YES MANUAL
ALTER DATABASE ADD LOGFILE GROUP YES NONE
ALTER DATABASE ADD LOGFILE MEMBER YES NONE
ALTER DATABASE ARCHIVELOG YES NONE
ALTER DATABASE DROP INACTIVE CLUSTER MEMBERS YES MANUAL
ALTER DATABASE DROP LOGFILE GROUP YES NONE
ALTER DATABASE DROP LOGFILE MEMBER YES NONE
ALTER DATABASE NOARCHIVELOG YES NONE
ALTER DATABASE OFFLINE INACTIVE CLUSTER MEMBERS YES MANUAL
ALTER DATABASE RENAME GLOBAL TRANSACTION LOGFILE YES NONE
ALTER DATABASE RENAME LOGFILE YES NONE
ALTER DATABASE RESET LOCAL CLUSTER MEMBER YES NONE
ALTER INDEX .. REBUILD YES MANUAL
ALTER SEQUENCE .. SYNCHRONIZE YES MANUAL
ALTER SYSTEM SWITCH LOGFILE YES NONE
ALTER TABLE .. MERGE SHARDS .. INTO .. YES MANUAL
ALTER TABLE .. MOVE SHARD .. TO CLUSTER GROUP .. YES MANUAL
ALTER TABLE .. REBALANCE .. YES MANUAL
ALTER TABLE .. REBUILD GLOBAL SECONDARY INDEX YES MANUAL
ALTER TABLE .. SPLIT SHARD .. INTO .. AT CLUSTER GROUP .. YES MANUAL
ALTER TABLE .. SYNCHRONIZE .. YES MANUAL
ALTER TABLE .. SYNCHRONIZE IDENTITY COLUMN YES MANUAL
CREATE CLUSTER GROUP YES MANUAL
DROP CLUSTER GROUP YES MANUAL
25 rows selected.DISABLE_UPDATE_PK_CDC_GIVEUP
Basic Information
Item | Description |
|---|---|
Name | DISABLE_UPDATE_PK_CDC_GIVEUP |
Summary | disable UPDATE primary key which caused CDC give-up |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It disables UPDATE primary key which caused CDC give up.
DISALLOWED_PROTOCOL_TARGETTYPE
Basic Information
Item | Description |
|---|---|
Name | DISALLOWED_PROTOCOL_TARGETTYPE |
Summary | disallowed TARGETTYPE protocol |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It disallows TARGETTYPE protocol.
DISALLOWED_PROTOCOL_TARGETTYPE_WITH_ALL
Basic Information
Item | Description |
|---|---|
Name | DISALLOWED_PROTOCOL_TARGETTYPE_WITH_ALL |
Summary | disallowed TARGETTYPE_WITH_ALL protocol |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It disallows TARGETTYPE_WITH_ALL protocol.
DISALLOWED_PROTOCOL_TARGETTYPE_WITH_NAME
Basic Information
Item | Description |
|---|---|
Name | DISALLOWED_PROTOCOL_TARGETTYPE_WITH_NAME |
Summary | disallowed TARGETTYPE_WITH_NAME protocol |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It disallows TARGETTYPE_WITH_NAME protocol.
DISPATCHER_CM_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_CM_BUFFER_SIZE |
Summary | communication buffer size |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 10485760 |
MAX | 34359738368 |
Default value | 31457280 |
Description
It is the size of entire communication buffer used in shared mode. It is allocated to and used in Shared Static Area (SSA).
DISPATCHER_CM_UNIT_SIZE
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_CM_UNIT_SIZE |
Summary | communication unit size |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1024 |
MAX | 10485760 |
Default value | 1024 |
Description
It is the unit size managed by dispatcher in shared mode. If the size is large, the memory is wasted. If it is small, the performance is degraded. It is set to the maximum communication packet size in the shared mode.
DISPATCHER_CONNECTIONS
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_CONNECTIONS |
Summary | maximum number of connections for each dispatcher |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 10 |
MAX | 32768 |
Default value | 950 |
Description
It is the maximum number of connection (client) which a dispatcher can manage in shared mode. If the system- supported maximum value is smaller than the set value, it is internally set to the system maximum.
DISPATCHER_HOT_POLICY_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_HOT_POLICY_INTERVAL |
Summary | dispatcher dequeue interval for busy waiting |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 86400000000: 1 day |
Default value | 100000: 0.1 second |
Description
It is the dispatcher dequeue interval for busy waiting. (micro second)
DISPATCHER_LOAD_BALANCING
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_LOAD_BALANCING |
Summary | load balancing algorithm for shared mode (0: number of clients, 1: round robin) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
It is an algorithm allocating a dispatcher when connecting to a client in the shared mode.
0: It is allocated to a dispatcher of which the number of currently attached clients are small.
1: It is sequentially allocated to a dispatcher.
DISPATCHER_NUMA_STREAM_MAP
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_NUMA_STREAM_MAP |
Summary | numa stream map for dispatcher |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | 'x' : no binding |
Description
It determines NUMA node to which dispatchers are to be connected. This property is operated when NUMA property is set to on. The following is an example of three dispatchers. It connects number 0 stream to number 0 NUMA node, connects number 1 stream to number 1 NUMA node, and number 2 stream to number 2 NUMA node.
DISPATCHER_NUMA_STREAM_MAP = '0:1:2'
DISPATCHER_QUEUE_SIZE
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_QUEUE_SIZE |
Summary | dispatcher queue size |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1024 |
MAX | 32768 |
Default value | 1024 |
Description
In shared mode, it sets the queue size for the communication between the dispatcher and the shared-server.
DISPATCHER_REQUEST_MINI_QUEUE_COUNT
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_REQUEST_MINI_QUEUE_COUNT |
Summary | count of mini queue per request queue |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 16 |
Default value | 4 |
Description
It is the count of mini queue per request queue.
DISPATCHER_RESPONSE_MINI_QUEUE_COUNT
Basic Information
Item | Description |
|---|---|
Name | DISPATCHER_RESPONSE_MINI_QUEUE_COUNT |
Summary | count of mini queue per response queue |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 16 |
Default value | 4 |
Description
It is the count of mini queue per response queue.
DISPATCHERS
Basic Information
Item | Description |
|---|---|
Name | DISPATCHERS |
Summary | number of dispatcher processes |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 256 |
Default value | 2 |
Description
It sets the number of dispatcher processes when using the shared mode. It can not reduce the value by using alter system on open phase.
EXECUTE_INST_HASH_TABLE_USING_AVAILABLE_MEMORY
Basic Information
Item | Description |
|---|---|
Name | EXECUTE_INST_HASH_TABLE_USING_AVAILABLE_MEMORY |
Summary | execute instant hash table using available memory even if not enough |
Data type | BOOLEAN |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
If the memory is not sufficient to expand the hash bucket in the query using an instant hash table, then it determines whether to fail the query or to perform the query without expanding the hash bucket.
FETCH_FAILOVER
Basic Information
Item | Description |
|---|---|
Name | FETCH_FAILOVER |
Summary | enable fetch failover |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It enables the fetch failover.
FULL_TABLE_SCAN_CACHING_THRESHOLD
Basic Information
Item | Description |
|---|---|
Name | FULL_TABLE_SCAN_CACHING_THRESHOLD |
Summary | upper threshold of table size for buffer caching while full scan |
Data type | BIGINT |
Applicable phase | NO MOUNT above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1000 |
Default value | 20 |
Description
The threshold of the table size determines whether to cache the tables created in the disk tablespace to buffer cache when performing a full scan. FULL_TABLE_SCAN_CACHING_THRESHOLD sets this threshold value. The default value is 20. In this case, it caches only the tables which are using the number of pages equal to or less than 2.0% of BUFFER_CACHE_SIZE. If this value is 1000 (100%), then all tables are cached to the buffer when performing the full scan.
For example, if BUFFER_CACHE_SIZE is 8192 and FULL_TABLE_SCAN_CACHING_THRESHOLD is 509 (50.9%), then only the tables which are using the number of pages equal to or less than 4169 (50.9% of 8192) are cached to the buffer when performing the full scan.
GLOBAL_CONNECTION_ALLOW_SESSION_DEPENDENCY
Basic Information
Item | Description |
|---|---|
Name | GLOBAL_CONNECTION_ALLOW_SESSION_DEPENDENCY |
Summary | allowed session dependent features in global connection |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | TRUE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to support the query execution including the session dependent information in the global connection.
GLOBAL_JOURNAL_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | GLOBAL_JOURNAL_BUFFER_SIZE |
Summary | global journal buffer size |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1024 |
MAX | 10 Giga |
Default value | 1 Mega |
Description
It is the size of global journal buffer.
GLOBAL_JOURNAL_BUFFER_TOTAL_MAX_SIZE
Basic Information
Item | Description |
|---|---|
Name | GLOBAL_JOURNAL_BUFFER_TOTAL_MAX_SIZE |
Summary | global journal buffer total max size |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 Mega |
MAX | 100 Giga |
Default value | 64 Mega |
Description
It is the total max size of global journal buffer.
GLOBAL_PROPERTY_LOCK_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | GLOBAL_PROPERTY_LOCK_TIMEOUT |
Summary | a time limit(second) for how long global property lock statements will wait |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 (infinite) |
MAX | 100000000 |
Default value | 0 |
Description
When changing the global property, it performs the lock to control the concurrency. In this case, the waiting time to perform the lock is set.
GLOBAL_TRANSACTION_COMMIT_WRITE_MODE
Basic Information
Item | Description |
|---|---|
Name | GLOBAL_TRANSACTION_COMMIT_WRITE_MODE |
Summary | global transaction commit write mode (0: no_wait, 1: wait, 2: disable) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 2 |
Default value | 2 |
Description
It is a property to change the commit write mode of the global transaction. TRANSACTION_COMMIT_WRITE_MODE property is applied to all transactions, but GLOBAL_TRANSACTION_COMMIT_WRITE_MODE property is applied only to a global transaction. If the property is set to 2, then it follows the TRANSACTION_COMMIT_WRITE_MODE.
0: It does not wait.
1: It waits.
2: It follows the value of TRANSACTION_COMMIT_WRITE_MODE.
GLOBAL_TRANSACTION_ISOLATION_SCOPE
Basic Information
Item | Description |
|---|---|
Name | GLOBAL_TRANSACTION_ISOLATION_SCOPE |
Summary | isolation scope for global transaction(0: system, 1: group) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
It determines whether to process the data with a global transaction or with multiple domain transactions when the transaction changed the data through two cluster groups.
0: It processes with a global transaction.
1: It processes with multiple domain transactions.
If this property is set to 1, it commits each cluster group with a separate transaction, so it does not guarantees the transaction atomicity.
GLOBAL_TRANSACTION_LOG_DIR
Basic Information
Item | Description |
|---|---|
Name | GLOBAL_TRANSACTION_LOG_DIR |
Summary | default global transaction log directory |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/wal |
Description
It is the default directory of global transaction log.
GLOBAL_TRANSACTION_LOG_FILE_SIZE
Basic Information
Item | Description |
|---|---|
Name | GLOBAL_TRANSACTION_LOG_FILE_SIZE |
Summary | global transaction log file size |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 20 Mega |
MAX | 10 Giga |
Default value | 100 Mega |
Description
It is the file size of global transaction log.
GMASTER_NUMA_NODE
Basic Information
Item | Description |
|---|---|
Name | GMASTER_NUMA_NODE |
Summary | numa node for gmaster process |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | -1 |
MAX | 63 |
Default value | -1 |
Description
It sets the ID of NUMA node to be used by gmaster daemon. This property is operated when NUMA property is set to on.
GMON_AUTOSTART
Basic Information
Item | Description |
|---|---|
Name | GMON_AUTOSTART |
Summary | Indicate whether gmon process automatically starts or not ( 0 | 1 ) |
Data type | BOOLEAN |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | 1 |
Description
It sets whether to start gmon process automatically.
HINT_ERROR
Basic Information
Item | Description |
|---|---|
Name | HINT_ERROR |
Summary | enable hint error |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to check syntax error and validation error for hint syntax.
IDLE_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | IDLE_TIMEOUT |
Summary | idle timeout(s) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10000000 |
Default value | 0 |
Description
It sets the maximum IDLE time possible to wait in C/S session. If it exceeds the specified idle time, TIMEOUT error occurs.
0: It means infinite waiting, and TIMEOUT error does not occur.
IN_DOUBT_DECISION
Basic Information
Item | Description |
|---|---|
Name | IN_DOUBT_DECISION |
Summary | decision for in-doubt transaction |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 2 |
Default value | 2 |
Description
It determines whether to commit or to rollback the in-doubt transaction of distributed transactions.
1: Commit
2: Rollback
IN_KEY_RANGE_ARRAY_COUNT
Basic Information
Item | Description |
|---|---|
Name | IN_KEY_RANGE_ARRAY_COUNT |
Summary | array count for in key range scan |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 65536 |
Default value | 20 |
Description
It is the maximum number of values which are targets of in key range performing the in key range scan based on array.
IN_KEY_RANGE_ARRAY_COUNT should be 3 or bigger to perform the in key range scan based on array for the statement below.
gSQL> SELECT * FROM T1 WHERE C1 IN ( 1, 2, 3 )
If the maximum number of in key range target values are bigger than IN_KEY_RANGE_ARRAY_COUNT value, then in key range in key range scan is performed based on instant table.
INCREMENTAL_BACKUP_SCAN_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | INCREMENTAL_BACKUP_SCAN_BUFFER_SIZE |
Summary | number of pages read in one I/O operation during an incremental backup |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 8192 |
Default value | 32 |
Description
It sets the number of pages to read by one time disk IO for performing incremental backup of the disk tablespace.
INCREMENTAL_DATAFILE_HEADER_UPDATE_CRITERIA
Basic Information
Item | Description |
|---|---|
Name | INCREMENTAL_DATAFILE_HEADER_UPDATE_CRITERIA |
Summary | criteria for the number of flush page count to update datafile header |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 134217728 |
Default value | 134217728 |
Description
It sets the criteria of updating the data file header in the disk tablespace. It sets the LSN to start recovery in the datafile header when the pages updated as many as the set value is applied while IO slave applies the pages updated in the buffer cache to the disk. In this way, disk IO is decreased at restart recovery.
INDEX_BUILD_PARALLEL_FACTOR
Basic Information
Item | Description |
|---|---|
Name | INDEX_BUILD_PARALLEL_FACTOR |
Summary | index build parallel factor |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 64 |
Default value | 0 |
Description
When creating an index, it specifies the number of parallel factor.
0: It is specified as the number of the core factor in the system.
INDEX_LOGGING_THROTTLING
Basic Information
Item | Description |
|---|---|
Name | INDEX_LOGGING_THROTTLING |
Summary | The limit on the number of dirty blocks in the log buffer during index building or rebuilding |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1048576 |
MAX | 10737418240 |
Default value | 10737418240 |
Description
This property is used to prevent system overload caused by bulk logging during index creation and rebuild, ensuring that online services are not affected.
If there are more dirty blocks than the specified property value in the log buffer during index logging, it will wait until the dirty blocks are flushed to disk.
INDEX_MERGE_RUN_COUNT
Basic Information
Item | Description |
|---|---|
Name | INDEX_MERGE_RUN_COUNT |
Summary | merge run count for memory index |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 2 |
MAX | 64 |
Default value | 32 |
Description
Memory B-tree index of bottom-up approach is created by extracting all keys from a table, sorting them in certain block size (INDEX_SORT_RUN_SIZE) units, merging the sorted blocks, and generating the internal node. INDEX_MERGE_RUN_COUNT sets the number of the sorted blocks to be merged at a time.
ALIAS
Item | Description |
|---|---|
Original name | INDEX_MERGE_RUN_COUNT |
ALIAS | MEMORY_MERGE_RUN_COUNT |
INDEX_REBUILD_BLOCK_READ_COUNT
Basic Information
Item | Description |
|---|---|
Name | INDEX_REBUILD_BLOCK_READ_COUNT |
Summary | value count for a block read for index rebuild |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 65536 |
Default value | 100 |
Description
When DML is performed while rebuilding the index on ONLINE mode, the journal data is stored. The index is rebuilt based on the data at the time of beginning of the rebuilding, then the updated data during the rebuilding is applied to the index through the journal data. INDEX_REBUILD_BLOCK_READ_COUNT sets how much journal data to be read and applied to the index during this process.
INDEX_SORT_RUN_SIZE
Basic Information
Item | Description |
|---|---|
Name | INDEX_SORT_RUN_SIZE |
Summary | sort run size for memory index (byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 8192 |
MAX | 32768 |
Default value | 8192 |
Description
Memory B-tree index of bottom-up approach is created by extracting all keys from a table, sorting them in a certain block size (INDEX_SORT_RUN_SIZE) unit, merging the sorted blocks, and generating the internal node. INDEX_SORT_RUN_SIZE sets the size of a single block to be sorted.
ALIAS
Item | Description |
|---|---|
Original name | INDEX_SORT_RUN_SIZE |
ALIAS | MEMORY_SORT_RUN_SIZE |
INDEX_TREE_MERGE_PARALLEL_FACTOR
Basic Information
Item | Description |
|---|---|
Name | INDEX_TREE_MERGE_PARALLEL_FACTOR |
Summary | parallel factor for merging sub-trees |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 64 |
Default value | 0 |
Description
When creating an index, it specifies the number of parallel factor to merge the sub-tree. If that value is bigger than INDEX_BUILD_PARALLEL_FACTOR, then INDEX_BUILD_PARALLEL_FACTOR is used.
0: It follows INDEX_BUILD_PARALLEL_FACTOR.
INST_ALLOCATOR_COUNT
Basic Information
Item | Description |
|---|---|
Name | INST_ALLOCATOR_COUNT |
Summary | memory allocator count for instant tables or indexes |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 3 |
MAX | 128 |
Default value | 3 |
Description
This property increases the parallel property of operation allocating or deleting an instant block.
INST_HASH_TABLE_BUCKET_MAX_COUNT
Basic Information
Item | Description |
|---|---|
Name | INST_HASH_TABLE_BUCKET_MAX_COUNT |
Summary | instant hash table bucket max count |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 4294967295 |
Default value | 0 |
Description
It sets the maximum expected bucket counts of the hash instant table.
INST_TABLE_BLOCK_SIZE
Basic Information
Item | Description |
|---|---|
Name | INST_TABLE_BLOCK_SIZE |
Summary | a block size of instant tables or indexes |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 8192 |
MAX | 1048576 |
Default value | 16384 |
Description
It determines the size of an instant block. If the anchor area of an instant record is bigger than an instant block, then the following error occurs.
gSQL> SELECT DISTINCT * FROM T1, T1, T1, T1, T1, T1, T1, T1, T1, T1; ERR-HY000(14098): maximum record length(16360) exceeds
IPC_CHANNEL_COUNT
Basic Information
Item | Description |
|---|---|
Name | IPC_CHANNEL_COUNT |
Summary | IPC Channel Count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 2048 |
Default value | 0 |
Description
It sets the number of channels for IPC communication.
JOURNAL_TEMP_DIR
Basic Information
Item | Description |
|---|---|
Name | JOURNAL_TEMP_DIR |
Summary | journaling temporary directory |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/journal |
Description
It is the temporary directory of journaling.
KEEPALIVE_IDLE_TIME
Basic Information
Item | Description |
|---|---|
Name | KEEPALIVE_IDLE_TIME |
Summary | tcp keepalive idle time for checking dead client session (sec) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 16383 |
Default value | 300 |
Description
It means the idle duration between the server and client without tcp packet exchange before sending keep alive packet. If there is not tcp packet exchange for seconds (KEEPALIVE_IDLE_TIME), keep alive mechanism starts execution to detect the dead connection on the server side.
LOCAL_CLUSTER_MEMBER
Basic Information
Item | Description |
|---|---|
Name | LOCAL_CLUSTER_MEMBER |
Summary | local cluster member name |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | N/A |
MAX | N/A |
Default value | 'G1N1' |
Description
It is the local cluster member name.
LOCAL_CLUSTER_MEMBER_HOST
Basic Information
Item | Description |
|---|---|
Name | LOCAL_CLUSTER_MEMBER_HOST |
Summary | host name of local cluster member |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | N/A |
MAX | N/A |
Default value | '127.0.0.1' |
Description
It is host name of local cluster member.
LOCAL_CLUSTER_MEMBER_PORT
Basic Information
Item | Description |
|---|---|
Name | LOCAL_CLUSTER_MEMBER_PORT |
Summary | listen port of local cluster member |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | 1024 |
MAX | 49151 |
Default value | 10101 |
Description
It is listen port of local cluster member.
LOCAL_JOURNAL_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | LOCAL_JOURNAL_BUFFER_SIZE |
Summary | local journal buffer size |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1024 |
MAX | 10737418240 (10 Giga) |
Default value | 65536 |
Description
It is the local journal buffer size.
LOCATION_FILE
Basic Information
Item | Description |
|---|---|
Name | LOCATION_FILE |
Summary | location file name |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/wal/location.ctl |
Description
It is the location file name.
LOCATOR_QUERY_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | LOCATOR_QUERY_TIMEOUT |
Summary | timeout for waiting locator response (sec) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10000000 |
Default value | 3 |
Description
It sets the time (second) waiting for the response after the cluster system enquires of a locator about the solution of split-brain situation. This property is used only when CLUSTER_SPLIT_BRAIN_RESOLUTION_POLICY is set to 1 or more.
LOCK_HASH_TABLE_SIZE
Basic Information
Item | Description |
|---|---|
Name | LOCK_HASH_TABLE_SIZE |
Summary | lock manager hash table size (The number of buckets) |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 2 |
MAX | 1000000 |
Default value | 65519 |
Description
It specifies the maximum hash table size managed by a lock manager.
LOCKABLE_DISPATCHER_CM_BUFFER_COUNT
Basic Information
Item | Description |
|---|---|
Name | LOCKABLE_DISPATCHER_CM_BUFFER_COUNT |
Summary | communication buffer count for lockable dispatcher |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 128 |
Default value | 1 |
Description
It specifies the number of cluster lockable dispatcher's communication buffers.
LOCKLESS_DISPATCHER_CM_BUFFER_COUNT
Basic Information
Item | Description |
|---|---|
Name | LOCKLESS_DISPATCHER_CM_BUFFER_COUNT |
Summary | communication buffer count for lockless dispatcher |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 128 |
Default value | 1 |
Description
It specifies the number of cluster lockless dispatcher's communication buffers.
LOG_BLOCK_SIZE
Basic Information
Item | Description |
|---|---|
Name | LOG_BLOCK_SIZE |
Summary | log block size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 512 |
MAX | 4096 |
Default value | 512 |
Description
It means the minimum size of what log buffer is flushed to the log file of the disk. Its value should be set to one of 512, 1024, 2048, 4096.
LOG_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | LOG_BUFFER_SIZE |
Summary | default log buffer size (byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 1048576 |
MAX | 10737418240 |
Default value | 10485760 |
Description
A log buffer is the shared memory space in which the redo logs generated in database by the DML/DDL operations are stored. LOG_BUFFER_SIZE is referenced to set the memory size for the log buffer.
LOG_DIR
Basic Information
Item | Description |
|---|---|
Name | LOG_DIR |
Summary | default log direcotry |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/wal |
Description
The log recorded in the log buffer is flushed to the logfile which exists in a non-volatile storage device to ensure the database durability. LOG_DIR sets the path to the log file.
LOG_FILE_SIZE
Basic Information
Item | Description |
|---|---|
Name | LOG_FILE_SIZE |
Summary | log file size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 20 Mbytes |
MAX | 120 Gbytes |
Default value | 100 Mbytes |
Description
It sets the size of the logfile used in database. It is referenced only when creating the database, then log file size can not be updated after then.
LOG_GROUP_COUNT
Basic Information
Item | Description |
|---|---|
Name | LOG_GROUP_COUNT |
Summary | initial count of log group |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 4 |
MAX | 254 |
Default value | 4 |
Description
It sets the number of log group used in database. It is referenced only when creating the database, but after that, it does not affect any operations. After creating database, the operation to add or remove a log group is supported by a separate syntax.
LOG_MIRROR_MODE
Basic Information
Item | Description |
|---|---|
Name | LOG_MIRROR_MODE |
Summary | LogMirror Mode (1:Enable, 0:Disable) |
Data type | BOOLEAN |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It is the property to configure the required shared memory when operating LogMirror, the redo log replication tool, at database startup. It should be enabled to execute the LogMirror. The size of the shared Memory can be changed using LOG_MIRROR_SHARED_MEMORY_STATIC_SIZE.
LOG_MIRROR_SHARED_MEMORY_STATIC_SIZE
Basic Information
Item | Description |
|---|---|
Name | LOG_MIRROR_SHARED_MEMORY_STATIC_SIZE |
Summary | shared memory size for LogMirror (byte) |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 10485760 (10 M) |
MAX | 1073741824 (1 G) |
Default value | 104857600 (100 M) |
Description
It sets the size of the shared memory used in LogMirror, the redo log replication tool. It is applied in the state which LOG_MIRROR_MODE is enabled.
LOG_MIRROR_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | LOG_MIRROR_TIMEOUT |
Summary | logmirror retry timeout (sec) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 100000000 |
Default value | 0 |
Description
It is the response waiting time of the LogMirror. If its value is 0, it waits indefinitely. Otherwise, it waits as long as the value set, then TIMEOUT occurs, and it stops LogMirror service. Later, the server is operated normally. It is applied in the state which LOG_MIRROR_MODE is enabled.
LOG_SYNC_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | LOG_SYNC_INTERVAL |
Summary | interval for synchronize log (s) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 10000 |
Default value | 3 |
Description
Log flusher of GOLDILOCKS is a system thread which flushes the log buffer contents to disk logfile. When log flusher wakes up in the idle phase, it checks if log to flush exists. Then it flushes the log if any. If the log flusher did not flush within the time set in LOG_SYNC_INTERVAL, it synchronizes the log buffer and the log file by performing a flush until the last block of the current log buffer.
LOG_SYNC_INTERVAL_MSEC
Basic Information
Item | Description |
|---|---|
Name | LOG_SYNC_INTERVAL_MSEC |
Summary | milli-second interval for synchronize log |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10000000 |
Default value | 0 |
Description
It is the millisecond interval for synchronize log.
MAX_GROUP_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAX_GROUP_COUNT |
Summary | maximum group count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 8192 |
Default value | 32 |
Description
It is the maximum group count in the cluster system.
MAX_JOURNAL_FILE_SIZE
Basic Information
Item | Description |
|---|---|
Name | MAX_JOURNAL_FILE_SIZE |
Summary | maximum journal file size |
Data type | BIGINT |
Applicable phase | MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1099511627776 (1 Terabytes) |
Default value | 0 (no limit) |
Description
It sets the maximum size (quota) of the global journaling file which internally stores journaling data when a journaling occurs in cluster system.
MAX_NODE_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAX_NODE_COUNT |
Summary | maximum node count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | 1 |
MAX | 8192 |
Default value | 64 |
Description
It is the maximum node (instance) count which can join the cluster system.
MAXIMUM_CONCURRENT_ACTIVITIES
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_CONCURRENT_ACTIVITIES |
Summary | maximum number of active statements that the driver can support for a connection |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 65535 |
Default value | 1024 |
Description
It sets the number of statements which can be executed simultaneously.
MAXIMUM_FILE_CACHE_SIZE
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_FILE_CACHE_SIZE |
Summary | the limit of file descriptor cache |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 16 |
MAX | 32768 |
Default value | 128 |
Description
It sets the maximum number of file caches which is being used in the session.
MAXIMUM_FLUSH_BUFFER_PAGE_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_FLUSH_BUFFER_PAGE_COUNT |
Summary | maximum number of buffer page count to be flushing |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 8192 |
Default value | 64 |
Description
It sets the maximum number of pages which can be recorded per disk writing operation. If the pages in the disk tablespace are updated in the buffer, then IO thread records them on the disk. If recording nearby pages together when performing disk writing operation, then it increases the efficiency of the system resource by decreasing the number of disk recording.
MAXIMUM_FLUSH_LOG_BLOCK_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_FLUSH_LOG_BLOCK_COUNT |
Summary | maximum number of log block count to be flushing |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1000 |
MAX | 2000000 |
Default value | 100000 |
Description
When flushing the contents of the log buffer to disk log file, it sets the maximum number of log blocks to be flushed with a single writing operation.
MAXIMUM_FLUSH_PAGE_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_FLUSH_PAGE_COUNT |
Summary | maximum number of page count to be flushing |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 8192 |
Default value | 1024 |
Description
GOLDILOCKS datafiles are flushed to the disk by the checkpoint and certain DDL statements. For flushing datafiles, it sets the maximum number of data pages to be flushed with a single writing operation.
MAXIMUM_INDEX_REBUILD_JOURNAL_REPLAY_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_INDEX_REBUILD_JOURNAL_REPLAY_COUNT |
Summary | maximum number of replaying journals for rebuild index |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 2 |
MAX | 1024 |
Default value | 2 |
Description
When rebuilding the index on ONLINE mode, it can be performed together with DML, and DML records the updates on the journal log. The index is rebuilt based on the data at the time of beginning of the rebuilding, then the updated data during the rebuilding is applied to the index through the journal log. The journal logs are initially applied, then journal logs which were accumulated while applying the journal logs are applied. This property sets how may times the journal logs are applied in this way.
MAXIMUM_JOURNAL_REPLAY_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_JOURNAL_REPLAY_COUNT |
Summary | maximum number of replaying journals for rebalance table |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 2 |
MAX | 1024 |
Default value | 2 |
Description
The table rebalancing online can be performed together with DML in the cluster environment, and DML records the updates on the journal log at that moment. The table rebalancing initially applies the journal logs which occurred during synchronizing tables, then applies journal logs which were accumulated while applying the journal logs. This property sets how may times the journal logs are applied in this way.
MAXIMUM_NAMED_CURSOR_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_NAMED_CURSOR_COUNT |
Summary | maximum number of named cursor that the driver can support for a connection |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 100000 |
Default value | 128 |
Description
It is the maximum number of named cursor which can be used within a single session. A named cursor is created in the following cases.
When a named cursor is declared using functions like SQLSetCursorName(), SQLGetCursorName()
{
...
SQLSetCursorName( stmt,
"my_cursor",
SQL_NTS );
...
}When the DECLARE cursor syntax is used by a function such as SQLExecDirect (), SQLPrepare ()
{
...
SQLExecDirect( stmt,
"DECLARE my_cursor CURSOR FOR SELECT col_name FROM tab_name",
SQL_NTS );
...
}When DECLARE cursor FOR UPDATE syntax is used in an embedded SQL
{
...
EXEC SQL DECLARE my_cursor CURSOR FOR SELECT col_name FROM tab_name FOR UPDATE;
...
EXEC SQL OPEN my_cursor;
...
EXEC SQL FETCH my_cursor INTO :data;
EXEC SQL DELETE FROM tab_name WHERE CURRENT OF my_cursor;
...
EXEC SQL CLOSE my_cursor;
}In an embedded SQL, DECLARE CURSOR syntax without FOR UPDATE as follows does not create a named cursor on the session.
{
...
EXEC SQL DECLARE my_cursor CURSOR FOR SELECT col_name FROM tab_name;
...
}MAXIMUM_PACKAGE_INSTANCE_COUNT
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_PACKAGE_INSTANCE_COUNT |
Summary | maximum number of package instance that the driver can support for a connection |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 100000 |
Default value | 128 |
Description
It is the maximum number of package instances which are available in a single session. A package instance is created when using the stateful package in the session.
MAXIMUM_SESSION_CM_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | MAXIMUM_SESSION_CM_BUFFER_SIZE |
Summary | maximum communication bytes per shared mode session |
Data type | BIGINT |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1048576 |
MAX | 1073741824 |
Default value | 20971520 |
Description
It sets the maximum buffer size available in a single session which is connected to shared mode. For more information, refer to DISPATCHER_CM_BUFFER_SIZE.
MEASURE_CLUSTER_LATENCY
Basic Information
Item | Description |
|---|---|
Name | MEASURE_CLUSTER_LATENCY |
Summary | measure cluster latency |
Data type | BOOL |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It is the measure cluster latency.
MIN_SAMPLE_ROW_COUNT
Basic Information
Item | Description |
|---|---|
Name | MIN_SAMPLE_ROW_COUNT |
Summary | minimum sampling row count for analyze table |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 9223372036854775807 (INT64_MAX) |
Default value | 100000 |
Description
It is the minimum number of sampling rows when executing ANALYZE TABLE by using the sampling.
MINIMUM_UNDO_PAGE_COUNT
Basic Information
Item | Description |
|---|---|
Name | MINIMUM_UNDO_PAGE_COUNT |
Summary | minimum undo page count |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 16 |
MAX | 1048576 |
Default value | 16 |
Description
DML uses the undo page to store the previous image. Undo page is consumed by using a single undo segment per DML. If all allocated pages of undo segments are consumed, the page of another undo segment can be used. MINIMUM UNDO PAGE_COUNT is the minimum number of undo page to specify the undo segment to import page when undo pages are insufficient. If the undo pages are insufficient, the pages can be imported only from the undo segment having more pages than MINIMUM UNDO PAGE_COUNT.
NET_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | NET_BUFFER_SIZE |
Summary | TCP network buffer size (byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 1024 |
MAX | 1073741824 |
Default value | 32768 |
Description
It sets the TCP communications buffer size. In the dedicated mode, it is set to the maximum communication packet size. In the shared mode, it is set to DISPATCHER_CM_UNIT_SIZE.
NLS_DATE_FORMAT
Basic Information
Item | Description |
|---|---|
Name | NLS_DATE_FORMAT |
Summary | nls date format |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | YYYY-MM-DD |
Description
NLS_DATE_FORMAT specifies the default date format of TO_CHAR and TO_DATE functions.
NLS_TIME_FORMAT
Basic Information
Item | Description |
|---|---|
Name | NLS_TIME_FORMAT |
Summary | nls time format |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | HH24:MI:SS.FF6 |
Description
NLS_DATE_FORMAT specifies the default time format of TO_CHAR and TO_DATE functions.
NLS_TIME_WITH_TIME_ZONE_FORMAT
Basic Information
Item | Description |
|---|---|
Name | NLS_TIME_WITH_TIME_ZONE_FORMAT |
Summary | nls time with time zone format |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | HH24:MI:SS.FF6 TZH:TZM |
Description
NLS_TIME_WITH_TIME_ZONE FORMAT specifies the default time with time zone format of TO_CHAR and TO_TIME_WITH_TIME_ZONE functions.
NLS_TIMESTAMP_FORMAT
Basic Information
Item | Description |
|---|---|
Name | NLS_TIMESTAMP_FORMAT |
Summary | nls timestamp format |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | YYYY-MM-DD HH24:MI:SS.FF6 |
Description
NLS_TIMESTAMP_FORMAT specifies the default timestamp format of TO_CHAR and TO_TIMESTAMP functions.
NLS_TIMESTAMP_WITH_TIME_ZONE_FORMAT
Basic Information
Item | Description |
|---|---|
Name | NLS_TIMESTAMP_WITH_TIME_ZONE_FORMAT |
Summary | nls timestamp with time zone format |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | YYYY-MM-DD HH24:MI:SS.FF6 TZH:TZM |
Description
NLS_TIMESTAMP_WITH_TIME_ZONE FORMAT specifies the default timestamp with time zone format of TO_CHAR and TO_TIMESTAMP WITH TIMEZONE functions.
NUMA
Basic Information
Item | Description |
|---|---|
Name | NUMA |
Summary | enable numa |
Data type | BOOLEAN |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It enables NUMA.
To use the NUMA property in AIX, the user account should be modified. Execute the following command as a root user.
# chuser "capabilities=CAP_NUMA_ATTACH,CAP_PROPAGATE" <username>
<username> is not a root but it is a user account of AIX.
Logout then login again to apply the modifications.
NUMA_MAP
Basic Information
Item | Description |
|---|---|
Name | NUMA_MAP |
Summary | numa node map |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | 'x' : no binding |
Description
It sets the map to connect cores of the system to NUMA node. This property is operated when NUMA property is set to on.
The following is an example of the system having four cores.
Connect core 0 and 1 to number 0 NUMA node, and core 2 and 3 to number 1 NUMA node.
NUMA_MAP = '0:0:1:1' # core
Connect core 0 and 1 to number 0 NUMA node, and core 2 and 3 to number 1 NUMA node, and core 1 and 3 to number 2 NUMA node.
NUMA_MAP = '0:0,2:1:1,2' # core
OFFLINE_MEMBER_AFTER_FAILOVER
Basic Information
Item | Description |
|---|---|
Name | OFFLINE_MEMBER_AFTER_FAILOVER |
Summary | Automatically offline member after failover |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
The background process automatically takes the errored member offline after completing the failover caused by the node error. If it is not possible to take the errored member offline because it is set to NO, then execute the following syntax before the errored member joins the system again.
gSQL> ALTER DATABASE OFFLINE INACTIVE CLUSTER MEMBERS; Database altered.
ONLINE_INDEX_REBUILD_JOURNAL_REPLAY_THRESHOLD
Basic Information
Item | Description |
|---|---|
Name | ONLINE_INDEX_REBUILD_JOURNAL_REPLAY_THRESHOLD |
Summary | threshold bytes for replaying journals without table lock |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10737418240 |
Default value | 1048576 |
Description
DML performed during rebuilding the index on ONLINE mode records the journal log. The journals are applied to the index multiple times when finishing rebuilding the index. MAXIMUM_INDEX_REBUILD_JOURNAL_REPLAY_COUNT sets how many times to apply the journal logs. However, if the amount of journal logs to be applied are small, then it is not repeated as many as it is set to be, but instantly set the table the EXCLUSIVE lock, and uses it as the threshold value to apply the last journal log.
ONLINE_JOURNAL_REPLAY_THRESHOLD
Basic Information
Item | Description |
|---|---|
Name | ONLINE_JOURNAL_REPLAY_THRESHOLD |
Summary | threshold bytes for replaying journals without table lock |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10737418240 (10G) |
Default value | 1048576 (1M) |
Description
The table rebalancing online applies journal logs several times which were recorded by dml occurred during the performance in the cluster environment. MAXIMUM_JOURNAL_REPLAY_COUNT sets how many times to apply the journal logs. However, if the amount of journal logs to be applied are small, then it is not repeated as many as it is set to be, but instantly set the table the EXCLUSIVE lock, and uses it as the threshold value to apply the last journal log.
OS_GROUP_ACCESS
Basic Information
Item | Description |
|---|---|
Name | OS_GROUP_ACCESS |
Summary | enable access database with OS group permission |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
To connect to DA with another user of the same group, this property should be set to YES. Also, the umask of the system should be modified to 0002.
PACKET_COMPRESSION_THRESHOLD
Basic Information
Item | Description |
|---|---|
Name | PACKET_COMPRESSION_THRESHOLD |
Summary | The size limit at which packets are compressed(bytes) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 32 |
MAX | 2113929216 |
Default value | 2113929216 |
Description
If the data size to be sent to the client is bigger than PACKET_COMPRESSION_THRESHOLD, it compresses the communication data.
PAGE_CHECKSUM_TYPE
Basic Information
Item | Description |
|---|---|
Name | PAGE_CHECKSUM_TYPE |
Summary | page checksum type (0:LSN, 1:CRC) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
A checksum is used to guarantee the physical consistency for each page of the datafile. GOLDILOCKS supports a page checksum of LSN, CRC scheme.
0: LSN
1: CRC
PARALLEL_IO_FACTOR
Basic Information
Item | Information |
|---|---|
Name | PARALLEL_IO_FACTOR |
Summary | parallel load factor |
Data type | BIGINT |
Applicable phase | NO MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 16 |
Default value | 1 |
Description
It sets the number of threads for the parallel loading of data file when starting database and the number of threads for parallel recording of data file at checkpoint.
PARALLEL_IO_GROUP_1 ~ PARALLEL_IO_GROUP_16
Basic Information
Item | Description |
|---|---|
Name | PARALLEL_IO_GROUP_1 |
Summary | parallel load group 1 |
Data type | VARCHAR |
Applicable phase | NO MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/db |
Description
It sets the group directory for parallel I/O of data file. It sets the number of group as many as PARALLEL_IO_FACTOR, then parallel I/O is performed in data file unit which belongs to each group.
PARALLEL_LOAD_FACTOR
Basic Information
Item | Description |
|---|---|
Name | PARALLEL_LOAD_FACTOR |
Summary | parallel load factor |
Data type | BIGINT |
Applicable phase | NO MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 64 |
Default value | 1 |
Description
When starting database, it sets the number of threads for parallel operation after loading the memory of a data file.
PENDING_LOG_BUFFER_COUNT
Basic Information
Item | Description |
|---|---|
Name | PENDING_LOG_BUFFER_COUNT |
Summary | default pending log buffer count |
Data type | BIGINT |
Applicable phase | NO MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 32 |
Default value | 4 |
Description
When multiple transactions are simultaneously running, the pending log buffer is used to reduce the competition for the log buffer. PENDING LOG_BUFFER COUNT sets the number of pending log buffer which can be used simultaneously.
PLAN_CACHE
Basic Information
Item | Description |
|---|---|
Name | PLAN_CACHE |
Summary | caching sql plan |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
It determines whether to use the plan cache.
PLAN_CACHE_SIZE
Basic Information
Item | Description |
|---|---|
Name | PLAN_CACHE_SIZE |
Summary | sql plan cache size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 20971520 |
MAX | 1099511627776 |
Default value | 104857600 |
Description
It sets the memory size to be used for the plan cache.
PLAN_HISTORY
Basic Information
Item | Description |
|---|---|
Name | PLAN_HISTORY |
Summary | plan history for SQLs |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to use the plan history.
PLAN_HISTORY_SIZE
Basic Information
Item | Description |
|---|---|
Name | PLAN_HISTORY_SIZE |
Summary | plan history size |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 100000 |
Default value | 0 |
Description
It sets the number of plans to be stored in the plan history.
PRIVATE_STATIC_AREA_INIT_SIZE
Basic Information
Item | Description |
|---|---|
Name | PRIVATE_STATIC_AREA_INIT_SIZE |
Summary | Initial size of Private Static Area (byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1048576 |
MAX | 34359738368 |
Default value | 10485760 |
Description
It sets the initial size of the heap memory to use in the session. Even when there are memories which are not used in the session, the memories are not returned to operating system.
PRIVATE_STATIC_AREA_NEXT_SIZE
Basic Information
Item | Description |
|---|---|
Name | PRIVATE_STATIC_AREA_NEXT_SIZE |
Summary | Next size of Private Static Area (byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1024 |
MAX | 34359738368 |
Default value | 10485760 |
Description
It sets the size of memory to extend when the session allocates additional heap memory.
PRIVATE_STATIC_AREA_SHRINK_THRESHOLD
Basic Information
Item | Description |
|---|---|
Name | PRIVATE_STATIC_AREA_SHRINK_THRESHOLD |
Summary | Threshold bytes to attempt to shrink private static area(byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1048576 |
MAX | 34359738368 |
Default value | 10485760 |
Description
The memory size is preserved as big as this property even when there are unused heap memories in the session, and those memories are not returned to the system but are reused in the session.
Even when it is set to smaller than PRIVATE_STATIC_AREA_INIT_SIZE, it is not decreased to smaller than the size.
PRIVATE_STATIC_AREA_SIZE
Basic Information
Item | Description |
|---|---|
Name | PRIVATE_STATIC_AREA_SIZE |
Summary | Shared Static Area Size (byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 104857600 |
MAX | 34359738368 |
Default value | 104857600 |
Description
It specifies the maximum heap memory size to be allocated by the session.
PROCESS_MAX_COUNT
Basic Information
Item | Description |
|---|---|
Name | PROCESS_MAX_COUNT |
Summary | Process Max Count |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 12 |
MAX | 65535 |
Default value | 128 |
Description
It specifies the maximum number of processes (threads) available on the system.
Creating system process • The process is created each time of connection to D/A mode or C/S dedicated mode. • In C/S shared mode, processes are basic balancer, dispatcher and shared-server. A process is not created when connecting from client.
QUERY_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | QUERY_TIMEOUT |
Summary | query timeout (s) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10000000 |
Default value | 0 |
Description
It specifies the maximum time which a command received from the session can be executed. If the execution time exceeds, the TIMEOUT error occurs.
0: It means infinite waiting, and TIMEOUT error does not occur.
READABLE_ARCHIVELOG_DIR_COUNT
Basic Information
Item | Description |
|---|---|
Name | READABLE_ARCHIVELOG_DIR_COUNT |
Summary | readable archive log directory count |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 10 |
Default value | 1 |
Description
It sets the number of directories in which archive redo logs exist when executing media recovery.
READABLE_BACKUP_DIR_COUNT
Basic Information
Item | Description |
|---|---|
Name | READABLE_BACKUP_DIR_COUNT |
Summary | readable backup directory count |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 10 |
Default value | 1 |
Description
It sets the number of directories in which incremental backups exist when restoring files using incremental backups.
REBALANCE_BLOCK_READ_COUNT
Basic Information
Item | Description |
|---|---|
Name | REBALANCE_BLOCK_READ_COUNT |
Summary | block read count for rebalance |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 1 |
MAX | 65536 |
Default value | 1 |
Description
It is the block read count for rebalance.
REBALANCE_SHARD_DIVISOR
Basic Information
Item | Description |
|---|---|
Name | REBALANCE_SHARD_DIVISOR |
Summary | partition factor of shard upon rebalance |
Data type | BIGINT |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 1000 |
Default value | 1 |
Description
It sets the number of shards to divide which are used to rebalance and synchronize the table. For more information, refer to ALTER TABLE name REBALANCE.
RECOMPILE_CHECK_MINIMUM_PAGE_COUNT
It is not supported after 3.1.
Basic Information
Item | Description |
|---|---|
Name | RECOMPILE_CHECK_MINIMUM_PAGE_COUNT |
Summary | minimum page count for recompile check |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 10000 |
Default value | 64 |
Description
It sets the minimum page count to check if the plan is recompiled due to the page count modification.
RECOMPILE_PAGE_PERCENT
It is not supported after 3.1.
Basic Information
Item | Description |
|---|---|
Name | RECOMPILE_PAGE_PERCENT |
Summary | recompile page percent |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1000 |
Default value | 30 |
Description
It sets the page percentage when recompiles the plan due to the page count modification. If its value is 0, it does not recompile due to the page count modification.
RECOVERY_LOG_BUFFER_SIZE
Basic Information
Item | Description |
|---|---|
Name | RECOVERY_LOG_BUFFER_SIZE |
Summary | default log buffer size for recovery |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 786432 |
MAX | 32 Mega |
Default value | 10 Mega |
Description
It is the default log buffer size for recovery.
RECYCLEBIN
Basic Information
Item | Description |
|---|---|
Name | RECYCLEBIN |
Summary | enable or disable recyclebin feature |
Data type | BOOLEAN |
Applicable phase | NO_MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to activate the recyclebin feature.
REDO_LOG_COMPRESSION_THRESHOLD
Basic Information
Item | Description |
|---|---|
Name | REDO_LOG_COMPRESSION_THRESHOLD |
Summary | The size limit at which redo log are compressed(bytes) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 32 |
MAX | 2113929216 |
Default value | 2113929216 |
Description
If the size of the created REDO LOG is bigger than REDO_LOG_COMPRESSION_THRESHOLD value, it compresses REDO LOG.
REFINE_RELATION
Basic Information
Item | Description |
|---|---|
Name | REFINE_RELATION |
Summary | refine aged relations |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
If this property is set to NO, then REFINE RELATION process is not performed when restarting the server.
This property can be used when an error occurs during the REFINE RELATION process. However, segments of RELATIONs (tables or indexes) which were dropped but not REFINEd can not be reused. When resolving the error then setting this property to YES and restarting, it tries to REFINE relations which were not dropped.
SESSION_FATAL_BEHAVIOR
Basic Information
Item | Description |
|---|---|
Name | SESSION_FATAL_BEHAVIOR |
Summary | session fatal behavior |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
When session fatal occurs, it determines whether to terminate only the thread which caused the fatal or to terminate the process.
0: It terminates only the thread which caused fatal.
1: It terminates the process.
If multiple sessions are simultaneously performed in the process, the process is terminated after all sessions finish using database.
SESSION_MEMORY_INIT_SIZE
Basic Information
Item | Description |
|---|---|
Name | SESSION_MEMORY_INIT_SIZE |
Summary | initial memory size for session |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 131072 (128K) |
MAX | 1073741824 (1G) |
Default value | 131072 (128K) |
Description
It sets the shared memory size to be allocated in advance so that it can be used in the session.
SESSION_MEMORY_SHRINK_THRESHOLD
Basic Information
Item | Description |
|---|---|
Name | SESSION_MEMORY_SHRINK_THRESHOLD |
Summary | threshold bytes to attempt to shrink session memory allocator ( byte ) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 131072 (128K) |
MAX | 1073741824 (1G) |
Default value | 131072 (128K) |
Description
It sets the threshold value to determine whether to return the dynamic shared memory which is not used by the session to the system when releasing the dynamic shared memory used in the session. In other words, if the memory chunk which is bigger than the set value among unused memory exists, then it is returned to the system.
SESSION_POOL_INIT_SIZE
Basic Information
Item | Description |
|---|---|
Name | SESSION_POOL_INIT_SIZE |
Summary | initial memory size for session pool |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 0 |
MAX | 1099511627776 (1T) |
Default value | 0 |
Description
It sets the initial memory size of the session pool.
If each session needs a memory, then the space is allocated from the session pool. If the space in the session pool is insufficient, then the space is allocated from SSA. The session pool is used to prevent the session from frequently accessing to SSA, and if it is set to "0", then the session pool feature is inactivated.
SESSION_POOL_NEXT_SIZE
Basic Information
Item | Description |
|---|---|
Name | SESSION_POOL_NEXT_SIZE |
Summary | memory size to be expanded in session pool |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 131072 (128K) |
MAX | 1073741824 (1G) |
Default value | 1048576 (1M) |
Description
It sets how much to extend the memory size in the session pool when expanding the session pool space. It is valid only when SESSION_POOL_INIT_SIZE is bigger than 0.
SHARED_MEMORY_ADDRESS
Basic Information
Item | Description |
|---|---|
Name | SHARED_MEMORY_ADDRESS |
Summary | shared memory address |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | 1610612736 |
Description
It specifies the address of Shared Static Area (SSA).
SHARED_MEMORY_STATIC_KEY
Basic Information
Item | Description |
|---|---|
Name | SHARED_MEMORY_STATIC_KEY |
Summary | Shared Memory Static KEY |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | 542353 |
Description
When running server, it specifies the shared memory key values which are used to allocate Static Shared Area (SSA) space.
SHARED_MEMORY_STATIC_NAME
Basic Information
Item | Description |
|---|---|
Name | SHARED_MEMORY_STATIC_NAME |
Summary | Shared Memory Static Name |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | _STATIC |
Description
When running server, it specifies the shared memory name which is used to allocate Static Shared Area (SSA) space.
SHARED_MEMORY_STATIC_SIZE
Basic Information
Item | Description |
|---|---|
Name | SHARED_MEMORY_STATIC_SIZE |
Summary | Shared Memory Static Size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 104857600 |
MAX | 1099511627776 |
Default value | 629145600 |
Description
It specifies the size of the Shared Static Area (SSA).
SHARED_REQUEST_QUEUE_COUNT
Basic Information
Item | Description |
|---|---|
Name | SHARED_REQUEST_QUEUE_COUNT |
Summary | count of global request queue |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 16 |
Default value | 1 |
Description
In shared mode, it sets the number of queues of which the dispatcher requests to the shared-server. A queue is used when multiple dispatchers allocate user's requests to the shared-server. Generally, a single queue is used for the load-balance. However, SHARED_REQUEST_QUEUE_COUNT value is increased because if the number of dispatchers and shared-servers increase, then a conflict to the queue causes performance degradation. If the value becomes bigger, the load-balance can be inefficient and the possibility of deadlock increases.
SHARED_SERVERS
Basic Information
Item | Description |
|---|---|
Name | SHARED_SERVERS |
Summary | number of shared-server processes |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 2048 |
Default value | 10 |
Description
It sets the number of shared-server processes on shared mode. At open phase, the value can not be decreased by using alter system.
SHARED_SESSION
Basic Information
Item | Description |
|---|---|
Name | SHARED_SESSION |
Summary | to enable shared session |
Data type | BOOL |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
It sets whether to activate shared mode. If the value is set to NO, load-balancer (gbalancer), dispatcher (gdispatcher), shared-server (gserver) are not executed.
SNAPSHOT_STATEMENT_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | SNAPSHOT_STATEMENT_TIMEOUT |
Summary | snapshot statement timeout (s) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 22118400 (1 year) |
Default value | 22118400 (1 year) |
Description
It sets the maximum holding time of the statement required for the snapshot read. TIMEOUT error occurs for a snapshot statement which exceeds the time.
SQL_HISTORY_SIZE
Basic Information
Item | Description |
|---|---|
Name | SQL_HISTORY_SIZE |
Summary | history size for SQLs |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 100000 |
Default value | 0 |
Description
It is the history size for SQLs.
SQL_HISTORY_TYPE
Basic Information
Item | Description |
|---|---|
Name | SQL_HISTORY_TYPE |
Summary | history type for SQLs |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 2 |
Default value | 0 |
Description
It is the history type for SQLs.
0: Direct-execute
1: Prepare-execute
2: All
SUPPLEMENTAL_LOG_DATA_PRIMARY_KEY
Basic Information
Item | Description |
|---|---|
Name | SUPPLEMENTAL_LOG_DATA_PRIMARY_KEY |
Summary | supplemental log data of primary key columns be logged in redo log files |
Data type | BOOLEAN |
Applicable phase | MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It records supplemental log for all changes in the database.
SYNC_DISPATCHER_CM_BUFFER_COUNT
Basic Information
Item | Description |
|---|---|
Name | SYNC_DISPATCHER_CM_BUFFER_COUNT |
Summary | communication buffer count for synchronization dispatcher |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 1 |
MAX | 128 |
Default value | 1 |
Description
It specifies the number of cluster synchronization dispatcher's communication buffers.
SYSTEM_DISK_DATA_TABLESPACE_SIZE
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_DISK_DATA_TABLESPACE_SIZE |
Summary | default system disk data tablespace size(byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | 32 Mega |
MAX | 30 Giga |
Default value | 200 Mega |
Description
It sets the initial DISK_DATA_TBS tablespace size when creating the database.
SYSTEM_FILE_IO
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_FILE_IO |
Summary | i/o type for system file ( 0: direct io, 1: buffered io ) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
It sets IO type of when using the database file except for the data file and the log file.
SYSTEM_MEMORY_AUX_TABLESPACE_SIZE
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_MEMORY_AUX_TABLESPACE_SIZE |
Summary | default system memory auxiliary tablespace size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | 32 Mega |
MAX | 30 Giga |
Default value | 200 Mega |
Description
It determines the size of initial MEM_AUX_TBS tablespace when creating the database.
SYSTEM_MEMORY_DATA_TABLESPACE_SIZE
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_MEMORY_DATA_TABLESPACE_SIZE |
Summary | default system memory data tablespace size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | 32 Mega |
MAX | 30 Giga |
Default value | 200 Mega |
Description
It determines the initial tablespace size of MEM_DATA_TBS when creating database.
SYSTEM_MEMORY_DICT_TABLESPACE_SIZE
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_MEMORY_DICT_TABLESPACE_SIZE |
Summary | default dictionary tablespace size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | 256 Mega |
MAX | 30 Giga |
Default value | 256 Mega |
Description
It determines the initial tablespace size of DICTIONARY_TBS when creating database.
SYSTEM_MEMORY_TEMP_TABLESPACE_SIZE
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_MEMORY_TEMP_TABLESPACE_SIZE |
Summary | default system memory temporary tablespace size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | 32 Mega |
MAX | 30 Giga |
Default value | 200 Mega |
Description
It determines the initial tablespace size of MEM_TEMP_TBS when creating database.
SYSTEM_MEMORY_UNDO_TABLESPACE_SIZE
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_MEMORY_UNDO_TABLESPACE_SIZE |
Summary | default system memory undo tablespace size (byte) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | NONE |
MIN | 32 Mega |
MAX | 30 Giga |
Default value | 32 Mega |
Description
It determines the initial tablespace size of MEM_UNDO_TBS when creating database.
SYSTEM_TABLESPACE_DIR
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_TABLESPACE_DIR |
Summary | system tablespace directory |
Data type | VARCHAR |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/db |
Description
It sets the path to which the initial system tablespaces are stored when creating database.
SYSTEM_UDS_DIR
Basic Information
Item | Description |
|---|---|
Name | SYSTEM_UDS_DIR |
Summary | system unix domain socket directory |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | '/tmp' |
Description
It sets a directory on which the unix domain socket file is created. Setting the directory for the unix domain socket except for DB system, such asglsnr, is managed by a separate configuration file. The maximum setting value is 60 bytes. (The maximum size of the absolute path (directory + file name) for the unix domain socket file varies according to OS, but generally it is around 100 bytes.)
TCP_CLIENT_NUMA_NODE
Basic Information
Item | Description |
|---|---|
Name | TCP_CLIENT_NUMA_NODE |
Summary | numa node for TCP clients |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | -1 |
MAX | 63 |
Default value | -1 |
Description
It sets the NUMA node ID to which the client server session is bound. This property is operated when NUMA property is set to on.
TCP_NODELAY
Basic Information
Item | Description |
|---|---|
Name | TCP_NODELAY |
Summary | no delays in buffer flushing within the TCP/IP protocol stack |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
It sets TCP_NODELAY option of the socket when transferring the data to a client in C/S method (TCP socket). Set it to NO when fast latency is not required and reducing the network load is needed.
TEMP_SEGMENT_CACHE_SIZE
Basic Information
Item | Description |
|---|---|
Name | TEMP_SEGMENT_CACHE_SIZE |
Summary | the number of segments to be cached for global temporary tables and indexes in each session |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | DEFERRED |
MIN | 0 |
MAX | 4294967295 |
Default value | 3 |
Description
It sets the number of segments to be cached in a session instead of returning them to a tablespace when dropping a global temporary table or a global temporary index segment. Segments in the segment cache are reused later in a global temporary table or a global temporary index.
0: It does not use a segment cache of a global temporary table or of a global temporary index in a session.
1 ~ 4294967295: It keeps the specific number of segment caches of a global temporary table or a global temporary index in a session.
TEMP_UNDO_ENABLED
Basic Information
Item | Description |
|---|---|
Name | TEMP_UNDO_ENABLED |
Summary | enables writing undo records of global temporary tables to the temp tablespace |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
It defines the location of logging undo records for a global temporary table.
0 (FALSE): It records the undo records in the default undo tablespace of database.
1 (TRUE): It records the undo records in the default temporary tablespace of database.
TIMED_STATISTICS
Basic Information
Item | Description |
|---|---|
Name | TIMED_STATISTICS |
Summary | timed statistics |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 2 |
Default value | 0 |
Description
It is whether to check the wait event. To record the statistics related to wait event on v$system_event, v$session_event and v$session_wait table, set this property.
0: It does not record the statistics.
1: It records the statistics.
2: It records the statistics by using the high precision timer.
TIMER_INTERVAL
Basic Information
Item | Description |
|---|---|
Name | TIMER_INTERVAL |
Summary | timer interval time(us) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 10 |
MAX | 100000 |
Default value | 10000 |
Description
It sets the time interval which is required when the timer thread sets the system time.
TIMEZONE
Basic Information
Item | Description |
|---|---|
Name | TIMEZONE |
Summary | timezone |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | FALSE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | +09:00 |
Description
It is a time zone value of database. It is applied when creating database, and it uses the value of the range from '-14:00' to '+14:00'.
TRACE_ALTER_SYSTEM
Basic Information
Item | Description |
|---|---|
Name | TRACE_ALTER_SYSTEM |
Summary | write trace messages forALTER SYSTEM |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
It records the SQL statements in trace file (<GOLDILOCKS_DATA>/trc/system.trc) when executing ALTER SYSTEM syntax.
Set TRACE_ALTER_SYSTEM property to ON to record system changes.
SELECT inquiry, and execution of INSERT, UPDATE, DELETE syntax have nothing to do with TRACE_ALTER_SYSTEM property, so they do not affect the performance of TRACE_ALTER_SYSTEM.
TRACE_DDL
Basic Information
Item | Description |
|---|---|
Name | TRACE_DDL |
Summary | write trace messages for DDL |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | YES |
Description
When executing DDL, it records the executed SQL statements in trace file (<GOLDILOCKS_DATA>/trc/system.trc).
Set TRACE_ALTER_SYSTEM property to ON to record SQL statements execution such as CREATE/DROP/ALTER table.
TRACE_DDL property affects only to DDL statements. However, it has nothing to do with SELECT inquiry, and execution of INSERT, UPDATE, DELETE syntax. Therefore, it does not affect the performance.
TRACE_LOG_ID
Basic Information
Item | Description |
|---|---|
Name | TRACE_LOG_ID |
Summary | trace log ID |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 100000000 |
Default value | 0 |
Description
The execution plan for the query, and other related information are recorded in the trace file (opt_p[process ID_s [session ID].trc) under the trace directory (<GOLDILOCKS_DATA>/trc/) when processing queries.
To record SQL statement for the query, the execution plan and the execution time, refer to the following flag information.
Information | Flag(on) | Flag(off) |
|---|---|---|
Whether to output the PSM call flow (procedure/function) | 1000000 | 0 |
Whether to output the successful SQL query | 100000 | 0 |
Whether to output the failed SQL query | 10000 | 0 |
Whether to output the execution plan | 1000 | 0 |
Whether to output the execution type (direct/prepare) | 100 | 0 |
Whether to output the bind value | 10 | 0 |
Whether to output the execution time per section | 1 | 0 |
To set it in a form of "output the successful SQL query" + "output the execution plan" + "output the bind value", set the TRACE_LOG_ID value to 101010.
TRACE_LOG_MSGBUF_SIZE
Basic Information
Item | Description |
|---|---|
Name | TRACE_LOG_MSGBUF_SIZE |
Summary | memory buffer size for trace log message |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | 8192 |
MAX | 10485760 |
Default value | 24576 |
Description
It sets the size of the heap memory buffer which is used to configure the log message to be recorded in the trace logfile.
TRACE_LOG_TIME_DETAIL
Basic Information
Item | Description |
|---|---|
Name | TRACE_LOG_TIME_DETAIL |
Summary | detail trace log time |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It sets whether to increase the time accuracy when recording trace log. If the value is ON, it has an accuracy of 1 us. If the value is OFF, it has an accuracy of 10 ms.
TRACE_LOGGER
Basic Information
Item | Description |
|---|---|
Name | TRACE_LOGGER |
Summary | trace log type ( 1:file, 2:file & remote ) |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 2 |
Default value | 1 |
Description
It sets the target on which the trace log is written. If it is 1, then it is recorded in a file, and if it is 2, then it is remotely recorded in a file. When it is remotely written, then it remotely collects trace logs from gtrclogger and records in a file.
TRACE_LOGGER_REMOTE_HOST
Basic Information
Item | Description |
|---|---|
Name | TRACE_LOGGER_REMOTE_HOST |
Summary | remote host for trace logger |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 255255255255 |
Default value | 127000000001 |
Description
It sets the host to which the trace log is remotely transferred by setting TRACE_LOGGER to 2.
TRACE_LOGGER_REMOTE_PORT
Basic Information
Item | Description |
|---|---|
Name | TRACE_LOGGER_REMOTE_PORT |
Summary | remote port for trace logger |
Data type | BIGINT |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1024 |
MAX | 49151 |
Default value | 21470 |
Description
It sets the port to which the trace log is remotely transferred by setting TRACE_LOGGER to 2.
TRACE_LOGIN
Basic Information
Item | Description |
|---|---|
Name | TRACE_LOGIN |
Summary | write login trace messages for user |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It records the related access information in trace file (<GOLDILOCKS_DATA>/trc/login.trc) on login. Set TRACE_LOGIN property to ON to record the related information on login.
TRACE_LONG_RUN_CURSOR
Basic Information
Item | Description |
|---|---|
Name | TRACE_LONG_RUN_CURSOR |
Summary | write trace SQL for cursor life-time over specific time (mili-sec. 0 ~ 10000000) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10000000 |
Default value | 0 |
Description
When cursor life-time is longer than the specified property time, then it records the SQL statement of the cursor in the trace file (<GOLDILOCKS_DATA>/trc/system.trc).
Description of value
Unit: millisecond
Value 0: It does not record information.
Recommended value: 20 (millisecond) or longer
The value of 20 or longer is recommended because the execution time is measured using the time tic in 10 ms period.
Use TRACE_LONG_RUN_TIMER property to increase the precision.
The following is an example of recording the SQL statement whose cursor life-time is longer than 1 second.
gSQL> ALTER SYSTEM SET TRACE_LONG_RUN_CURSOR = 1000;
The following is an example of restoring to the default value.
gSQL> ALTER SYSTEM SET TRACE_LONG_RUN_CURSOR TO DEFAULT;
It is used to trace the user program maintaining the cursor for a long time as follows.
int main()
{
...
EXEC SQL DECLARE cur1 CURSOR FOR SELECT name FROM t1 WHERE pk = :s_id;
EXEC SQL OPEN cur1
EXEC SQL FETCH cur1 INTO :s_name;
...
long_run_user_logic( s_name ); 1 Due to the user logic, ager fails to clean up resources for a long time.
...
EXEC SQL CLOSE cur1;
...
}TRACE_LONG_RUN_SQL
Basic Information
Item | Description |
|---|---|
Name | TRACE_LONG_RUN_SQL |
Summary | write trace for long-run SQL over specific execution time (mili-sec. 0 ~ 10000000) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10000000 |
Default value | 0 |
Description
It records the SQL statement whose execution time is longer than the specified property time in the trace file (<GOLDILOCKS_DATA>/trc/system.trc).
Description of value
Unit: millisecond
Value 0: It does not record information.
Recommended value: 20 (millisecond) or longer
The value of 20 or longer is recommended because the execution time is measured using the time tic in 10 ms period.
Use TRACE_LONG_RUN_TIMER property to increase the precision.
The following is an example of recording the SQL statement whose execution time is longer than 1 second.
gSQL> ALTER SYSTEM SET TRACE_LONG_RUN_SQL = 1000;
The following is an example of restoring to the default value.
gSQL> ALTER SYSTEM SET TRACE_LONG_RUN_SQL TO DEFAULT;
TRACE_LONG_RUN_TIMER
Basic Information
Item | Description |
|---|---|
Name | TRACE_LONG_RUN_TIMER |
Summary | trace long-run timer resolution ( 0: timer thread(10 ms interval), 1: gettimeofday() ) |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
It controls the measurement precision when measuring the execution time of the SQL statement by using the following properties.
Description of value
0: It uses the timer thread whose interval is 10 milliseconds.
1: It measures the time by using gettimeofday() function. In this case, the precision is higher but the system call causes the work load.
TRACE_SYSTEM_DIR
Basic Information
Item | Description |
|---|---|
Name | TRACE_SYSTEM_DIR |
Summary | system logger directory |
Data type | VARCHAR |
Applicable phase | NONE |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | FALSE |
MIN | N/A |
MAX | N/A |
Default value | <GOLDILOCKS_DATA>/trc |
Description
It sets the disk path where the trace log message is recorded.
ALIAS
Item | Description |
|---|---|
Original name | TRACE_SYSTEM_DIR |
ALIAS | SYSTEM_LOGGER_DIR |
TRACE_XA
Basic Information
Item | Description |
|---|---|
Name | TRACE_XA |
Summary | logging trace log for xa interfaces |
Data type | BOOLEAN |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | NO |
Description
It specifies whether to output trace messages when using XA interface. Message is output to the 'SYSTEM_LOGGER_DIR / xa.trc'.
TRANSACTION_ALLOCATION_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | TRANSACTION_ALLOCATION_TIMEOUT |
Summary | a time limit (sec) for allocating transaction slot |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 100000000 |
Default value | 3 |
Description
It is the maximum waiting time when allocating transaction slots.
The following error occurs when the waiting time exceeds TRANSACTION_ALLOCATION_TIMEOUT.
gSQL> insert into t1 values(1); ERR-HYT00(14129): transaction allocation time exceeded
TRANSACTION_COMMIT_WRITE_MODE
Basic Information
Item | Description |
|---|---|
Name | TRANSACTION_COMMIT_WRITE_MODE |
Summary | transaction commit write mode (0: no_wait, 1: wait) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 1 |
Default value | 0 |
Description
TRANSACTION_COMMIT_WRITE_MODE specifies whether a log generated by the transaction is flushed to the disk log file, when the transaction is committed. If TRANSACTION_COMMIT_WRITE_MODE is '1', the log should be flushed to the disk log file at the time of the transaction commit. Otherwise the transaction is committed regardless of log flush.
If the system is operated when TRANSACTION_COMMIT_WRITE_MODE is set to '0', the latest data will be lost when GOLDILOCKS is abnormally terminated without log flush after COMMIT transaction. It is because the logs are not recorded in this case.
Therefore, if all committed transactions should be remained (stored) in database, the system should be operated after setting TRANSACTION_COMMIT_WRITE_MODE to '1'. Or, 'ALTER SYSTEM FLUSH LOGS' statement should be explicitly performed at the time of transaction commit in order to flush log after TRANSACTION_COMMIT_WRITE_MODE is set to '0'.
0: no wait
1: wait
TRANSACTION_MAXIMUM_UNDO_PAGE_COUNT
Basic Information
Item | Description |
|---|---|
Name | TRANSACTION_MAXIMUM_UNDO_PAGE_COUNT |
Summary | The maximum number of undo pages that a transaction can write. |
Data type | BIGINT |
Applicable phase | NO MOUNT or below |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1 |
MAX | 13107200 |
Default value | 13107200 |
Description
It means the maximum number of undo pages which the transaction can record. The minimum value is 1 (8 Kbytes) and the maximum value is 13107200 (100 Gbytes).
TRANSACTION_TABLE_SIZE
Basic Information
Item | Description |
|---|---|
Name | TRANSACTION_TABLE_SIZE |
Summary | transaction table size |
Data type | BIGINT |
Applicable phase | NO MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 64 |
MAX | 10240 |
Default value | 1024 |
Description
It sets the maximum number of transaction tables which are executed in database. The database should restart to modify the number of transaction tables, and the number can be modified as long as the number is bigger than the previously specified number. However, if it is modified to the smaller number, then the restart fails when it is same or smaller than the maximum value of the transaction slot identifier used by the transactions prepared after the restart recovery.
For example, if the value set as 1,024 is modified to 512 and the maximum value of the transaction slot identifier used by the transactions prepared at the restart is also 512, then the restart fails as follows. In this case, modify it to the number bigger than 512, then the restart succeeds.
gSQL> ALTER SYSTEM SET TRANSACTION_TABLE_SIZE = 512 SCOPE = FILE; System altered. gSQL> \CONNECT sys gliese as sysdba gSQL> \SHUTDOWN Shutdown success
The restart fails.
gSQL> \STARTUP ERR-HY000(14118): TRANSACTION_TABLE_SIZE property value must be equal to or greater than '513' gSQL> ALTER SYSTEM SET TRANSACTION_TABLE_SIZE = 513 SCOPE = FILE; System altered. gSQL> \SHUTDOWN Shutdown success gSQL> \STARTUP Startup success
TRANSACTION_TABLE_SIZE of all cluster members should be same in cluster environment, so it is required to restart all cluster members to modify TRANSACTION_TABLE_SIZE.
TRANSACTION_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | TRANSACTION_TIMEOUT |
Summary | transaction timeout (s) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 10000000 |
Default value | 0 |
Description
It sets the duration of when the transaction is activated. It is used to prevent the side effects of when the transaction is activated for a long time. If a transaction exceeds the specified time, then gmaster daemon automatically terminates the session owned by that transaction.
UNDO_RELATION_ALLOCATION_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | UNDO_RELATION_ALLOCATION_TIMEOUT |
Summary | a time limit (sec) for allocating undo relation |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 100000000 |
Default value | 3 |
Description
It is the maximum waiting time when allocating undo relations.
The following error occurs when the waiting time exceeds UNDO_RELATION_ALLOCATION_TIMEOUT.
gSQL> insert into t1 values(1); ERR-HYT00(14130): undo relation allocation time exceeded
UNDO_RELATION_COUNT
Basic Information
Item | Description |
|---|---|
Name | UNDO_RELATION_COUNT |
Summary | undo relation count |
Data type | BIGINT |
Applicable phase | NO MOUNT or below |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 8 |
MAX | 10240 |
Default value | 128 |
Description
It sets the number of undo relation to be used in database. Undo relation is allocated for the purpose that the transaction executing DML uses undo segment. The database should restart to modify the number of undo relations, and the number can be modified only to the number bigger than the previously specified number.
If it is modified to a smaller number, then the restart fails. For example, if the value set as 128 is modified to 64, then the restart fails as follows. In this case, modify it to 128 or bigger, then the restart succeeds.
gSQL> ALTER SYSTEM SET UNDO_RELATION_COUNT = 64 SCOPE = FILE; System altered. gSQL> \CONNECT sys gliese as sysdba gSQL> \SHUTDOWN Shutdown success
The restart fails.
gSQL> \STARTUP ERR-HY000(14119): UNDO_RELATION_COUNT property value must be equal to or greater than '128' gSQL> ALTER SYSTEM SET UNDO_RELATION_COUNT = 128 SCOPE = FILE; System altered. gSQL> \SHUTDOWN Shutdown success gSQL> \STARTUP Startup success
UNDO_SHRINK_THRESHOLD
Basic Information
Item | Description |
|---|---|
Name | UNDO_SHRINK_THRESHOLD |
Summary | threshold bytes to attempt to shrink undo segment (byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 1048576 |
MAX | 107374182400 |
Default value | 10485760 |
Description
Ager thread periodically (10 seconds) checks the undo segment space. If it occupies more space than this property value, then the reusable space is returned to the tablespace. The attempt to return is made until the undo segment space remains as big as this property (byte), and the return is finished when the amount of the remaining undo page becomes smaller than MINIMUM_UNDO_PAGE_COUNT.
USE_LARGE_PAGES
Basic Information
Item | Description |
|---|---|
Name | USE_LARGE_PAGES |
Summary | use large pages |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 |
MAX | 2 |
Default value | 0 |
Description
It uses HugePage. HugePage should first be set in the device to use USE_LARGE_PAGES property.
0: It does not use the large page.
1: It uses the large page. When it fails to allocate the shared memory, then an error occurs.
2: It tries to allocate the shared memory by using the large page. When it fails to allocate the shared memory, then it allocates the memory by using the regular page.
It can be used in Linux kernel 2.6.32-573 or higher.
USER_DATA_TABLESPACE_MEDIA_TYPE
Basic Information
Item | Description |
|---|---|
Name | USER_DATA_TABLESPACE_MEDIA_TYPE |
Summary | default media type of user data tablespace |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 ( Memory ) |
MAX | 1 ( Disk ) |
Default value | 0 ( Memory ) |
Description
It sets the default media type if the media type of the tablespace is omitted when creating the user data tablespace. 0 is memory and 1 is the disk.
USER_DATA_TABLESPACE_SIZE
Basic Information
Item | Description |
|---|---|
Name | USER_DATA_TABLESPACE_SIZE |
Summary | default user data tablespace size(byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 32 Mega |
MAX | 30 Giga |
Default value | 32 Mega |
Description
It sets the default size if the data file size is omitted when creating the user data tablespace or adding the data file.
USER_DISK_DATA_TABLESPACE_NEXTSIZE
Basic Information
Item | Description |
|---|---|
Name | USER_DISK_DATA_TABLESPACE_NEXTSIZE |
Summary | default next size of user data tablespace |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 3554432 Byte |
MAX | 30 Giga |
Default value | 10 Mega |
Description
It sets the default size if the size to be extended is not set when it is required to extend the data file of the user disk data tablespace.
USER_TEMP_TABLESPACE_SIZE
Basic Information
Item | Description |
|---|---|
Name | USER_TEMP_TABLESPACE_SIZE |
Summary | default user temp tablespace size(byte) |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | TRUE |
ALTER SYSTEM | IMMEDIATE |
MIN | 32 Mega |
MAX | 30 Giga |
Default value | 32 Mega |
Description
It sets the default size if the data file size is omitted when creating the user temp tablespace or adding the data file.
XA_TRANSACTION_IDLE_TIMEOUT
Basic Information
Item | Description |
|---|---|
Name | XA_TRANSACTION_IDLE_TIMEOUT |
Summary | idle timeout for xa transaction |
Data type | BIGINT |
Applicable phase | NO MOUNT or above |
Updatable | TRUE |
ALTER SESSION | FALSE |
ALTER SYSTEM | IMMEDIATE |
MIN | 0 ( no limit ) |
MAX | 10000000 |
Default value | 60 |
Description
It is the maximum waiting time of xa transaction in idle (The duration between the beginning of XA and the next transaction). If it remains in Idle exceeding this time, then xa transaction is rolled back.
If it is set to 0, then XA infinitely waits even in idle.