修改oracle配置参数

最新推荐文章于 2023-10-26 04:56:45 发布

转载最新推荐文章于 2023-10-26 04:56:45 发布 · 143 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://yq.aliyun.com/articles/628505

文章标签：

#数据库

"SIMPLIFIED CHINESE_CHINA".ZHS16GBK

create pfile='/opt/oracle/spfile.bakxu20120426' from spfile;
alter system set memory_max_target=10400M scope=spfile;


alter system set memory_target=9600M scope=spfile;
alter system set undo_retention=10800 scope=spfile;

undo_retention
job_queue_processes
alter system set job_queue_processes=10 scope=spfile;
alter system set open_cursors=800 scope=spfile;

cursor_sharing
_lm_rcvr_hang_allow_time

alter system set cursor_sharing=force scope=spfile;
alter system set "_optim_peek_user_binds"=false scope=spfile;
alter system set audit_trail=NONE scope=spfile;
alter system set "_b_tree_bitmap_plans"=false scope=spfile;


alter system set "_lm_rcvr_hang_allow_time"=300 scope=spfile;
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
alter system set "_clusterwide_global_transactions"=false scope=spfile;
alter system set optimizer_index_caching =90 scope=spfile;
alter system set optimizer_index_cost_adj =10 scope=spfile;
alter system set shared_pool_size=800M scope=spfile;