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

Overview/Description
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 (hours)
3.2

Lesson 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.