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