oracle11g 隐藏参数_ORACLE 11GR2常用参数(含隐含参数)设置

ORACLE 11GR2常用参数(含隐含参数)设置如下：

alter system set "_PX_use_large_pool" = true scope=spfile;

alter system set "_clusterwide_global_transactions" = false scope=spfile;#RAC环境 https://www.sohu.com/a/152628320_505827

alter system set "_gc_defer_time" = 3 scope=spfile;

alter system set "_resource_manager_always_off" = true scope=spfile;

alter system set "_resource_manager_always_on" = false scope=spfile;

alter system set "_serial_direct_read" = never scope=spfile;

alter system set "_cleanup_rollback_entries" = 400 scope=spfile;

alter system set "_optimizer_use_feedback" = false scope=spfile;

alter system set "_dbms_sql_security_level" =0 scope=spfile;

alter system set "_bloom_pruning_enabled" = false scope=spfile;

修改DRM(有bug，易导致RAC 实例崩溃)

alter system set "_gc_policy_time" = 0 scope=spfile sid='*';

alter system set "_bloom_filter_enabled" = false scope=spfile;

alter system set "_gc_read_mostly_locking" = false scope=spfile;

alter system set "_gc_undo_affinity" = false scope=spfile;

#alter system set "_smu_debug_mode" = 134217728 scope=spfile;#http://www.laoxiong.net/how-to-drop-undo-segment.html

alter system set "_undo_autotune" = false scope=spfile;

alter system set deferred_segment_creation = false scope=spfile;

alter system set audit_trail = none scope=spfile;

alter system set event='28401 trace name context forever,level 1' scope=spfile;

关闭11g新特性自适应游标共享(Adaptive Cursor Sharing)

alter system set "_optimizer_extended_cursor_sharing_rel"=none;

alter system set "_optimizer_extended_cursor_sharing"=none;

alter system set "_optimizer_adaptive_cursor_sharing"=false;

alter system set "_memory_imm_mode_without_autosga"=false sid='*';关闭 _memory_imm_mode_without_autosga http://blog.itpub.net/27243841/viewspace-1147107/ 避免ORA4031

alter system set "_b_tree_bitmap_plans"=false sid='*';修改_b_tree_bitmap_plans，https://www.cnblogs.com/archersun/p/3173141.html

alter system set "_partition_large_extents"=&#