O'Reilly logo

OCA/OCP Oracle Database 11g All-in-One Exam Guide with CD-ROM : Exams 1Z0-051, 1Z0-052, 1Z0-053 by Bob Bryla, Roopesh Ramklass, John Watson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required