Oracle Database 10g Performance Tuning tips and techniques is recommended. For Oracle performance test, diagnosis, analysis, and optimization, see!
Chapter 2 Basic index principles (beginner developer and beginner dBA). For Oracle index optimization, refer!
Chapter 4 tuning the database with initialization parameters (DBA), optimize the Oracle database by adjusting the initialization parameters
Chapter 6 using explain and stored outlines (developer and DBA) query execution plans. How to interpret performance problems is the key
Chapter 8 query tuning: developer and beginner dBA, query optimization, how to find SQL statements with low execution efficiency, how to interpret AWR snapshots, and how to use automatic SQL Tuning
Chapter 12 The V $ views (developer and DBA), master the performance-related v $ View
Chapter 14 using statspack and the AWR report to tune waits and latches. AWR has rich information in performance monitoring and diagnostic analysis.