11gR2 RAC 권장 파라미터 정리

출처 : http://pat98.tistory.com/737

11gR2 RAC 권장 파라미터 정리

 

############# For Single ##############

 

alter system set Audit_trail=NONE scope=spfile;
alter system set db_files=1000 scope=spfile;
alter system set db_cache_advice=ON scope=spfile;
alter system set deferred_segment_creation=false scope=spfile;
alter system set fast_start_mttr_target=240 scope=spfile;
alter system set sec_case_sensitive_logon=false scope=spfile;
alter system set open_links_per_instance=40 scope=spfile;
alter system set open_links=40 scope=spfile;
alter system set optimizer_connect_by_cost_based=false scope=spfile;
#alter system set optimizer_dynamic_sampling=0 scope=spfile;   #OLTP 0 DW 2
alter system set optimizer_secure_view_merging=false scope=spfile;
alter system set parallel_adaptive_multi_user=false scope=spfile;
alter system set resource_manager_plan='FORCE:' scope=spfile;
 
alter system set "_add_col_optim_enabled"=false scope=spfile;
alter system set "_datafile_write_errors_crash_instance"=false scope=spfile;
alter system set "_b_tree_bitmap_plans"=false scope=spfile;
alter system set "_bloom_filter_enabled=false scope=spfile;
alter system set "_cleanup_rollback_entries"=500 scope=spfile;
alter system set "_db_mttr_advice"=OFF scope=spfile;
#alter system set  _enqueue_hash_chain_latches= scope=spfile;  #CPU core*3
alter system set "_index_partition_large_extents"=false scope=spfile;  
alter system set "_in_memory_undo"=false scope=spfile;
alter system set "_library_cache_advice"=false scope=spfile;
alter system set "_nlj_batching_enabled"=0 scope=spfile;
alter system set "_nlj_batching_misses_enabled"=0 scope=spfile;
alter system set "_optim_peek_user_binds"=false scope=spfile;
alter system set "_optimizer_adaptive_cursor_sharing"=false scope=spfile;
alter system set "_optimizer_connect_by_cost_based"=false scope=spfile;
alter system set "_optimizer_extended_cursor_sharing"=NONE scope=spfile;
alter system set "_optimizer_extended_cursor_sharing_rel"=NONE scope=spfile;
alter system set "_optimizer_use_feedback"=false scope=spfile;
alter system set "_optimizer_null_aware_antijoin"=false scope=spfile;
alter system set "_partition_large_extents"=false scope=spfile; 
alter system set "_PX_use_large_pool"=true scope=spfile;
alter system set "_rollback_segment_count=1000" scope=spfile;
alter system set "_row_cr"=false scope=spfile;
alter system set "_undo_autotune"=false scope=spfile;
alter system set "_use_adaptive_log_file_sync"=false scope=spfile;
alter system set "_memory_imm_mode_without_autosga"=false scope=spfile;

 

============  For RAC ####################

 

alter system set Audit_trail=NONE scope=spfile;
alter system set db_files=1000 scope=spfile;
alter system set db_cache_advice=ON scope=spfile;
alter system set deferred_segment_creation=false scope=spfile;
alter system set fast_start_mttr_target=240 scope=spfile;
alter system set sec_case_sensitive_logon=false scope=spfile;
alter system set open_links_per_instance=40 scope=spfile;
alter system set open_links=40 scope=spfile;
alter system set optimizer_connect_by_cost_based=false scope=spfile;
#alter system set optimizer_dynamic_sampling=0 scope=spfile;   #OLTP 0 DW 2
alter system set optimizer_secure_view_merging=false scope=spfile;
alter system set parallel_adaptive_multi_user=false scope=spfile;
alter system set parallel_force_local=true scope=spfile;
alter system set resource_manager_plan='FORCE:' scope=spfile; 
 
alter system set "_add_col_optim_enabled"=false scope=spfile;
alter system set "_datafile_write_errors_crash_instance"=false scope=spfile;
alter system set "_b_tree_bitmap_plans"=false scope=spfile;
alter system set "_bloom_filter_enabled=false scope=spfile;
alter system set "_cleanup_rollback_entries"=500 scope=spfile;
alter system set "_clusterwide_global_transactions"=false scope=spfile;
alter system set "_db_mttr_advice"=OFF scope=spfile;
#alter system set  _enqueue_hash_chain_latches= scope=spfile;  #CPU core*3
alter system set "_index_partition_large_extents"=false scope=spfile;  
alter system set "_in_memory_undo"=false scope=spfile;
alter system set "_gc_bypass_readers"=FALSE scope=spfile;
alter system set "_gc_integrity_checks"=0 scope=spfile;
alter system set "_gc_maximum_bids"=8 scope=spfile;
alter system set "_gc_policy_time"=0 scope=spfile;
alter system set "_gc_read_mostly_locking"=FALSE scope=spfile; 
alter system set "_gc_undo_affinity"=false scope=spfile;
alter system set "_library_cache_advice"=false scope=spfile;
alter system set "_nlj_batching_enabled"=0 scope=spfile;
alter system set "_nlj_batching_misses_enabled"=0 scope=spfile;
alter system set "_optim_peek_user_binds"=false scope=spfile;
alter system set "_optimizer_adaptive_cursor_sharing"=false scope=spfile;
alter system set "_optimizer_connect_by_cost_based"=false scope=spfile;
alter system set "_optimizer_extended_cursor_sharing"=NONE scope=spfile;
alter system set "_optimizer_extended_cursor_sharing_rel"=NONE scope=spfile;
alter system set "_optimizer_use_feedback"=false scope=spfile;
alter system set "_optimizer_null_aware_antijoin"=false scope=spfile;
alter system set "_partition_large_extents"=false scope=spfile; 
alter system set "_px_execution_services_enabled"=false scope=spfile;
alter system set "_PX_use_large_pool"=true scope=spfile;
alter system set "_rollback_segment_count=1000" scope=spfile;
alter system set "_row_cr"=false scope=spfile;
alter system set "_undo_autotune"=false scope=spfile;
alter system set "_use_adaptive_log_file_sync"=false scope=spfile;
alter system set "_memory_imm_mode_without_autosga"=false scope=spfile;

 

자세한 설명은 생략한다.