Overview/Description
Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual AWR reports as well as AWR compares period reports. It discusses the identification of performance issues, setting the tuning priorities, how to tune depending on the particular application life cycle phase, and the steps involved in implementing migration, upgrade, and environment changes. The course also delves into the area of interpreting tuning diagnostics using Statspack – a set of scripts and PL/SQL packages that allow you to capture point-in-time performance data. It explains how to capture and manage Statspack snapshots and the generation and usage of Statspack reports for diagnostic analysis.
Target Audience
A range of in-training or established IT professionals; Database Administrators; Support Engineers; Technical Consultants.
Prerequisites
Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II