文件名称：ORACLE 健康检查与性能分析报告
文件大小：453KB
文件格式：PDF
更新时间：2015-05-03 04:57:47
ORACLE 健康检查与性能分析报告
ORACLE 健康检查与性能分析报告,内容包括: 1: 报告综述..........................................................................................................3 1.1 目的说明....................................................................................... 3 1.2 Server整体状况............................................................................. 3 2: 主机与数据库配置...............................................................................................4 2.1 主机配置.......................................................................................... 4 3: 操作系统可用性..................................................................................................5 3.1 文件系统使用状况............................................................................... 5 3.2 操作系统性能分析............................................................................... 5 4: 数据库可用性....................................................................................................7 4.1 Database Session Chart................................................................. 7 4.2 日志文件状态..................................................................................... 7 4.3 控制文件状态..................................................................................... 9 4.4 归档日志状态................................................................................... 10 4.5 表空间使用状况................................................................................ 10 4.6 数据库文件读写状况.......................................................................... 11 4.7 Invalid Objects............................................................................ 12 4.8 Disabled Triggers ........................................................................ 12 4.9 数据库备份状况................................................................................ 13 4.10 数据库恢复................................................................................... 13 5: 数据库性能分析................................................................................................14 5.1 Shared Pool HitRatio ................................................................... 14 5.3 Library hit ratio ........................................................................... 15 5.4 Usage Index ................................................................................ 15 5.5 Top 20 Low Performance SQL...................................................... 19 5.6 Top 20 Long running SQL ............................................................ 21 6: 数据库改善建议................................................................................................25 7：性能建议.......................................................................................................25