Linux环境安装Oracle11g(四)——软件安装及参数优化

五、软件安装 解压两个安装包（解压前先改权限 root用户：chmod 777 /stage）

root用户在/u01下建目录 mkdir /u01/install_db chown oracle:oinstall install_db

root用户 改压缩包权限 chown oracle:oinstall .....

oracle 用户解压（1of7&2of7） cd /u01/install_db  unzip ***.zip -d ./

export DISPLAY=IP:0.0cd /stage/database  ./runInstaller

六、参数调整

限制ASSM调整范围 SGA_TARGET=DB_CACHE_SIZE+DB_nK_CACHE_SIZE+SHARED_POOL_SIZE+1GB/2GB

控制文件保留时间 alter system set control_file_record_keep_time=60;

恢复LGWR的post/wait通知方式 alter system set "_use_adaptive_log_file_sync"=false sid='*' scope=spfile;

死事务回滚调整 限制回滚进程数 alter system set fast_start_parallel_rollback=low; alter system set recovery_parallelism=10 scope=spfile;

配置每次回滚记录数 alter system set "_cleanup_rollback_entries"=10000 scope=spfile;

解除密码过期限制 alter profile default limit PASSWORD_LIFE_TIME unlimited; alter profile default limit PASSWORD_LOCK_TIME unlimited; alter profile default limit PASSWORD_GRACE_TIME unlimited;

AWR收集间隔 AWR收集间隔修改为30分钟，保留期限为30天     exec dbms_workload_repository.modify_snapshot_settings(interval=>30, retention=>30*24*60);

禁用“Automatic SQL Tuning Advisor” exec dbms_auto_task_admin.disable(client_name => 'sql tuning advisor',operation => NULL,window_name => NULL);

禁用“Auto Space Advisor” exec dbms_auto_task_admin.disable(client_name => 'auto space advisor',operation => NULL,window_name => NULL);

数据文件安全 alter system set "_datafile_write_errors_crash_instance"=false scope=spfile;

开启BCT 如果启用增量备份，则开启BCT。 alter database enable block change tracking using file '+DATA';

设置28401和10949事件 alter system set event='28401 trace name context forever,level 1', '10949 trace name context forever,level 1' sid='*' scope=spfile;

关闭密码大小写敏感 alter system set sec_case_sensitive_logon=false scope=spfile sid='*';

设置dump文件大小上限 alter system set max_dump_file_size='4096M' scope=spfile sid='*';

调整默认分区大小 alter system set "_partition_large_extents"=false scope=spfile sid='*';

设置并行子进程的数量上限 alter system set parallel_max_servers=128 scope=spfile sid='*';

关闭初始化extent的延迟创建 alter system set deferred_segment_creation=false scope=spfile sid='*';

关闭result_cache alter system set result_cache_max_size=0 scope=spfile sid='*';

关闭登录、登出的审计日志 noaudit create session;

关闭自适应游标共享 alter system set "_optimizer_adaptive_cursor_sharing"=false sid='*' scope=spfile; alter system set "_optimizer_extended_cursor_sharing"=none sid='*' scope=spfile; alter system set "_optimizer_extended_cursor_sharing_rel"=none sid='*' scope=spfile;

关闭Cardinality feedback alter system set "_optimizer_use_feedback"=false sid ='*' scope=spfile;

使并行会话改为使用Large Pool alter system set "_px_use_large_pool"=true  sid ='*' scope=spfile;

SGA自动调整间隔设置 alter system set "_memory_broker_stat_interval"=999;

并行执行Message大小 alter system set parallel_execution_message_size=2148 scope=spfile;