推荐《Oracle Database 10g Performance Tuning Tips and Techniques》,Oracle性能测试诊断分析与优化可参考!
CHAPTER 2 Basic Index Principles (Beginner Developer and Beginner DBA) , 做Oracle索引优化可参考!
CHAPTER 4 Tuning the Database with Initialization Parameters (DBA) ,通过调整初始化参数优化Oracle数据库
CHAPTER 6 Using EXPLAIN and STORED OUTLINES (Developer and DBA) 查询执行计划,如何解读出性能问题是关键所在
CHAPTER 8 Query Tuning: Developer and Beginner DBA,查询优化,如何找到执行效率低的SQL语句、如何解读AWR快照、如何使用Automatic SQL Tuning
CHAPTER 12 The V$ Views (Developer and DBA) , 掌握与性能相关的V$视图
CHAPTER 14 Using STATSPACK and the AWR Report to Tune Waits and Latches,AWR在性能监控、诊断分析方面有丰富的信息