oracle 静默建rac及设置多个event-凯发app官方网站

alter system set "_gc_defer_time"=3 scope=spfile sid='*';
alter system set "_gc_policy_time"=0 scope=spfile sid='*';
alter system set "_gc_undo_affinity"=false scope=spfile sid='*';
alter system set "_optimizer_adaptive_cursor_sharing"=false scope=spfile sid='*';
alter system set "_optimizer_extended_cursor_sharing"='none' scope=spfile sid='*';
alter system set "_optimizer_extended_cursor_sharing_rel"='none' scope=spfile sid='*';
alter system set "_optimizer_use_feedback"=false scope=spfile sid='*';
alter system set "_partition_large_extents"=false scope=spfile sid='*';
alter system set "_px_use_large_pool"=true scope=spfile sid='*';
alter system set "_undo_autotune"=false scope=spfile sid='*';
alter system set "_use_adaptive_log_file_sync"='false' scope=spfile sid='*';
alter system set deferred_segment_creation=false scope=spfile sid='*';
alter system set event='28401 trace name context forever,level 1','10949 trace name context forever,level 1' scope=spfile
alter system set open_cursors=300 scope=spfile sid='*';
alter system set parallel_force_local=true scope=spfile sid='*';
alter system set processes=3000 scope=spfile sid='*';
alter system set result_cache_max_size=0 scope=spfile sid='*';
alter system set sec_case_sensitive_logon=false scope=spfile sid='*';
alter system set undo_retention=10800 scope=spfile sid='*';

设置系统系统数据文件自动扩展
alter database datafile 1,2,3,5 autoextend on;

增加几组redo

alter database add logfile thread 1 group 5 ' datadg' size 200m;

alter database add logfile thread 1 group 6 ' datadg' size 200m;

alter database add logfile thread 2 group 7 ' datadg' size 200m;

alter database add logfile thread 2 group 8 ' datadg' size 200m;

设置归档模式

阅读(1384) | 评论(0) | 转发(0) |

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们