OCP Oracle Database 11g Administration II Exam Guide, 2nd Edition

11Using Database Tuning Advisors

CERTIFICATION OBJECTIVES

11.01 Use the SQL Tuning Advisor

11.02 Use the SQL Access Advisor to tune a workload

11.03 Understand Database Replay

Two-Minute Drill

Self Test

From a tuning perspective, every system has a performance bottleneck that may move from component to component over a time period of days or even weeks The goal of performance design is to make sure that the physical limitations of the applications and the associated hardware—I/O throughput rates, memory sizes, query performance, and so on—do not ...