오라클 19c 파라미터 세팅
DB CAFE
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
목차
- 1 오라클 19c R19 파라미터 세팅
- 1.1 _PX_use_large_pool = TRUE
- 1.2 _add_col_optim_enabed = FALSE
- 1.3 _ash_size = 34217728
- 1.4 _bloom_filter_enabled = FALSE
- 1.5 _buddy_instance = 0
- 1.6 _bump_highwater_mark_count = 300
- 1.7 _cleanup_rollback_entries = 2000
- 1.8 _client_enable_auto_unregister = TRUE
- 1.9 _clusterwide_golbal_transactions = FALSE
- 1.10 _cursor_obsolete_threshold = 1024
- 1.11 _cursor_reload_failure_threshold = 5
- 1.12 _disable_ilm_internal = TRUE
- 1.13 _disable_last_successful_login_time = TRUE
- 1.14 _dlm_stats_collect = 0
- 1.15 _drop_stat_segment = 1
- 1.16 _dynamic_sequence_cache = FALSE
- 1.17 _emon_send_timeout = 10000
- 1.18 _enable_shared_pool_durations = FALSE
- 1.19 _gc_bypass_readers = FALSE
- 1.20 _gc_dump_remote_lock = FALSE
- 1.21 _gc_override_force_cr = FALSE
- 1.22 _gc_persistent_read_mostly = FALSE
- 1.23 _gc_policy_minimum = 15000
- 1.24 _gc_read_mostly_locking = FALSE
- 1.25 _gc_undo_affinity = FALSE
- 1.26 _high_priority_processes = LMS*|VKTM|LGWR|LM*|LCK0|CKPT|DBRM|RMS0|LGWR|CR*|RS0*|RS1*|RS2*
- 1.27 _highest_priority_processes = CTWR|VKTM|LG*|LMS*
- 1.28 _highthreshold_undoretention = 10800
- 1.29 _imr_splitbrain_res_wait = 60
- 1.30 _in_memory_cdt = OFF
- 1.31 _in_memory_undo = FALSE
- 1.32 _kks_obsolete_dump_threshold = 0
- 1.33 _kks_parse_error_warning = 0
- 1.34 _lm_sync_timeout = 1200
- 1.35 _lm_tickets = 5000
- 1.36 _max_spacebg_slaves = 30
- 1.37 _nlj_batching_misses_enabled = 0
- 1.38 _nonfatalprocess_redo_dump_time_limit = 3600
- 1.39 _optimizer_adaptive_cursor_sharing = FALSE
- 1.40 _optimizer_aggr_groupby_elim = FALSE
- 1.41 _optimizer_batch_table_access_by_rowid = FALSE
- 1.42 _optimizer_cbqt_or_expansion = OFF
- 1.43 _optimizer_extened_cursor_sharing = NONE
- 1.44 _optimizer_extened_cursor_sharing_rel = NONE
- 1.45 _optimizer_gather_stats_on_load = FALSE
- 1.46 _optimizer_gather_stats_on_load_index = FALSE
- 1.47 _optimizer_reduce_groupby_key = FALSE
- 1.48 _optimizer_use_feedback = FALSE
- 1.49 _partition_large_extents = FALSE
- 1.50 _report_capture_cycle_time = 0
- 1.51 _rollback_segment_count = 1000
- 1.52 _row_cr = FALSE
- 1.53 _rowsets_enabled = FALSE
- 1.54 _sql_plan_directive_mgmt_control = 0
- 1.55 _subquery_pruning_enabled = FALSE
- 1.56 _sys_login_delay = 0
- 1.57 _undo_autotune = FALSE
- 1.58 _use_adaptive_log_file_sync = FALSE
- 1.59 _use_cached_asm_free_space = TRUE
- 1.60 allow_group_access_to_sga = TRUE
- 1.61 audit_file_dest = /db/diag/rdbms/임의폴더명
- 1.62 audit_sys_operations = FALSE
- 1.63 background_dump_dest = /oracle/app/oracle/product/19.3.0/rdbms/log
- 1.64 cluster_database = TRUE
- 1.65 common_user_prefilx = C##
- 1.66 cpu_count = 32
- 1.67 db_cache_advice = ON
- 1.68 db_cache_size = 128312147968
- 1.69 db_file_multiblock_read_count = 16
- 1.70 db_files = 10000
- 1.71 db_keep_cache_size = 1073741824
- 1.72 db_name = 디비명
- 1.73 db_securefile = PREFERRED
- 1.74 db_unique_name = 유니크 디비명
- 1.75 db_writer_processes = 4
- 1.76 deferred_segment_creation = FALSE
- 1.77 fast_start_mttr_target = 240
- 1.78 filesystemio_options = none
- 1.79 gcs_server_processes = 3
- 1.80 hash_area_size = 2097152000
- 1.81 inmemory_max_populate_servers = 0
- 1.82 java_pool_size = 3758096384
- 1.83 job_queue_processes = 1000
- 1.84 log_buffer = 484376576
- 1.85 max_pdbs = 254
- 1.86 nls_calendar = GREGORIAN
- 1.87 nls_currency = \ => (원화표시임)
- 1.88 nls_date_format = RR/MM/DD
- 1.89 nls_date_language = KOREAN
- 1.90 nls_iso_currency = KOREA
- 1.91 nls_language = KOREAN
- 1.92 nls_numeric_characters = .,
- 1.93 nls_sort = BINARY
- 1.94 nls_territory = KOREAN
- 1.95 nls_time_format = HH24:MI:SSXFF
- 1.96 nls_time_tz_foramt = HH24:MI:SSXFF TZR
- 1.97 nls_timestamp_format = RR/MM/DD HH24:MI:SSXFF
- 1.98 nls_timestamp_tz_format = RR/MM/DD HH24:MI:SSXFF TZR
- 1.99 open_cursors = 500
- 1.100 open_links = 40
- 1.101 open_links_per_instance = 40
- 1.102 optimizer_adaptive_plans = FALSE
- 1.103 optimizer_adaptive_reporting_only = TRUE
- 1.104 optimizer_dynamic_sampling = 0
- 1.105 optimizer_mode = FIRST_ROWS_1
- 1.106 optimizer_secure_view_merging = FALSE
- 1.107 parallel_force_local = TRUE
- 1.108 parallel_min_servers = 64
- 1.109 parallel_server_target = 128
- 1.110 pga_aggregate_limit = 107374182400
- 1.111 pga_aggregate_target = 53687091200
- 1.112 plsql_warnings = DISABLE:ALL
- 1.113 processes = 6000
- 1.114 result_cache_max_size = 0
- 1.115 sec_case_sensitive_logon = FALSE
- 1.116 session_cached_cursors = 500
- 1.117 sga_max_size = 171261820928
- 1.118 shared_pool_reserved_size = 1572864000
- 1.119 shared_pool_size = 32212254720
- 1.120 shared_servers = 1
- 1.121 sort_area_size = 1048576000
- 1.122 streams_pool_size = 536870912
- 1.123 target_pdbs = 0
- 1.124 thread = 2
- 1.125 timed_statistics = TRUE
- 1.126 undo_retention = 10800
- 1.127 undo_tablespace = UNDOTBS1
- 1.128 use_dedicated_broker = FALSE
- 1.129 use_large_pages = ONLY
1 오라클 19c R19 파라미터 세팅[편집]
- (디폴트값) <= 괄호 안은 디폴트값
1.1 _PX_use_large_pool = TRUE[편집]
- (FALSE)
1.2 _add_col_optim_enabed = FALSE[편집]
- (TRUE)
1.3 _ash_size = 34217728[편집]
- 128M , 사이즈는 조정 필요
1.4 _bloom_filter_enabled = FALSE[편집]
- (TRUE)
1.5 _buddy_instance = 0[편집]
- (1)
1.6 _bump_highwater_mark_count = 300[편집]
- (0)
1.7 _cleanup_rollback_entries = 2000[편집]
- (100)
1.8 _client_enable_auto_unregister = TRUE[편집]
- (FALSE)
1.9 _clusterwide_golbal_transactions = FALSE[편집]
1.10 _cursor_obsolete_threshold = 1024[편집]
- (8192)
1.11 _cursor_reload_failure_threshold = 5[편집]
- (20)
1.12 _disable_ilm_internal = TRUE[편집]
1.13 _disable_last_successful_login_time = TRUE[편집]
1.14 _dlm_stats_collect = 0[편집]
- (1)
1.15 _drop_stat_segment = 1[편집]
- (0)
1.16 _dynamic_sequence_cache = FALSE[편집]
1.17 _emon_send_timeout = 10000[편집]
[편집]
1.19 _gc_bypass_readers = FALSE[편집]
1.20 _gc_dump_remote_lock = FALSE[편집]
1.21 _gc_override_force_cr = FALSE[편집]
1.22 _gc_persistent_read_mostly = FALSE[편집]
1.23 _gc_policy_minimum = 15000[편집]
- (0)
1.24 _gc_read_mostly_locking = FALSE[편집]
1.25 _gc_undo_affinity = FALSE[편집]
1.26 _high_priority_processes = LMS*|VKTM|LGWR|LM*|LCK0|CKPT|DBRM|RMS0|LGWR|CR*|RS0*|RS1*|RS2*[편집]
1.27 _highest_priority_processes = CTWR|VKTM|LG*|LMS*[편집]
1.28 _highthreshold_undoretention = 10800[편집]
- (31536000)
1.29 _imr_splitbrain_res_wait = 60[편집]
- (0)
1.30 _in_memory_cdt = OFF[편집]
- (LIMITED)
1.31 _in_memory_undo = FALSE[편집]
1.32 _kks_obsolete_dump_threshold = 0[편집]
- (1)
1.33 _kks_parse_error_warning = 0[편집]
- (100)
1.34 _lm_sync_timeout = 1200[편집]
- (148)
1.35 _lm_tickets = 5000[편집]
- (1000)
1.36 _max_spacebg_slaves = 30[편집]
- (1024)
1.37 _nlj_batching_misses_enabled = 0[편집]
- (1)
1.38 _nonfatalprocess_redo_dump_time_limit = 3600[편집]
1.39 _optimizer_adaptive_cursor_sharing = FALSE[편집]
1.40 _optimizer_aggr_groupby_elim = FALSE[편집]
1.41 _optimizer_batch_table_access_by_rowid = FALSE[편집]
1.42 _optimizer_cbqt_or_expansion = OFF[편집]
1.43 _optimizer_extened_cursor_sharing = NONE[편집]
- (udo)
1.44 _optimizer_extened_cursor_sharing_rel = NONE[편집]
- (simple)
1.45 _optimizer_gather_stats_on_load = FALSE[편집]
1.46 _optimizer_gather_stats_on_load_index = FALSE[편집]
1.47 _optimizer_reduce_groupby_key = FALSE[편집]
1.48 _optimizer_use_feedback = FALSE[편집]
1.49 _partition_large_extents = FALSE[편집]
1.50 _report_capture_cycle_time = 0[편집]
- (60)
1.51 _rollback_segment_count = 1000[편집]
- (0)
1.52 _row_cr = FALSE[편집]
1.53 _rowsets_enabled = FALSE[편집]
1.54 _sql_plan_directive_mgmt_control = 0[편집]
- (67)
1.55 _subquery_pruning_enabled = FALSE[편집]
1.56 _sys_login_delay = 0[편집]
- (1)
1.57 _undo_autotune = FALSE[편집]
1.58 _use_adaptive_log_file_sync = FALSE[편집]
1.59 _use_cached_asm_free_space = TRUE[편집]
1.60 allow_group_access_to_sga = TRUE[편집]
1.61 audit_file_dest = /db/diag/rdbms/임의폴더명[편집]
- ($ORACLE_BASE/admin/@/adump)
1.62 audit_sys_operations = FALSE[편집]
1.63 background_dump_dest = /oracle/app/oracle/product/19.3.0/rdbms/log[편집]
- ($ORACLE_BASE/admin/@/adump)
1.64 cluster_database = TRUE[편집]
1.65 common_user_prefilx = C##[편집]
- (NONE)
1.66 cpu_count = 32[편집]
- (0)
1.67 db_cache_advice = ON[편집]
1.68 db_cache_size = 128312147968[편집]
- (0)
1.69 db_file_multiblock_read_count = 16[편집]
- (0)
1.70 db_files = 10000[편집]
- (200)
1.71 db_keep_cache_size = 1073741824[편집]
- (0)
1.72 db_name = 디비명[편집]
- (NONE)
1.73 db_securefile = PREFERRED[편집]
- (PERMITTED)
1.74 db_unique_name = 유니크 디비명[편집]
1.75 db_writer_processes = 4[편집]
- (0)
1.76 deferred_segment_creation = FALSE[편집]
1.77 fast_start_mttr_target = 240[편집]
- (0)
1.78 filesystemio_options = none[편집]
- (asynch)
1.79 gcs_server_processes = 3[편집]
1.80 hash_area_size = 2097152000[편집]
- (0)
1.81 inmemory_max_populate_servers = 0[편집]
- (65535)
1.82 java_pool_size = 3758096384[편집]
- (25165824)
1.83 job_queue_processes = 1000[편집]
- (4000)
1.84 log_buffer = 484376576[편집]
- (0)
1.85 max_pdbs = 254[편집]
- 4098
1.86 nls_calendar = GREGORIAN[편집]
- (NONE)
1.87 nls_currency = \ => (원화표시임)[편집]
- (NONE)
1.88 nls_date_format = RR/MM/DD[편집]
- (NONE)
1.89 nls_date_language = KOREAN[편집]
- (NONE)
1.90 nls_iso_currency = KOREA[편집]
- (NONE)
1.91 nls_language = KOREAN[편집]
- (NONE)
1.92 nls_numeric_characters = .,[편집]
- (NONE)
1.93 nls_sort = BINARY[편집]
- (NONE)
1.94 nls_territory = KOREAN[편집]
- (NONE)
1.95 nls_time_format = HH24:MI:SSXFF[편집]
- (NONE)
1.96 nls_time_tz_foramt = HH24:MI:SSXFF TZR[편집]
- (NONE)
1.97 nls_timestamp_format = RR/MM/DD HH24:MI:SSXFF[편집]
- (NONE)
1.98 nls_timestamp_tz_format = RR/MM/DD HH24:MI:SSXFF TZR[편집]
- (NONE)
1.99 open_cursors = 500[편집]
- (50)
1.100 open_links = 40[편집]
- (4)
1.101 open_links_per_instance = 40[편집]
- (4)
1.102 optimizer_adaptive_plans = FALSE[편집]
1.103 optimizer_adaptive_reporting_only = TRUE[편집]
1.104 optimizer_dynamic_sampling = 0[편집]
- (2)
1.105 optimizer_mode = FIRST_ROWS_1[편집]
- (all_rows)
1.106 optimizer_secure_view_merging = FALSE[편집]
1.107 parallel_force_local = TRUE[편집]
1.108 parallel_min_servers = 64[편집]
- (0)
1.109 parallel_server_target = 128[편집]
- (0)
1.112 plsql_warnings = DISABLE:ALL[편집]
- (NONE)
1.113 processes = 6000[편집]
- (0)
1.114 result_cache_max_size = 0[편집]
- (1)
1.115 sec_case_sensitive_logon = FALSE[편집]
1.116 session_cached_cursors = 500[편집]
- (50)
[편집]
- 1500M
[편집]
- 30G
[편집]
1.121 sort_area_size = 1048576000[편집]
- (65536)
1.122 streams_pool_size = 536870912[편집]
- 512M
1.123 target_pdbs = 0[편집]
- (1)
1.124 thread = 2[편집]
1.125 timed_statistics = TRUE[편집]
1.126 undo_retention = 10800[편집]
- (900)
1.127 undo_tablespace = UNDOTBS1[편집]
- (NONE)
1.128 use_dedicated_broker = FALSE[편집]
1.129 use_large_pages = ONLY[편집]
- (TRUE)