oracle参数调优
备份数据库参数文件创建参数文件备份便于后续恢复createpfile/oracle/app/initorcl20200528.orafromspfile;核心数据库参数调整修改数据文件数量限制altersystemsetdb_files1000scopespfile;禁用延迟段创建altersystemsetdeferred_segment_creationfalsescopeboth;密码策略调整12c不推荐altersystemsetsec_case_sensitive_logonfalsescopeboth;-- 恢复设置altersystem reset sec_case_sensitive_logon scopespfile;密码永不过期设置alterprofiledefaultlimitpassword_life_time unlimited;游标配置优化查看当前游标使用峰值SELECTMAX(a.value)ASmax_open_cursorsFROMv$sesstat a,v$statname bWHEREa.statistic# b.statistic#ANDb.nameopened cursors current;设置游标参数OLTP/OLAP场景参考altersystemsetopen_cursors500scopespfile;altersystemsetsession_cached_cursors50scopespfile;执行计划优化调整索引扫描成本altersystemsetoptimizer_index_cost_adj25scopespfile;内存管理配置内存参数设置需重启altersystemsetmemory_max_target45G scopespfile;altersystemsetmemory_target45G scopespfile;altersystemsetsga_max_size32G scopespfile;altersystemsetsga_target32G scopespfile;altersystemsetpga_aggregate_target8G scopespfile;网络连接参数sqlnet.ora配置SQLNET.INBOUND_CONNECT_TIMEOUT30 SQLNET.ALLOWED_LOGON_VERSION_SERVER10listener.ora配置INBOUND_CONNECT_TIMEOUT_LISTENER25参数应用说明数据库参数修改后需要重启实例生效网络参数修改后需要重启监听生效内存配置建议不超过物理内存的80%OLTP系统建议优先考虑索引扫描优化游标配置需根据实际并发量动态调整
（支持资料、图片参考_相关定制）_)
