Automatic SQL Tuning
Average Workload and Peak Workload
Client Result Cache
Distributing Redo Members Across Disks
Graphical RepresentatI/On of V$PGA_TARGET_ADVICE
I/O Throughput at Different Small I/O Load Levels
Latency at Small I/O Load Levels
Materialized Views and SQL Access Advisor
Optimizer Components
Physical I/O and Buffer Cache Size
Redo Log Buffer
Sample I/O Load Levels
Scattered Read, Sequential Read, and Direct Path Read
SQL Plan Baseline and SQL Plan History
SQL Profile APIs
SQL Profile
SQL Tuning Advisor APIs
SQL Tuning Sets APIs
Steps for Using SQL Access Advisor