oracle巡检报告模板篇一：Oracle 数据库深度巡检报告南方基地RAC数据库深度检查报告上海新炬网络技术有限公司XX年08文档控制此文档仅供新炬公司与最终用户审阅，不得向与此无关的个人或机构传阅或复制。

修改记录分发者审阅记录相关文档1、数据库相关AWR报告 1. 实例rac1: awrrpt_1_11063_ awrrpt_1_11129_ 2. 实例rac2: awrrpt_2_11063_ awrrpt_2_11129_目录文档控制 ................................................ ................................................... (2)修改记录 ................................................ ................................................... .. (2)分发者 ................................................ ................................................... (2)审阅记录 ................................................ ................................................... .. (2)相关文档 ................................................ ................................................... .. (2)目录 ................................................ ................................................... .. (2)1. 检查介绍 ................................................ ................................................... (5)2. 检查系统 ................................................ ................................................... ............5 检查方法 ................................................ ................................................... ............5 检查范围 ................................................ ................................................... ............5 检查总结 ................................................ ................................................... . (7)概要 ................................................ ................................................... ....................7 总结建议 ................................................ ................................................... ............7 主机性能指标 ................................................................................................... ....7 数据库性能指标 ................................................ ...................................................83. 硬件配置 ................................................ ................................................... . (9)主机配置 ................................................ ................................................... ............9 共享内存参数 ................................................ ..................... 错误！未定义书签。

网络参数(For RAC) .............................................. ............. 错误！未定义书签。

内核参数 ................................................ ............................. 错误！未定义书签。

操作系统中与数据库相关主要参数 ................................................ . (9)4. 系统配置 ................................................ ................................................... .. (10)硬盘可用空间 ................................................ ................................................... ..10 CPU 利用率 ................................................ ................................................... . (10)5. 数据库配置 ................................................ ................................................... . (14)CRS版本和单独补丁 ................................................ .........................................14 数据库版本和单独补丁 ................................................ .....................................16 ORACLE CLUSTER配.................................19 数据库产品选项 ................................................ ................. 错误！未定义书签。

初始化参数文件 ................................................ . (20)CRS日志文件 ................................................ ................................................... .22 RDBMS运行日志和跟踪文件 ................................................ ...........................23 控制文件 ................................................ ................................................... ..........25 Redo log 文件 ................................................ ...................................................25 归档Redo log 文件 ................................................ ...........................................26 数据文件 ..........................................................26 表空间 ................................................ ................................................... ..............27 回滚段管理 ................................................ ................................................... (29)6. 数据库简单风险评估 ................................................ (29)安全性管理 ................................................ ................................................... (31)7. SqlNet 概况 ................................................ ................................................... .. (32)监听器Listener .......................................... ................................................... (32)TNSNAMES .......................................... ................................................... ..........32 监听器状态 ................................................ ................................................... (32)8. 数据库性能 ................................................ ................................................... . (35)数据库各项基于时间模型的统计信息 ................................................ . (36)等待事件 ................................................ ................................................... . (36)AWR统计信息分析 ................................................ .. (37)数据库I/O性................................................... .38索引/行迁移/行链 ................................................ .. (42)Enqueue等待分析 ................................................ (43)Latch分析 ................................................ ................................................... .. (44)Resource Limit分析 ................................................ (44)Top SQL语句 ................................................ ................................................... ..45SQL ordered by Elapsed Time ..............................................SQL ordered by CPU Time .............................................. ................................................... .47SQL ordered by Gets .............................................. ................................................... (48)SQL ordered by Reads ............................................. ................................................... .. (50)9. 数据库备份策略评估 ................................................ (53)备份 ................................................ ................................................... ..................53 恢复 ................................................ .................................................(来自: 小龙文档网:oracle巡检报告模板) (55)附录:初始化参数文件 ................................................ ............................. 错误！未定义书签。