Oracle Database 10g: Monitoring and Maintenance Release 2

This course is included in our On-demand training solution.

Overview

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

160 min.

Course 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.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?