版权声明：转载请注明出处:http://blog.csdn.net/dajitui2024 https://blog.csdn.net/dajitui2024/article/details/79396645
"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;