RDBMS/ORACLE & TIBERO
TIBERO 다중 노드 파라미터(Parameter) 확인
junsuyoun
2024. 2. 29. 09:18
728x90
반응형
TIBERO 데이터베이스에서 다중 노드 구성 (TSC or TAC) 일 경우 파라미터 적용하는 경우 각 노드가 개별로 가져야하는 파라미터 값과 동일하게 가져야하는 파라미터를 알아 볼 수 있습니다.
VT_PARAMETER 확인
-- 같아도 되고 달라도 되고 상관 없음
SELECT * FROM VT_PARAMETER WHERE GLOBAL='BOTH'
-- Node 별로 값이 같아야 한다.
SELECT * FROM VT_PARAMETER WHERE GLOBAL='GLOBAL'
-- Node 별로 값이 달라야한다.
SELECT * FROM VT_PARAMETER WHERE GLOBAL='LOCAL'- PUBLIC.VT_PARAMETER 을 조회할 때 GLOBAL 칼럼의 값이 구분하는데 사용 됩니다.
- BOTH: 노드 마다 같아도 되고 달라도 되고
- GLOBAL: 노드 마다 같아야하고
- LOCAL: 노드 마다 달라도 된다.
VT_PARAMETER 조회
NAME "TYPE" DFLT_VALUE IS_OPTIONAL IS_ADJUSTABLE IS_DYNAMIC IS_HIDDEN BOUND "GLOBAL" VALUE INST_VALUE STATUS INST_STATUS "RANGE"
_INLINE_LOB_MAX_DATA_SIZE UINT32 4096 1 1 1 1 SYS BOTH 4096 4096 DEFAULT DEFAULT
BIND_VARIABLE_CAPTURE_POOL_SIZE UINT64 4194304 1 1 0 0 SYS BOTH 4194304 4194304 DEFAULT DEFAULT
BIND_VARIABLE_CAPTURE_POOL_PCTDEL UINT32 10 1 1 0 0 SYS BOTH 10 10 DEFAULT DEFAULT
_SGMT_MERGE_RECOVERY_TEST INT32 0 1 1 1 1 SYS BOTH 0 0 DEFAULT DEFAULT
_DP_TEMP_SGMT_CLEANUP_INTERVAL UINT32 60 1 1 1 1 SYS BOTH 60 60 DEFAULT DEFAULT 0 - 86400 (0 - 86400 seconds)
_DP_LOAD_PARALLEL_SESSION_HOLD_GLOBAL_WLOCK Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_TD_IOT_USE_TRAIL_NULL Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_ALLOW_SELECT_LIST_TO_LOB Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_USGMT_USE_FREEPOOL Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_DDL_DEFAULT_REDEF_PARALLEL_CNT INT32 0 1 1 1 1 SYS BOTH 0 0 DEFAULT DEFAULT
_DUMP_ALL_PROCESS Y_N YES 1 1 0 1 SYS BOTH YES YES DEFAULT DEFAULT
SHP_ALLOC_FULL_DUMP Y_N NO 1 1 1 0 SYS BOTH NO NO DEFAULT DEFAULT
SHP_ALLOC_DUMP_IDX INT32 0 1 1 1 0 SYS BOTH 0 0 DEFAULT DEFAULT
CLOSE_REMOTE_SESSION_ON_SESSION_RESET Y_N YES 1 1 1 0 SYS BOTH YES YES DEFAULT DEFAULT
BATCHUPDATE_MODE INT32 1 1 1 1 0 SYS BOTH 1 1 DEFAULT DEFAULT
_BATCHUPDATE_READ_MSG_IN_EX Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_DDL_LOCK_GRACE_TIME_FOR_TBL_RENAME INT32 0 1 1 1 1 SYS BOTH 0 0 DEFAULT DEFAULT
BIND_VARIABLE_CAPTURE_ALLOC_COUNT UINT32 4 1 1 0 0 SYS BOTH 4 4 DEFAULT DEFAULT
BIND_VARIABLE_CAPTURE_KEEP_FIRST Y_N NO 1 1 1 0 SYS BOTH NO NO DEFAULT DEFAULT
BIND_VARIABLE_CAPTURE_MAX_VAR_COUNT UINT32 512 1 1 1 0 SYS BOTH 512 512 DEFAULT DEFAULT
_OPT_VSIZABLE_COLUMN_ON_TMPTBL Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_OPT_ANALYZE_SKEWNESS Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_DDL_DEFAULT_PARALLEL_CNT INT32 0 1 1 1 1 SYS BOTH 0 0 DEFAULT DEFAULT
_INDEX_BUILD_INTEGRITY_CHECK Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_USE_DD_IMAGE Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_DBMS_STATS_PARALLEL_GATHERING Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_DBMS_STATS_GATHER_AUTO_STALED STRING WEEKLY 1 1 1 1 SYS BOTH WEEKLY WEEKLY DEFAULT DEFAULT DAILY | WEEKLY | MONTHLY | NONE
_ROWID_SORT_MIN_EXCESS_CNT UINT32 50 1 1 1 1 SESS BOTH 50 50 DEFAULT DEFAULT 0 ~ 1000000
OPTIMIZER_TRACE Y_N NO 1 1 1 0 SESS BOTH NO NO DEFAULT DEFAULT
USE_TRUNCATE_PRIVILEGE Y_N NO 1 1 1 0 SYS BOTH NO NO DEFAULT DEFAULT
_EX_HJ_USE_MAX_PIN_CNT Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_EX_SA_USE_MAX_PIN_CNT Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_OPT_INDEX_JOIN_COMPLEX_RIGHT_CARD UINT32 2 1 1 1 1 SESS BOTH 2 2 DEFAULT DEFAULT 0 ~ 1000000
BIND_VARIABLE_CAPTURE Y_N NO 1 1 1 0 SYS BOTH NO NO DEFAULT DEFAULT
BIND_VARIABLE_CAPTURE_MAX_COUNT UINT32 1000 1 1 1 0 SYS BOTH 1000 1000 DEFAULT DEFAULT 10 ~ 1000000
BIND_VARIABLE_CAPTURE_INTERVAL UINT32 600 1 1 1 0 SYS BOTH 600 600 DEFAULT DEFAULT 0 ~ 86400
_DDL_LOCK_GRACE_TIME_FOR_IDX_RENAME INT32 0 1 1 1 1 SYS BOTH 0 0 DEFAULT DEFAULT
_DDL_PROCEED_FORCE Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_DDL_INDEX_REBUILD_WITHOUT_LOCK Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_ENABLE_SIMPLE_HASH_JOIN_OPTIMIZE Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
SUMMARY_FIRST_IN_GROUPBY_CUBE Y_N NO 1 1 1 0 SYS BOTH NO NO DEFAULT DEFAULT
_DECODE_TO_OR Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_TRANS_DECODE_TO_OR Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_TEST_TX_RECOVERY_DELAYTIME INT32 0 1 1 1 1 SYS BOTH 0 0 DEFAULT DEFAULT
_DD_CACHE_INVALIDATE_GLOBAL Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_VIRTUAL_PRIVATE_DATABASE Y_N YES 1 1 0 1 SYS BOTH YES YES DEFAULT DEFAULT
_SCAN_DROPPED_SGMT_CR_RETRY Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_BUF_BUCKET_CR_LIMIT Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_BUF_BUCKET_CR_LIMIT_MAX INT32 5 1 1 0 1 SYS BOTH 5 5 DEFAULT DEFAULT
_BUF_BUCKET_CR_LIMIT_SKIP Y_N YES 1 1 0 1 SYS BOTH YES YES DEFAULT DEFAULT
_BUF_BUCKET_CR_LIMIT_SKIP_LOCK_FREE Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_MBR_DROPPED_SGMT Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_MBR_DROPPED_SGMT_DUMP Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_BUF_RESOLVE_SELF_DEADLOCK_FORCE Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_BUF_BUCKET_CR_SORT Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_ENABLE_PRIOR_EXP_ORDERBY Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_ENABLE_MRG_TDD_MU Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_ENABLE_MRG_TDD_MI Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_DDL_LOCK_GRACE_TIME_FOR_IDX_REBUILD INT32 -1 1 1 1 1 SYS BOTH -1 -1 DEFAULT DEFAULT
_DDL_LOCK_GRACE_TIME INT32 10 1 1 1 1 SYS BOTH 10 10 DEFAULT DEFAULT
_USE_DML_WITH_CURBLK Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_ALLOW_OPEN_NORMAL Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_DISABLE_DML_TRIGGER_SCHEMA STRING 1 1 1 1 SYS BOTH DEFAULT DEFAULT
_ADJUST_CKPT_RBA_TO_CKPT_TSN Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_DBWR_BLK_MOVE_TO_LRU_MAIN_MIDDLE Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_FREE_BH_USE_DBWR_AFFINITY Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_FREE_BH_USE_DBWR_AFFINITY_IR Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_FREE_BH_USE_DBWR_AFFINITY_FORCE Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_DBWR_AFFINITY_SHIFT UINT32 0 1 1 0 1 SYS BOTH 0 0 DEFAULT DEFAULT 0 - 12
_DBWR_RESOLVE_SKIPPED_GWR_ENTRY Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_CCC_PB_MERGE_UPDATE_TSN_HIGH Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_CCC_ALWAYS_SEND_WRITE_NOTIFY Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_USE_BUCKET_HASH_V2 Y_N YES 1 1 0 1 SYS BOTH YES YES DEFAULT DEFAULT
_DDL_DEFAULT_INITRANS INT32 2 1 1 1 1 SYS BOTH 2 2 DEFAULT DEFAULT
_OPT_STAT_COLLECTION_V2 Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_DBMS_STATS_USE_TMP_TBL Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_ENABLE_IOT_OVERFLOW_MI Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
LOG_LVL_AS UINT32 5 1 1 1 0 SYS BOTH 5 5 DEFAULT DEFAULT 1 - 6
_LRUF_WRITE_CLEAN_CR_FORCE Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_NOTIFICATION_SENDER_COUNT INT32 1 1 1 0 1 SYS BOTH 1 1 DEFAULT DEFAULT 1 ~ 4
_NOTIFICATION_MAX_COUNT_PER_SENDER INT32 1024 1 1 0 1 SYS BOTH 1024 1024 DEFAULT DEFAULT
_TQ_BUCKET_COUNT_PER_SENDER INT32 128 1 1 0 1 SYS BOTH 128 128 DEFAULT DEFAULT
_NOTIFICATION_NETWORK_TIMEOUT INT32 1 1 1 0 1 SYS BOTH 1 1 DEFAULT DEFAULT
_CR_BUILD_USE_HANG_DETECTION Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_CRX_BUILD_USE_HANG_DETECTION Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_AGENT_CR_BUILD_USE_HANG_DETECTION Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_HANG_DECTECTION_WITH_BLOCK_IMAGE_BACKUP Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_CR_BUILD_TIME_LIMIT UINT32 60 1 1 1 1 SYS BOTH 60 60 DEFAULT DEFAULT
_CRX_BUILD_TIME_LIMIT UINT32 60 1 1 1 1 SYS BOTH 60 60 DEFAULT DEFAULT
_AGENT_CR_BUILD_TIME_LIMIT UINT32 10 1 1 1 1 SYS BOTH 10 10 DEFAULT DEFAULT
_CR_BUILD_TRY_CNT_IN_DEBUG_MODE INT32 10 1 1 1 1 SYS BOTH 10 10 DEFAULT DEFAULT
_CRX_BUILD_TRY_CNT_IN_DEBUG_MODE INT32 10 1 1 1 1 SYS BOTH 10 10 DEFAULT DEFAULT
_CR_AGENT_CAN_BE_DISABLED_BY_HANG Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
DISK_PATH STRING 1 1 0 0 SYS BOTH DEFAULT DEFAULT
_PROXY_DEFERRED_PUT_BUF_SIZE INT32 32768 1 1 1 1 SESS BOTH 32768 32768 DEFAULT DEFAULT 4K ~ 1M
_TLOB_SLAB_EXT_SIZE INT32 2 1 1 0 1 SYS BOTH 2 2 DEFAULT DEFAULT
_FORCE_NATIVE_ALLOC_USE Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_SUPPLOG_FOR_ALL_TABLES Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_SUPPLOG_PKEY_FOR_ALL_TABLES Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_EXTRA_SUPPLOG_FOR_UPDATE_QUERY Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_DUMMY_TX_LOGGING Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_DUMMY_TX_LOGGING_INTERVAL INT32 3 1 1 1 1 SYS BOTH 3 3 DEFAULT DEFAULT 0 - INT32_MAX
_RECR_HANDLE_PIN_COUNT_MAX UINT32 32768 1 1 1 1 SYS BOTH 32768 32768 DEFAULT DEFAULT 1024 ~ UINT16_MAX
_MALLOPT_DISCLAIM_CHECK_INTERVAL UINT32 60 1 1 1 1 SYS BOTH 60 60 DEFAULT DEFAULT
_MALLOPT_DISCLAIM_LIMIT UINT64 1048576 1 1 1 1 SYS BOTH 1048576 1048576 DEFAULT DEFAULT
_DB_BLOCK_INVAL_BLOCK_TYPE_DUMP Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_DB_BLOCK_CHECK_FAIL_DUMP Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_DISABLE_NORM_COMP Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_TLOB_USE_PGA Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_TLOB_AUTO_ELIMINATION_TIME UINT32 0 1 1 1 1 SESS BOTH 0 0 DEFAULT DEFAULT 0 ~ 86400
_TLOB_SLAB_CHILD_SIZE INT32 12 1 1 0 1 SYS BOTH 12 12 DEFAULT DEFAULT
_TLOB_SLAB_INIT_SIZE INT32 2 1 1 0 1 SYS BOTH 2 2 DEFAULT DEFAULT
_ESCAPE_INF_CR_BUILD INT32 2147483647 1 1 1 1 SYS BOTH 2147483647 2147483647 DEFAULT DEFAULT
_ESCAPE_INF_CRX_BUILD INT32 2147483647 1 1 1 1 SYS BOTH 2147483647 2147483647 DEFAULT DEFAULT
_ESCAPE_INF_AGENT_CR_BUILD INT32 2147483647 1 1 1 1 SYS BOTH 2147483647 2147483647 DEFAULT DEFAULT
_IGNORE_PCTFREE_FOR_INSERT Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_LOG_INVALID_FREESPACE_INSTEAD_OF_ASSERT Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_CORRECT_RPCOL_LEN_FOR_DP Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_DPL_SET_BM_FULL Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_EX_ROWID_SORT_MAX_PREFETCH UINT32 7 1 1 1 1 SYS BOTH 7 7 DEFAULT DEFAULT 0 ~ 64
_BUF_GET_PREFETCH_CNT UINT32 0 1 1 0 1 SYS BOTH 0 0 DEFAULT DEFAULT 0 ~ 64
_BUF_PIN_WAIT_DIAG_DUMP Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_BUF_PIN_WAIT_DIAG_DUMP_ALL_BUCKETS Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_BUF_PIN_WAIT_DIAG_DUMP_LRU Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_BUF_PIN_WAIT_DIAG_DUMP_DBWR Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_BUF_PIN_WAIT_DIAG_DUMP_TIMEOUT INT32 600 1 1 1 1 SYS BOTH 600 600 DEFAULT DEFAULT
_BUF_PIN_WAIT_DIAG_DUMP_INTERVAL INT32 180 1 1 1 1 SYS BOTH 180 180 DEFAULT DEFAULT
_BUF_PIN_WAIT_BUCKET_DUMP_INTERVAL INT32 3600 1 1 1 1 SYS BOTH 3600 3600 DEFAULT DEFAULT
_BUF_PIN_WAIT_LRU_DUMP_INTERVAL INT32 3600 1 1 1 1 SYS BOTH 3600 3600 DEFAULT DEFAULT
_BUF_PIN_WAIT_DIAG_DUMP_CNT INT32 10 1 1 1 1 SYS BOTH 10 10 DEFAULT DEFAULT
_ENABLE_IOT_MI Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_USE_PSM_PREFETCH Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_EX_HTBL_BUILD_SESSKILL_CHK_CNT INT32 1000 1 1 1 1 SESS BOTH 1000 1000 DEFAULT DEFAULT
_ACS_MAX_PREDICATE_COUNT UINT32 16 1 1 1 1 SYS BOTH 16 16 DEFAULT DEFAULT
_RECO_STATUS_ACK_SLEEP_DURATION INT32 100000 1 1 1 1 SYS BOTH 100000 100000 DEFAULT DEFAULT
ACTIVE_SESSION_TIMEOUT INT32 0 1 1 1 0 SESS BOTH 0 0 DEFAULT DEFAULT
_EX_TSCAN_ROWID_SFC Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_EX_FILTER_SFC Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_DDL_RECOVERY_TEST INT32 0 1 1 1 1 SYS BOTH 0 0 DEFAULT DEFAULT
_EX_WC_SIZE UINT32 0 1 1 0 1 SYS BOTH 0 0 DEFAULT DEFAULT 0 - 1000
_ENABLE_INLIST_ISCAN Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_EX_TSCAN_SFC Y_N YES 1 1 0 1 SESS BOTH YES YES DEFAULT DEFAULT
_ENABLE_LIKE_TO_OP Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_PCTAS_SKIP_UNDO Y_N YES 1 1 1 1 SESS BOTH YES YES DEFAULT DEFAULT
_SKIP_UNDO Y_N NO 1 1 1 1 SESS BOTH NO NO DEFAULT DEFAULT
_CHECK_INSERT_UNDO_CV Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_SPAN_UNDO Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_SPAN_UNDO_MIN UINT32 100 1 1 1 1 SYS BOTH 100 100 DEFAULT DEFAULT
_ADAPTIVE_CURSOR_SHARING Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_ACS_STAT_THRESHOLD UINT32 50 1 1 1 1 SYS BOTH 50 50 DEFAULT DEFAULT
_BUF_BUCKET_CR_SORT_CHECK_CUR_POS Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_DISABLE_CR_SORT_FOR_INVALID_BUCKET Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_DDL_MOVE_COMPRESS_PARALLEL INT32 0 1 1 1 1 SYS BOTH 0 0 DEFAULT DEFAULT
_DDL_AUTO_SUPPLOG_CTBL Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_DDL_AFTER_TRIGGER_FIRE_WHEN_FAILURE Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
STATS_RETENTION INT32 31 1 1 1 1 SYS BOTH 31 31 DEFAULT DEFAULT
_ENABLE_DBMS_STATS_TRACE Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_LOG_FILE_WITH_GROUP_READ_PERM Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_FILE_DELETE_PROTECTION Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_TXINFO_SLAB_CHILD_SIZE INT32 12 1 1 0 1 SYS BOTH 12 12 DEFAULT DEFAULT
_TXINFO_SLAB_INIT_SIZE INT32 2 1 1 0 1 SYS BOTH 2 2 DEFAULT DEFAULT
_TXINFO_SLAB_EXT_SIZE INT32 1 1 1 0 1 SYS BOTH 1 1 DEFAULT DEFAULT
_CL_LIST_SLAB_CHILD_SIZE INT32 12 1 1 0 1 SYS BOTH 12 12 DEFAULT DEFAULT
_CL_LIST_SLAB_INIT_SIZE INT32 2 1 1 0 1 SYS BOTH 2 2 DEFAULT DEFAULT
_CL_LIST_SLAB_EXT_SIZE INT32 2 1 1 0 1 SYS BOTH 2 2 DEFAULT DEFAULT
_CTSN_CACHE_SLAB_CHILD_SIZE INT32 12 1 1 0 1 SYS BOTH 12 12 DEFAULT DEFAULT
_CTSN_CACHE_SLAB_INIT_SIZE INT32 2 1 1 0 1 SYS BOTH 2 2 DEFAULT DEFAULT
_CTSN_CACHE_SLAB_EXT_SIZE INT32 1 1 1 0 1 SYS BOTH 1 1 DEFAULT DEFAULT
_DDL_MOVE_COMPRESS_ORDER_BY Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_PPC_ELEM_AGGR_SIZE_MAX INT64 4294967 1 1 1 1 SYS BOTH 4294967 4294967 DEFAULT DEFAULT
_OPT_CHECK_INLIST_EXPAND Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_AUTO_RECR_HANDLE_GC Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
_AUTO_RECR_HANDLE_GC_INTERVAL UINT32 1 1 1 1 1 SYS BOTH 1 1 DEFAULT DEFAULT
_RECR_HANDLE_GC_LEVEL UINT32 20 1 1 1 1 SYS BOTH 20 20 DEFAULT DEFAULT
_CHECK_NORMAL_BOOT_MODE Y_N NO 1 1 0 1 SYS BOTH NO NO DEFAULT DEFAULT
_BATCH_UPDATE_TCP_RCVBUF_SIZE UINT32 1048576 1 1 0 1 SYS BOTH 1048576 1048576 DEFAULT DEFAULT
_EX_SSGMT_MBRC INT32 8 1 1 1 1 SESS BOTH 8 8 DEFAULT DEFAULT
_ACOAL_ELEM_POOL_INIT_SIZE INT32 100 1 1 0 1 SYS BOTH 100 100 DEFAULT DEFAULT
_ACOAL_ELEM_POOL_EXP_SIZE INT32 100 1 1 0 1 SYS BOTH 100 100 DEFAULT DEFAULT
_ACOAL_ELEM_FREELIST_CNT INT32 1 1 1 0 1 SYS BOTH 1 1 DEFAULT DEFAULT
_TTS_SPIN_SET_COUNT_MAX INT32 1 1 1 0 1 SYS BOTH 1 1 DEFAULT DEFAULT
_SPIN_USE_WAITER_LIST Y_N YES 1 1 0 1 SYS BOTH YES YES DEFAULT DEFAULT
_SPINLOCK_FEATURE2 Y_N YES 1 1 0 1 SYS BOTH YES YES DEFAULT DEFAULT
_NO_QUERY_TRANSFORMATION Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_DDL_NEW_TRUNCATE Y_N YES 1 1 1 1 SYS BOTH YES YES DEFAULT DEFAULT
LIBRARY_DD_CACHE_MAX UINT64 429706444 1 1 1 0 SYS BOTH 429496729 429496729 DEFAULT DEFAULT 10M -
_SHP_ADVICE_INFO_COLLECTION_INTERVAL UINT32 864000 1 1 1 1 SYS BOTH 864000 864000 DEFAULT DEFAULT
TEMP_TS_CNT_MAX INT32 10 1 1 0 0 SYS BOTH 10 10 DEFAULT DEFAULT
_TEMP_TS_IO_USE_O_DIRECT Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
_SESS_LTIME_SLAB_CHILD_SIZE INT32 12 1 1 0 1 SYS BOTH 12 12 DEFAULT DEFAULT
_AS_DMON_TERM INT32 30 1 1 1 1 SYS BOTH 30 30 DEFAULT DEFAULT 0 - 10000
_AS_DMON_CHECK_RETRY_CNT UINT32 3 1 1 1 1 SYS BOTH 3 3 DEFAULT DEFAULT 0 - 128
_AS_EXTMAP_MEM_LIMIT INT64 214748364 1 1 1 1 SYS BOTH 214748364 214748364 DEFAULT DEFAULT
_AS_EXTPAGE_LOCK_CNT UINT32 4096 1 1 0 1 SYS BOTH 4096 4096 DEFAULT DEFAULT
_AS_EXTPAGE_WS_CNT UINT32 24 1 1 0 1 SYS BOTH 24 24 DEFAULT DEFAULT
_AS_AIOCB_SPLIT_CNT UINT32 6 1 1 1 1 SYS BOTH 6 6 DEFAULT DEFAULT
_AS_IO_FAIL_NOTI_INTERVAL UINT32 180 1 1 1 1 SYS BOTH 180 180 DEFAULT DEFAULT
_AS_FREE_ATB_RETRY_MAX UINT32 10 1 1 1 1 SYS BOTH 10 10 DEFAULT DEFAULT
_AS_ALLOC_FAIL_RETRY_MAX UINT32 10 1 1 1 1 SYS BOTH 10 10 DEFAULT DEFAULT
_AS_LISTIO_DEBUG Y_N NO 1 1 1 1 SYS BOTH NO NO DEFAULT DEFAULT
728x90
반응형