目 录
文档控制............................................................................................................................ .... .2
检查总结............................................................................................................................ .... .5
概要.....................................................................................................................................5
总体概况.............................................................................................................................5
优化建议.............................................................................................................................5
介绍.................................................................................................................................... .... .6
目标.....................................................................................................................................6
检查方法............................................................................................................................6
检查范围............................................................................................................................6
数据库配置分析................................................................................................................ .... .7
硬件配置.............................................................................................................................7
软件配置.............................................................................................................................7
数据库参数.........................................................................................................................8
控制文件.............................................................................................................................9
Temporary Tablespace.........................................................................................................9
表空间管理.........................................................................................................................9
回滚段...............................................................................................................................10
无效对象,约束和 trigger...............................................................................................10
数据库日志 ALTER LOG 分析.......................................................................................11
数据库性能分析.............................................................................................................. .... .12
数据库实例性能命中率...................................................................................................12
等待事件(Top Wait Events)..............................................................................................12