Oracle 12c Performance Tuning: Automatic Workload Repository

Database Administrators, Application Developers, Technical Consultants and learners looking to obtain the Oracle Database 12c: Performance Management and Tuning certification.

Prerequisite
None

Expected Duration
70 minutes

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

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.