Oracle Database 10g: New Automatic Management and Management Infrastructure Features

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

Overview

To identify the new automatic management and management infrastructure features of Oracle 10g

Target Audience

Oracle 9i certified professionals who wish to upgrade to Oracle Database 10g certification; developers interested in the technical aspects of Oracle Database 10g

Prerequisites

Experience in the administration of Oracle 8i or 9i databases

Expected Duration

190 min.

Course Objectives

Oracle Database 10g: New Automatic Management and Management Infrastructure Features

  • work with the Automatic Database Diagnostic Monitor (ADDM) in Oracle Database 10g.
  • perform the tasks and calculations associated with the configuration and management of Automatic Shared Memory Management in Oracle Database 10g.
  • view Automatic Database Diagnostic Monitor (ADDM) findings and manage shared memory in Oracle Database 10g in a given scenario.
  • perform the key tasks associated with Oracle Database 10g’s new statistics collection feature.
  • use the appropriate code to lock and view automatically gathered statistics in Oracle Database 10g.
  • identify the key components and concepts of Oracle 10g’s new Automatic Workload Repository (AWR) feature.
  • set AWR statistics capturing and snapshot purging in Oracle Database 10g.
  • perform the tasks in a typical advisor tuning session in Oracle Database 10g.
  • manually invoke the ADDM advisor to analyze an Oracle system in a given scenario.
  • identify the alert process and alert types in Oracle Database 10g.
  • set alerts and view metrics and server alert information in Oracle Database 10g.
  • change an alert threshold and edit a notification rule in a given scenario in Oracle Database 10g.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?