Oracle Database 10g: Monitoring and Maintenance Release 2

Overview/Description
To demonstrate how to control database performance and configure proactive database maintenance

Target Audience
Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites
An understanding of database concepts and technologies

Expected Duration (hours)
2.7

Lesson Objectives

Oracle Database 10g: Monitoring and Maintenance Release 2

repair invalid and unusable objects.

detect and repair unusable indexes.

recognize how to monitor performance using dynamic performance views, Enterprise Manager, and optimizer statistics.

gather optimizer statistics for a database schema.

set thresholds and baselines for performance metrics.

identify the functions of various tuning and diagnostic advisors, and use them in a given scenario.

recognize how to manage the AWR and use the ADDM to review database performance in Oracle Database 10g.

configure a database for proactive maintenance.