List of Figures

• 2-1 Workload Growth Curve
• 7-1 Physical I/O and Buffer Cache Size
• 7-2 Redo Log Buffer
• 7-3 Graphical Representation of V$PGA_TARGET_ADVICE
• 7-4 Client Result Cache
• 8-1 Distributing Redo Members Across Disks
• 8-2 Sample I/O Load Levels
• 8-3 I/O Throughput at Different Small I/O Load Levels
• 8-4 I/O Latency at Small I/O Load Levels
• 9-1 Average Workload and Peak Workload
• 10-1 Scattered Read, Sequential Read, and Direct Path Read
• 11-1 Optimizer Components
• 12-1 A Table Hierarchy
• 13-1 Height-Balanced Histogram with Uniform Distribution
• 13-2 Height-Balanced Histogram with Non-Uniform Distribution
• 15-1 SQL Plan Baseline and SQL Plan History
• 17-1 Automatic SQL Tuning
• 17-2 SQL Tuning Advisor APIs
• 17-3 SQL Tuning Sets APIs
• 17-4 SQL Profile
• 17-5 SQL Profile APIs
• 18-1 Materialized Views and SQL Access Advisor
• 18-2 SQL Access Advisor Flowchart