Chapter 9. Proactive Database Maintenance and Performance Monitoring
ORACLE DATABASE 10 G: ADMINISTRATION I EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Performance Monitoring
Troubleshoot invalid and unusable objects.
Gather optimizer statistics.
View performance metrics.
React to performance issues.
Proactive Maintenance
Set warning and critical alert thresholds.
Collect and use baseline metrics.
Use tuning and diagnostic advisors.
Use the Automatic Database Diagnostic Monitor (ADDM).
Manage the Automatic Workload Repository.
Describe server generated alerts.
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Training and Certification website (http://www.oracle.com/education/certification/) for the most current exam objectives listing.
Successful database administrators are always on the lookout for potential database problems that could adversely impact the availability or performance of the systems they manage. Historically, DBAs have resorted to third-party monitoring tools, Oracle's Enterprise Manager suite, or home-grown SQL scripts to gather, store, and analyze database information.
In Oracle Database 10g (Oracle 10g ), however, several new features allow you to easily collect and analyze database performance statistics and proactively respond to problems when they are detected in the database. These new features include the Automatic Workload Repository (AWR), Automated Database Diagnostic Monitoring (ADDM), and the Oracle 10g Tuning and Diagnostic Advisors.
In this chapter, we will look at these features in detail.