暂无图片
求一份oracle19c的参数优化项
我来答
分享
暂无图片 匿名用户
求一份oracle19c的参数优化项

求一份oracle19c的参数优化项,建议值

我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
JiekeXu
暂无图片
接下来调整参数,重启数据库就可以测试了,调整参数如下,仅供参考:
alter system set processes=4000 scope=spfile;
alter system set db_files=2500 scope=spfile;
alter system set standby_file_management='AUTO';
alter system set control_file_record_keep_time=30;
alter system set fast_start_mttr_target=120 scope=spfile;
alter system set open_links_per_instance=10 scope=spfile;
alter system set session_cached_cursors=600 scope=spfile; 
alter system set archive_lag_target=1800 scope=spfile;
alter system set open_cursors=1500 scope=spfile;
alter system set open_links=10 scope=spfile;
alter system set undo_retention=10800 scope=spfile;
alter system set lock_sga=FALSE scope=spfile;
alter system set remote_login_passwordfile='EXCLUSIVE' scope=spfile;
alter system set resource_manager_plan='' scope=spfile;
alter system set statistics_level='TYPICAL' scope=spfile;
alter system set timed_statistics=TRUE scope=spfile;
alter system set undo_management='AUTO' scope=spfile;
alter system set db_cache_advice='OFF' scope=spfile;
alter system set audit_trail='NONE' scope=spfile;
alter system set audit_sys_operations=false scope=spfile;
alter system set "_gc_policy_time"=0 scope=spfile;
alter system set "_sort_elimination_cost_ratio"=0 scope=spfile;
alter system set "_use_adaptive_log_file_sync"= FALSE scope=spfile;
alter system set "result_cache_max_size"= 0 scope=spfile;
alter system set use_large_pages=only scope=spfile;
alter system set "_optimizer_use_feedback"=false scope=spfile;
暂无图片 评论
暂无图片 有用 0
春暖花开

alter system set processes=4000 scope=spfile;  -- 这个参数没必要建议, 

alter system set fast_start_mttr_target=120 scope=spfile;  -- 这个,是不是少了个0?

 alter system set statistics_level='TYPICAL' scope=spfile;  -- 这个,是默认值吧?

alter system set db_cache_advice='OFF' scope=spfile; -- 没必要关闭,

暂无图片 评论
暂无图片 有用 0
holiday

_gc_policy_time=0这个应该换成_lm_drm_disable=7

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏