修改oracle配置参数

"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;