ORACLE数据库健康检查与评估
XXXXX
Oracle数据库健康检查与评估
XXXX
巡检人: 报告生成日期:
yyyy-mm-dd
文档操纵
此文档仅供江苏移动批阅,不得向与此无关的个人或机构传阅或复制。
修改记录
分发者
批阅记录
相关文档
日期 作者 版本 修改记录 、姓名 职位 姓名 职位
名目
文档操纵 ....................................................................................................................................2
修改记录 .............................................................................................................................2 分发者 .................................................................................................................................2 批阅记录 .............................................................................................................................2 相关文档 .............................................................................................................................2 名目 ............................................................................................................................................3 1.
1.1 1.2 2.
2.1 3.
3.1 3.2 3.3 4.
检查介绍 ......................................................................................................................5
检查系统 ...............................................................................................................5 检查范畴 ...............................................................................................................5 硬件配置 ......................................................................................................................7
主机配置 ...............................................................................................................7 系统配置 ......................................................................................................................8
操作系统数据库相关要求补丁 ...........................................................................8 硬盘可用空间 .......................................................................................................8 CPU 利用率 ........................................................................................................8 数据库配置 ................................................................................................................10 4.1 4.2 4.3 4.4 4.5 4.6 4.7 4.8 4.9 4.10 4.11 4.12 4.13 5.
5.1 6.
6.1 6.2 6.3 7.
7.1 7.2 7.3 7.4
数据库版本和单独补丁 .....................................................................................10 CRS版本和单独补丁 ........................................................................................10 ORACLE CLUSTER配置 ...............................................................................10 数据库产品选项 .................................................................................................10 初始化参数文件 .................................................................................................11 CRS日志文件 ....................................................................................................11 RDBMS运行日志和跟踪文件 ..........................................................................11 操纵文件 .............................................................................................................11 Redo log 文件 ..................................................................................................12 归档Redo log 文件 ..........................................................................................13 数据文件 .............................................................................................................13 表空间 .................................................................................................................14 回滚段治理 .........................................................................................................15
数据库简单风险评估 ................................................................................................17
安全性治理 .........................................................................................................17 SqlNet 概况 .............................................................................................................18
监听器Listener .................................................................................................18 SQL*Net ............................................................................................................18 TNSNAMES ......................................................................................................18 数据库性能 ................................................................................................................19
数据库各项基于时刻模型的统计信息 .............................................................19 数据库负荷压力分析 .........................................................................................20 各项命中率 .........................................................................................................21 等待事件 .............................................................................................................21