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