2. Altibase Properties#
Altibase server can be run in various modes. The altibase.properties file is used to set Altibase server environment settings. The altibase.properties file contains all elements related to the operation and adjustment of the Altibase server.
This chapter describes the Altibase properties that need to be set and managed to configure and operate Altibase as a database suitable for the user's purposes.
Configuration#
There are three ways to set Altibase server environment settings.
The first method involves making changes to the Altibase properties file, which is located at $ALTIBASE_HOME/conf/altibase.properties. Because this method of configuration is static, meaning that changes can only be made while Altibase is not running, the Altibase instance must be restarted in order for the changes to the properties file to take effect.
The second method is dynamic, meaning that configuration changes can be made even while Altibase server is running. Although this method confers the advantage of being able to make and apply changes without shutting down the server, it is not possible for all properties. For properties that can be dynamically changed, the ALTER SYSTEM or ALTER SESSION statements can be used to apply the configuration changes to the entire Altibase server or to individual sessions, respectively.
The third method of configuring the Altibase environment is through the use of operating system environment variables. Like the method involving the altibase.properties file, this configuration method is also static. Properties that are read-only or that can only have a single value can be set in this way. After specifying the environment variable as ALTIBASE_property_name, it will be necessary to reboot the database server in order to implement the changes.
Here is an example.
$ export ALTIBASE_DEFAULT_DATE_FORMAT=YYYY/MM/DD
The precedence of the property-setting methods is as follows:
- Environment variable settings
- altibase.properties file settings
- Default system values
As can be seen in the following example, when properties are set, because environment variables take highest precedence, the value of DEFAULT_DATE_FORMAT in the altibase.properties file is ignored, and the value of the environment variable is used.
$ export ALTIBASE_DEFAULT_DATE_FORMAT=YYYY-MM-DD
DEFAULT_DATE_FORMAT=YYYY-MM-DD (altibase.properties)
Similarly, in the following example, NLS_USE in the altibase.properties file is ignored, and UTF-8, which is specified by the NLS_USE environment variable, is used, because environment variables have the highest priority.
$ export ALTIBASE_NLS_USE=UTF8
NLS_USE=KO16KSC5601 (altibase.properties)
Properties Overview#
The property file for configuring the Altibase server is called "altibase.properties" and is located in the conf subdirectory of ALTIBASE_HOME. The properties therein are broadly grouped as follows:
- Database initialization properties
- Performance properties
- Session properties
- Transaction properties
- Backup and recovery properties
- Replication properties
- Network and security properties
- Message logging properties
- Database link properties
- Auditing properties
- C/C++ external procedure agent properties
- User account security properties
- Other properties
The following table lists all Altibase properties. For reference, each group in the table has the following meaning:
- D: Database initialization properties
- P: Performance properties
- S: Session properties
- T: Transaction properties
- B: Backup and recovery properties
- R: Replication properties
- NM: Network Management and security properties
- M: Message logging properties
- L: Database link properties
- U: Auditing properties
- A: C/C++ external procedure agent properties
- AS: Account Security properties
- E: Other properties
The values in the "Alter Level" column have the following meaning:
-
SESSION: the property can be changed using an ALTER SESSION statement.
-
SYSTEM: the property can be changed using an ALTER SYSTEM statement.
-
BOTH: the property can be changed using either an ALTER SESSION or an ALTER SYSTEM statement
-
NONE: Cannot be changed
| Group | Class | Property Name | Alter Level |
|---|---|---|---|
| D | BUFFER_AREA_CHUNK_SIZE | ||
| BUFFER_AREA_SIZE | SYSTEM | ||
| BUFFER_CHECKPOINT_LIST_CNT | |||
| BUFFER_FLUSHER_CNT | |||
| BUFFER_FLUSH_LIST_CNT | |||
| BUFFER_HASH_BUCKET_DENSITY | |||
| BUFFER_HASH_CHAIN_LATCH_DENSITY | |||
| BUFFER_LRU_LIST_CNT | |||
| BUFFER_PREPARE_LIST_CNT | |||
| COMPRESSION_RESOURCE_GC_SECOND | |||
| DB_NAME | |||
| DDL_SUPPLEMENTAL_LOG_ENABLE | SYSTEM | ||
| DEFAULT_DISK_DB_DIR | |||
| DEFAULT_MEM_DB_FILE_SIZE | |||
| DEFAULT_SEGMENT_MANAGEMENT_TYPE | |||
| DEFAULT_SEGMENT_STORAGE_INITEXTENTS | |||
| DEFAULT_SEGMENT_STORAGE_MAXEXTENTS | |||
| DEFAULT_SEGMENT_STORAGE_MINEXTENTS | |||
| DEFAULT_SEGMENT_STORAGE_NEXTEXTENTS | |||
| DIRECT_PATH_BUFFER_PAGE_COUNT | SYSTEM | ||
| DISK_INDEX_UNBALANCED_SPLIT_RATE | SYSTEM | ||
| DISK_LOB_COLUMN_IN_ROW_SIZE | |||
| DISK_MAX_DB_SIZE | |||
| DOUBLE_WRITE_DIRECTORY | |||
| DOUBLE_WRITE_DIRECTORY_COUNT | |||
| DRDB_FD_MAX_COUNT_PER_DATAFILE | SYSTEM | ||
| EXPAND_CHUNK_PAGE_COUNT | |||
| LOB_OBJECT_BUFFER_SIZE | |||
| LOCK_MGR_CACHE_NODE | |||
| LOCK_NODE_CACHE_COUNT | |||
| LOGANCHOR_DIR | |||
| LOG_DIR | |||
| LOG_FILE_SIZE | |||
| MAX_CLIENT | |||
| MEM_DB_DIR | |||
| MEM_MAX_DB_SIZE | |||
| MEMORY_INDEX_BUILD_RUN_SIZE | SYSTEM | ||
| MEMORY_INDEX_BUILD_VALUE_LENGTH_THRESHOLD | SYSTEM | ||
| MEMORY_INDEX_UNBALANCED_SPLIT_RATE | SYSTEM | ||
| MEMORY_LOB_COLUMN_IN_ROW_SIZE | |||
| MEMORY_VARIABLE_COLUMN_IN_ROW_SIZE | |||
| MEM_SIZE_CLASS_COUNT | |||
| MIN_COMPRESSION_RESOURCE_COUNT | |||
| MIN_LOG_RECORD_SIZE_FOR_COMPRESS | SYSTEM | ||
| MIN_PAGES_ON_DB_FREE_LIST | |||
| MIN_PAGES_ON_TABLE_FREE_LIST | SYSTEM | ||
| MIN_TASK_COUNT_FOR_THREAD_LIVE | SYSTEM | ||
| PCTFREE | |||
| PCTUSED | |||
| QP_MEMORY_CHUNK_SIZE | |||
| RECYCLEBIN_DISK_MAX_SIZE | SYSTEM | ||
| RECYCLEBIN_ENABLE | SESSION | ||
| RECYCLEBIN_MEM_MAX_SIZE | SYSTEM | ||
| REDUCE_TEMP_MEMORY_ENABLE | SYSTEM | ||
| SECURITY_ECC_POLICY_NAME | SYSTEM | ||
| SECURITY_MODULE_LIBRARY | SYSTEM | ||
| SECURITY_MODULE_NAME | SYSTEM | ||
| SERVICE_THREAD_INITIAL_LIFESPAN | SYSTEM | ||
| SMALL_TABLE_THRESHOLD | SYSTEM | ||
| ST_OBJECT_BUFFER_SIZE | BOTH | ||
| SYS_DATA_FILE_INIT_SIZE | |||
| SYS_DATA_FILE_MAX_SIZE | |||
| SYS_DATA_FILE_NEXT_SIZE | |||
| SYS_DATA_TBS_EXTENT_SIZE | |||
| SYS_TEMP_FILE_INIT_SIZE | |||
| SYS_TEMP_FILE_MAX_SIZE | |||
| SYS_TEMP_FILE_NEXT_SIZE | |||
| SYS_TEMP_TBS_EXTENT_SIZE | |||
| SYS_UNDO_FILE_INIT_SIZE | |||
| SYS_UNDO_FILE_MAX_SIZE | |||
| SYS_UNDO_FILE_NEXT_SIZE | |||
| SYS_UNDO_TBS_EXTENT_SIZE | |||
| TABLE_BACKUP_FILE_BUFFER_SIZE | |||
| TABLE_COMPACT_AT_SHUTDOW | SYSTEM | ||
| TEMP_HASH_BUCKET_DENSITY | |||
| TEMP_PAGE_CHUNK_COUNT | |||
| USER_DATA_FILE_INIT_SIZE | |||
| USER_DATA_FILE_MAX_SIZE | |||
| USER_DATA_FILE_NEXT_SIZE | |||
| USER_DATA_TBS_EXTENT_SIZE | |||
| USER_TEMP_FILE_INIT_SIZE | |||
| USER_TEMP_FILE_MAX_SIZE | |||
| USER_TEMP_FILE_NEXT_SIZE | |||
| USER_TEMP_TBS_EXTENT_SIZE | |||
| VOLATILE_MAX_DB_SIZE | |||
| P | AGER_WAIT_MAXIMUM | ||
| AGER_WAIT_MINIMUM | |||
| BUFFER_VICTIM_SEARCH_INTERVAL | SYSTEM | ||
| BUFFER_VICTIM_SEARCH_PCT | SYSTEM | ||
| BULKIO_PAGE_COUNT_FOR_DIRECT_PATH_INSERT | SYSTEM | ||
| CHECKPOINT_BULK_SYNC_PAGE_COUNT | SYSTEM | ||
| CHECKPOINT_BULK_WRITE_PAGE_COUNT | SYSTEM | ||
| CHECKPOINT_BULK_WRITE_SLEEP_SEC | SYSTEM | ||
| CHECKPOINT_BULK_WRITE_SLEEP_USEC | SYSTEM | ||
| CHECKPOINT_FLUSH_COUNT | SYSTEM | ||
| CHECKPOINT_FLUSH_MAX_GAP | SYSTEM | ||
| CHECKPOINT_FLUSH_MAX_WAIT_SEC | SYSTEM | ||
| CM_BUFFER_MAX_PENDING_LIST | |||
| CM_DISPATCHER_SOCK_POLL_TYPE | |||
| DATABASE_IO_TYPE | |||
| DATAFILE_WRITE_UNIT_SIZE | SYSTEM | ||
| DB_FILE_MULTIPAGE_READ_COUNT | SYSTEM | ||
| DEDICATED_THREAD_CHECK_INTERVAL | |||
| DEDICATED_THREAD_INIT_COUNT | |||
| DEDICATED_THREAD_MAX_COUNT | |||
| DEDICATED_THREAD_MODE | |||
| DEFAULT_FLUSHER_WAIT_SEC | SYSTEM | ||
| DELAYED_FLUSH_LIST_PCT | SYSTEM | ||
| DELAYED_FLUSH_PROTECTION_TIME_MSEC | SYSTEM | ||
| DIRECT_IO_ENABLED | |||
| DISK_INDEX_BUILD_MERGE_PAGE_COUNT | SYSTEM | ||
| EXECUTE_STMT_MEMORY_MAXIMUM | SYSTEM | ||
| EXECUTOR_FAST_SIMPLE_QUERY | |||
| FAST_START_IO_TARGET | SYSTEM | ||
| FAST_START_LOGFILE_TARGET | SYSTEM | ||
| FAST_UNLOCK_LOG_ALLOC_MUTEX | |||
| HASH_AREA_SIZE | SYSTEM | ||
| HASH_JOIN_MEM_TEMP_AUTO_BUCKET_COUNT_DISABLE | SYSTEM | ||
| HASH_JOIN_MEM_TEMP_PARTITIONING_DISABLE | SYSTEM | ||
| HIGH_FLUSH_PCT | SYSTEM | ||
| HOT_LIST_PCT | SYSTEM | ||
| HOT_TOUCH_CNT | SYSTEM | ||
| INDEX_BUILD_THREAD_COUNT | SYSTEM | ||
| INDEX_INITRANS | |||
| INDEX_MAXTRANS | |||
| LFG_GROUP_COMMIT_INTERVAL_USEC | |||
| LFG_GROUP_COMMIT_RETRY_USEC | |||
| LFG_GROUP_COMMIT_UPDATE_TX_COUNT | |||
| LOB_CACHE_THRESHOLD | BOTH | ||
| LOCK_ESCALATION_MEMORY_SIZE | SYSTEM | ||
| LOG_CREATE_METHOD | |||
| LOG_IO_TYPE | |||
| LOW_FLUSH_PCT | SYSTEM | ||
| LOW_PREPARE_PCT | SYSTEM | ||
| MATHEMATICS_TEMP_MEMORY_MAXIMUM | SYSTEM | ||
| MAX_FLUSHER_WAIT_SEC | SYSTEM | ||
| MEM_INDEX_KEY_REDISTRIBUTION | SYSTEM | ||
| MEM_INDEX_KEY_REDISTRIBUTION_STANDARD_RATE | SYSTEM | ||
| MULTIPLEXING_CHECK_INTERVAL | SYSTEM | ||
| MULTIPLEXING_MAX_THREAD_COUNT | SYSTEM | ||
| MULTIPLEXING_THREAD_COUNT | |||
| NORMALFORM_MAXIMUM | BOTH | ||
| OPTIMIZER_AUTO_STATS | BOTH | ||
| OPTIMIZER_DELAYED_EXECUTION | SESSION | ||
| OPTIMIZER_FEATURE_ENABLE | SYSTEM | ||
| OPTIMIZER_MODE | BOTH | ||
| OPTIMIZER_PERFORMANCE_VIEW | |||
| OPTIMIZER_UNNEST_AGGREGATION_SUBQUERY | SYSTEM | ||
| OPTIMIZER_UNNEST_COMPLEX_SUBQUERY | SYSTEM | ||
| OPTIMIZER_UNNEST_SUBQUERY | SYSTEM | ||
| OUTER_JOIN_OPERATOR_TRANSFORM_ENABLE | SYSTEM | ||
| PARALLEL_LOAD_FACTOR | |||
| PARALLEL_QUERY_THREAD_MAX | SYSTEM | ||
| PARALLEL_QUERY_QUEUE_SIZE | SYSTEM | ||
| PREPARE_STMT_MEMORY_MAXIMUM | SYSTEM | ||
| QUERY_REWRITE_ENABLE | BOTH | ||
| REFINE_PAGE_COUNT | |||
| RESULT_CACHE_ENABLE | BOTH | ||
| RESULT_CACHE_MEMORY_MAXIMUM | SYSTEM | ||
| SECONDARY_BUFFER_ENABLE | |||
| SECONDARY_BUFFER_FILE_DIRECTORY | |||
| SECONDARY_BUFFER_FLUSHER_CNT | |||
| SECONDARY_BUFFER_SIZE | |||
| SECONDARY_BUFFER_TYPE | |||
| SORT_AREA_SIZE | SYSTEM | ||
| SQL_PLAN_CACHE_BUCKET_CNT | |||
| SQL_PLAN_CACHE_HOT_REGION_LRU_RATIO | SYSTEM | ||
| SQL_PLAN_CACHE_PREPARED_EXECUTION_CONTEXT_CNT | SYSTEM | ||
| SQL_PLAN_CACHE_SIZE | SYSTEM | ||
| STATEMENT_LIST_PARTIAL_SCAN_COUNT | SYSTEM | ||
| TABLE_INITRANS | |||
| TABLE_LOCK_ENABLE | SYSTEM | ||
| TABLE_LOCK_MODE | |||
| TABLE_MAXTRANS | |||
| TABLESPACE_LOCK_ENABLE | BOTH | ||
| TEMP_MAX_PAGE_COUNT | SYSTEM | ||
| TEMP_STATS_WATCH_TIME | SYSTEM | ||
| THREAD_CPU_AFFINITY | |||
| THREAD_REUSE_ENABLE | |||
| TIMED_STATISTICS | SYSTEM | ||
| TIMER_RUNNING_LEVEL | |||
| TIMER_THREAD_RESOLUTION | SYSTEM | ||
| TOP_RESULT_CACHE_MODE | BOTH | ||
| SYSTEM | |||
| TOUCH_TIME_INTERVAL | SYSTEM | ||
| TRANSACTION_SEGMENT_COUNT | SYSTEM | ||
| TRX_UPDATE_MAX_LOGSIZE | BOTH | ||
| S | Normal | CM_DISCONN_DETECT_TIME | |
| CONCURRENT_EXEC_DEGREE_DEFAULT | SYSTEM | ||
| CONCURRENT_EXEC_DEGREE_MAX | |||
| CONCURRENT_EXEC_WAIT_INTERVAL | SYSTEM | ||
| DEFAULT_THREAD_STACK_SIZE | |||
| IPC_CHANNEL_COUNT | |||
| IPC_FILEPATH | |||
| IPCDA_CHANNEL_COUNT | |||
| IPCDA_DATABLOCK_SIZE | SYSTEM | ||
| IPCDA_FILEPATH | |||
| MAX_LISTEN | |||
| MAX_STATEMENTS_PER_SESSION | BOTH | ||
| NET_CONN_IP_STACK | |||
| NLS_COMP | |||
| NLS_CURRENCY | SESSION | ||
| NLS_ISO_CURRENCY | SESSION | ||
| NLS_NCHAR_CONV_EXCP | SESSION | ||
| NLS_NCHAR_LITERAL_REPLACE | SESSION | ||
| NLS_NUMERIC_CHARACTERS | SESSION | ||
| NLS_TERRITORY | SESSION | ||
| PORT_NO | |||
| PSM_CURSOR_OPEN_LIMIT | SYSTEM | ||
| PSM_FILE_OPEN_LIMIT | SYSTEM | ||
| TIME_ZONE | SESSION | ||
| UNIXDOMAIN_FILEPATH | |||
| USE_MEMORY_POOL | |||
| USER_LOCK_POOL_INIT_SIZE | SYSTEM | ||
| USER_LOCK_REQUEST_CHECK_INTERVAL | SYSTEM | ||
| USER_LOCK_REQUEST_LIMIT | SYSTEM | ||
| USER_LOCK_REQUEST_TIMEOUT | SYSTEM | ||
| XA_HEURISTIC_COMPLETE | |||
| Time-Out | BLOCK_ALL_TX_TIME_OUT | SYSTEM | |
| DDL_LOCK_TIMEOUT | SYSTEM | ||
| DDL_TIMEOUT | BOTH | ||
| FETCH_TIMEOUT | BOTH | ||
| IDLE_TIMEOUT | BOTH | ||
| LOGIN_TIMEOUT | SYSTEM | ||
| MULTIPLEXING_POLL_TIMEOUT | SYSTEM | ||
| QUERY_TIMEOUT | BOTH | ||
| SHUTDOWN_IMMEDIATE_TIMEOUT | SYSTEM | ||
| UTRANS_TIMEOUT | BOTH | ||
| XA_INDOUBT_TX_TIMEOUT | |||
| T | AUTO_COMMIT | SYSTEM | |
| ISOLATION_LEVEL | |||
| TRANSACTION_TABLE_SIZE | |||
| B | ARCHIVE_DIR | ||
| ARCHIVE_FULL_ACTION | |||
| ARCHIVE_MULTIPLEX_COUNT | |||
| ARCHIVE_MULTIPLEX_DIR | |||
| ARCHIVE_THREAD_AUTOSTART | |||
| CHECKPOINT_ENABLED | |||
| CHECKPOINT_INTERVAL_IN_LOG | SYSTEM | ||
| CHECKPOINT_INTERVAL_IN_SEC | SYSTEM | ||
| COMMIT_WRITE_WAIT_MODE | BOTH | ||
| INCREMENTAL_BACKUP_CHUNK_SIZE | |||
| INCREMENTAL_BACKUP_INFO_RETENTION_PERIOD | |||
| LOG_BUFFER_TYPE | |||
| LOG_MULTIPLEX_COUNT | |||
| LOG_MULTIPLEX_DIR | |||
| PREPARE_LOG_FILE_COUNT | |||
| SNAPSHOT_MEM_THRESHOLD | SYSTEM | ||
| SNAPSHOT_DISK_UNDO_THRESHOLD | SYSTEM | ||
| R | REPLICATION_ACK_XLOG_COUNT | ||
| REPLICATION_ALLOW_DUPLICATE_HOSTS | SYSTEM | ||
| REPLICATION_BEFORE_IMAGE_LOG_ENABLE | SYSTEM | ||
| REPLICATION_COMMIT_WRITE_WAIT_MODE | SYSTEM | ||
| REPLICATION_CONNECT_RECEIVE_TIMEOUT | SYSTEM | ||
| REPLICATION_CONNECT_TIMEOUT | SYSTEM | ||
| REPLICATION_DDL_ENABLE | SYSTEM | ||
| REPLICATION_DDL_ENABLE_LEVEL | |||
| REPLICATION_DDL_SYNC | SYSTEM | ||
| REPLICATION_DDL_SYNC_TIMEOUT | |||
| REPLICATION_EAGER_PARALLEL_FACTOR | |||
| REPLICATION_EAGER_RECEIVER_MAX_ERROR_COUNT | SYSTEM | ||
| REPLICATION_FAILBACK_INCREMENTAL_SYNC | |||
| REPLICATION_GAP_UNIT | |||
| REPLICATION_GAPLESS_ALLOW_TIME | SYSTEM | ||
| REPLICATION_GAPLESS_MAX_WAIT_TIME | SYSTEM | ||
| REPLICATION_GROUPING_AHEAD_READ_NEXT_LOG_FILE | SYSTEM | ||
| REPLICATION_GROUPING_TRANSACTION_MAX_COUNT | SYSTEM | ||
| REPLICATION_HBT_DETECT_HIGHWATER_MARK | SYSTEM | ||
| REPLICATION_HBT_DETECT_TIME | SYSTEM | ||
| REPLICATION_IB_LATENCY | |||
| REPLICATION_IB_PORT_NO | |||
| REPLICATION_INSERT_REPLACE | SYSTEM | ||
| REPLICATION_KEEP_ALIVE_CNT | |||
| REPLICATION_LOCK_TIMEOUT | SYSTEM | ||
| REPLICATION_LOG_BUFFER_SIZE | |||
| REPLICATION_MAX_COUNT | |||
| REPLICATION_MAX_LISTEN | |||
| REPLICATION_MAX_LOGFILE | SYSTEM | ||
| REPLICATION_POOL_ELEMENT_COUNT | SYSTEM | ||
| REPLICATION_POOL_ELEMENT_SIZE | SYSTEM | ||
| REPLICATION_PORT_NO | |||
| REPLICATION_RECEIVE_TIMEOUT | SYSTEM | ||
| REPLICATION_RECEIVER_APPLIER_ASSIGN_MODE | SYSTEM | ||
| REPLICATION_RECEIVER_APPLIER_QUEUE_SIZE | SYSTEM | ||
| REPLICATION_PREFETCH_LOGFILE_COUNT | SYSTEM | ||
| REPLICATION_RECOVERY_MAX_LOGFILE | |||
| REPLICATION_RECOVERY_MAX_TIME | |||
| REPLICATION_SENDER_AUTO_START | |||
| REPLICATION_SENDER_COMPRESS_XLOG | SYSTEM | ||
| REPLICATION_SENDER_ENCRYPT_XLOG | |||
| REPLICATION_SENDER_SEND_TIMEOUT | SYSTEM | ||
| REPLICATION_SENDER_SLEEP_TIME | |||
| REPLICATION_SENDER_SLEEP_TIMEOUT | SYSTEM | ||
| REPLICATION_SENDER_START_AFTER_GIVING_UP | SYSTEM | ||
| REPLICATION_SERVER_FAILBACK_MAX_TIME | |||
| REPLICATION_SQL_APPLY_ENABLE | |||
| REPLICATION_SYNC_APPLY_METHOD | SYSTEM | ||
| REPLICATION_SYNC_LOCK_TIMEOUT | SYSTEM | ||
| REPLICATION_SYNC_LOG | |||
| REPLICATION_SYNC_TUPLE_COUNT | SYSTEM | ||
| REPLICATION_TIMESTAMP_RESOLUTION | SYSTEM | ||
| REPLICATION_TRANSACTION_POOL_SIZE | SYSTEM | ||
| REPLICATION_UPDATE_REPLACE | SYSTEM | ||
| NM | IB_CONCHKSPIN | ||
| IB_ENABLE | |||
| IB_LATENCY | |||
| IB_LISTEN_DISABLE | |||
| IB_MAX_LISTEN | |||
| IB_PORT_NO | SYSTEM | ||
| SNMP_ALARM_QUERY_TIMEOUT | |||
| SNMP_ALARM_FETCH_TIMEOUT | |||
| SNMP_ALARM_UTRANS_TIMEOUT | |||
| SNMP_ALARM_SESSION_FAILURE_COUNT | |||
| SNMP_ENABLE | |||
| SNMP_MSGLOG_FLAG | SYSTEM | ||
| SNMP_PORT_NO | |||
| SNMP_TRAP_PORT_NO | |||
| SNMP_RECV_TIMEOUT | |||
| SNMP_SEND_TIMEOUT | |||
| SSL_CA | |||
| SSL_CAPATH | |||
| SSL_CERT | |||
| SSL_CIPHER_LIST | |||
| SSL_CLIENT_AUTHENTICATION | |||
| SSL_ENABLE | |||
| SSL_KEY | |||
| SSL_MAX_LISTEN | |||
| SSL_PORT_NO | SYSTEM | ||
| TCP_ENABLE | |||
| M | ALL_MSGLOG_FLUSH | SYSTEM | |
| COLLECT_DUMP_INFO | SYSTEM | ||
| DK_MSGLOG_COUNT | |||
| DK_MSGLOG_FILE | |||
| DK_MSGLOG_FLAG | SYSTEM | ||
| DK_MSGLOG_RESERVE_SIZE | |||
| DK_MSGLOG_SIZE | |||
| DUMP_MSGLOG_COUNT | |||
| DUMP_MSGLOG_SIZE | |||
| DUMP_MSGLOG_RESERVE_SIZE | |||
| ERROR_MSGLOG_COUNT | |||
| ERROR_MSGLOG_FILE | |||
| ERROR_MSGLOG_SIZE | |||
| ERROR_MSGLOG_RESERVE_SIZE | |||
| LB_MSGLOG_COUNT | |||
| LB_MSGLOG_FILE | |||
| LB_MSGLOG_FLAG | |||
| LB_MSGLOG_SIZE | |||
| MM_MSGLOG_COUNT | |||
| MM_MSGLOG_FILE | |||
| MM_MSGLOG_RESERVE_SIZE | |||
| MM_MSGLOG_SIZE | |||
| MM_SESSION_LOGGING | SYSTEM | ||
| NETWORK_ERROR_LOG | SYSTEM | ||
| QP_MSGLOG_COUNT | |||
| QP_MSGLOG_FILE | |||
| QP_MSGLOG_FLAG | SYSTEM | ||
| QP_MSGLOG_RESERVE_SIZE | |||
| QP_MSGLOG_SIZE | |||
| QUERY_PROF_FLAG | SYSTEM | ||
| QUERY_PROF_LOG_DIR | SYSTEM | ||
| RP_CONFLICT_MSGLOG_COUNT | |||
| RP_CONFLICT_MSGLOG_DIR | |||
| RP_CONFLICT_MSGLOG_ENABLE | |||
| RP_CONFLICT_MSGLOG_FILE | |||
| RP_CONFLICT_MSGLOG_FLAG | SYSTEM | ||
| RP_CONFLICT_MSGLOG_SIZE | |||
| RP_MSGLOG_COUNT | |||
| RP_MSGLOG_FILE | |||
| RP_MSGLOG_FLAG | SYSTEM | ||
| RP_MSGLOG_RESERVE_SIZE | |||
| RP_MSGLOG_SIZE | |||
| SERVER_MSGLOG_COUNT | |||
| SERVER_MSGLOG_DIR | |||
| ERVER_MSGLOG_FILE | |||
| SERVER_MSGLOG_FLAG | SYSTEM | ||
| SERVER_MSGLOG_RESERVE_SIZE | |||
| SERVER_MSGLOG_SIZE | |||
| SM_MSGLOG_COUNT | |||
| SM_MSGLOG_FILE | |||
| SM_MSGLOG_FLAG | SYSTEM | ||
| SM_MSGLOG_RESERVE_SIZE | |||
| SM_MSGLOG_SIZE | |||
| TRC_MSGLOG_RESERVE_SIZE | |||
| TRCLOG_DETAIL_PREDICATE | SYSTEM | ||
| XA_MSGLOG_COUNT | |||
| XA_MSGLOG_FILE | |||
| XA_MSGLOG_FLAG | SYSTEM | ||
| XA_MSGLOG_RESERVE_SIZE | |||
| XA_MSGLOG_SIZE | |||
| L | DBLINK_ALTILINKER_CONNECT_TIMEOUT | ||
| DBLINK_DATA_BUFFER_ALLOC_RATIO | |||
| DBLINK_DATA_BUFFER_BLOCK_COUNT | |||
| DBLINK_DATA_BUFFER_BLOCK_SIZE | |||
| DBLINK_ENABLE | |||
| DBLINK_GLOBAL_TRANSACTION_LEVEL | |||
| DBLINK_RECOVERY_MAX_LOGFILE | SYSTEM | ||
| DBLINK_REMOTE_STATEMENT_AUTOCOMMIT | BOTH | ||
| DBLINK_REMOTE_TABLE_BUFFER_SIZE | |||
| U | AUDIT_FILE_SIZE | SYSTEM | |
| AUDIT_LOG_DIR | SYSTEM | ||
| AUDIT_OUTPUT_METHOD | SYSTEM | ||
| AUDIT_TAG_NAME_IN_SYSLOG | SYSTEM | ||
| A | EXTPROC_AGENT_CONNECT_TIMEOUT | SYSTEM | |
| EXTPROC_AGENT_CALL_RETRY_COUNT | SYSTEM | ||
| EXTPROC_AGENT_IDLE_TIMEOUT | SYSTEM | ||
| EXTPROC_AGENT_SOCKET_FILEPATH | |||
| AS | CASE_SENSITIVE_PASSWORD | SYSTEM | |
| FAILED_LOGIN_ATTEMPTS | |||
| PASSWORD_LOCK_TIME | |||
| PASSWORD_LIFE_TIME | |||
| PASSWORD_GRACE_TIME | |||
| PASSWORD_REUSE_TIME | |||
| PASSWORD_REUSE_MAX | |||
| PASSWORD_VERIFY_FUNCTION | |||
| E | ACCESS_LIST | ||
| ACCESS_LIST_FILE | |||
| ADMIN_MODE | SYSTEM | ||
| ARITHMETIC_OPERATION_MODE | SESSION | ||
| CHECK_MUTEX_DURATION_TIME_ENABLE | SYSTEM | ||
| COERCE_HOST_VAR_IN_SELECT_LIST_TO_VARCHAR | |||
| DEFAULT_DATE_FORMAT | |||
| EXEC_DDL_DISABLE | SYSTEM | ||
| GROUP_CONCAT_PRECISION | SYSTEM | ||
| JOB_SCHEDULER_ENABLE | SYSTEM | ||
| JOB_THREAD_COUNT | |||
| JOB_THREAD_QUEUE_SIZE | |||
| MSG_QUEUE_PERMISSION | |||
| PSM_CHAR_DEFAULT_PRECISION | |||
| PSM_IGNORE_NO_DATA_FOUND_ERROR | SYSTEM | ||
| PSM_NCHAR_UTF16_DEFAULT_PRECISION | |||
| PSM_NCHAR_UTF8_DEFAULT_PRECISION | |||
| PSM_NVARCHAR_UTF16_DEFAULT_PRECISION | |||
| PSM_NVARCHAR_UTF8_DEFAULT_PRECISION | |||
| PSM_PARAM_AND_RETURN_WITHOUT_PRECISION_ENABLE | |||
| PSM_VARCHAR_DEFAULT_PRECISION | |||
| QUERY_STACK_SIZE | BOTH | ||
| RECURSION_LEVEL_MAXIMUM | SESSION | ||
| REMOTE_SYSDBA_ENABLE | SYSTEM | ||
| SELECT_HEADER_DISPLAY | BOTH | ||
| SYS_CONNECT_BY_PATH_PRECISION | SYSTEM | ||
| SERIAL_EXECUTE_MODE | BOTH |
In this chapter, each property is explained as follows:
- Property name
- Data type
- Default value
- Attributes (e.g. read-only vs. read-write, single vs. multiple values)
- Range (maximum and minimum possible values)
- Description