10 Monitoring and Tuning the Database

Monitoring the health of a database and ensuring that it performs optimally is an important task for a database administrator. This chapter discusses the features and functionality included in Oracle Database that make it easy to proactively monitor database health, identify performance problems, and implement any corrective actions.

The following topics are covered:

• Proactive Database Monitoring

• Diagnosing Performance Problems

• Using Advisors to Optimize Database Performance

• Monitoring and Tuning: Oracle by Example Series