• Online, Self-Paced
Course Description

This course introduces the Automatic Workload Repository, which is the infrastructure that provides services to Oracle Database components to collect, maintain, and use statistics for problem detection and self-tuning purposes. The Automatic Database Diagnostic Monitor is also discussed, and we will see how Active Session History can assist in more granular problem solving situations. This course is one of a series in the Skillsoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).

Learning Objectives

Overview of AWR

  • start the course
  • describe the Automatic Workload Repository
  • describe the types of statistics stored in AWR and the AWR architecture
  • describe how AWR is administered
  • use a PL/SQL package to manage and modify AWR snapshot settings


AWR Snapshots and Reports

  • use EM cloud control and SQL*Plus to generate an AWR report
  • describe the sections of an AWR report
  • describe how to compare two periods in AWR
  • describe the structure of an AWR comparison report


Automatic Database Diagnostic Monitor

  • describe the ADDM infrastructure
  • describe the ADDM methodology
  • use EM cloud control to identify and review ADDM results
  • describe how to create an ADDM task manually and to modify ADDM attributes
  • describe the ADDM comparison report and compare to its AWR counterpart
  • describe the components of an ADDM comparison report


Using Active Session History

  • describe the ASH infrastructure
  • specify where to locate the ASH data and how to analyze it
  • describe how to generate an ASH report
  • describe the components of an ASH report


Using Real-Time ADDM

  • describe the challenges and goals of Emergency Monitoring
  • describe the challenges and goals of Real-Time ADDM
  • describe the benefits of Real-Time ADDM
  • use EM cloud control to invoke Real-Time ADDM and view the results


Practice : Using the Automatic Workload Repository

  • use EM cloud control to generate and review an AWR report


Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration
  • Systems Development