CHAPTER 24The AWR and the Alert System

Exam Objectives

In this chapter you will learn to

• 052.12.2 Use and Manage Automatic Workload Repository (AWR)

• 052.12.3 Use Advisory Framework

• 052.12.4 Manage Alerts and Thresholds

The manageability infrastructure provided with Oracle Database 11g can be used to automate a significant amount of the database administrator’s day-to-day work. With earlier releases, monitoring the database in order to pick up developing problems before they became critical took too much time. Identifying and diagnosing performance issues was not only time-consuming but also required much skill. Use of the Alert system and the diagnostic advisors, installed as standard in every 11g database, frees the DBA from the necessity ...

Get OCA/OCP Oracle Database 11g All-in-One Exam Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.