Oracle Database 10g: Monitoring and Maintenance

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

  • 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 the segment advisor to detect storage problems in a given scenario.
  • recognize how to manage the AWR and use the ADDM to review database performance.
  • configure a database for proactive maintenance.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?