Title: Chapter 11: Using Database Tuning Advisors
Course: DEPT MC - ORACLE DATABASE MANAGEMENT II > Section: Unit 3 - Database Administration II

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 impact performance of the business of the company. If the application performance limits the business process it is supposed to be supporting, the application must be tuned. During the design process, the limits of the application environment—including the hardware and the design of the application’s interactions with the database—must be evaluated. No environment provides infinite computing capacity, so every environment is destined to fail at some performance point. In the process of designing the application, you should strive to have your performance needs amply served by the performance capabilities of the environment.

Chapter 8 Learning Outcomes:

- Ability to Use the SQL Tuning Advisor
- Ability to Use the SQL Access Advisor to tune a workload
- Describe Database Replay

*Quizzes for Chapters 11 through 15 are all open until Exam 3 date.

One of the most important things to be successful in this course is to learn to navigate and locate assignments and information.  When in doubt, go to Modules!