OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062), 2nd Edition

CERTIFICATION OBJECTIVES

14.01   Manage Optimizer Statistics

14.02   Use the SQL Tuning Advisor

14.03   Use the SQL Access Advisor to Tune Workload

        Two-Minute Drill

Q&A   Self Test

Chapter 13 introduced some aspects of instance tuning—principally, memory management. Although tuning the instance as a whole is important, it must be emphasized that all tuning should be oriented toward business problems. That means tuning SQL statements in order to meet business requirements for response time.

Generally speaking, the approach to take toward ...