My Oracle Support Banner

How to Generate an AWR Report and Create Baselines (Doc ID 748642.1)

Last updated on DECEMBER 27, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Net Services - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Goal

This Document outlines how to generate an AWR report and create baselines using both Database scripts and functionality within the DBMS_WORKLOAD_REPOSITORY package. It covers topics such as generating various types of AWR reports and manually creating AWR snapshots. It also covers various topics on AWR baselines.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 Running a Basic Report
 Generating Various Types of AWR Reports
 AWR Snapshots
 How to Modify the AWR SNAPSHOT SETTINGS:
 Creating a SNAPSHOT Manually:
 Dropping the AWR snaps in range:
 AWR Baselines
 Creating a Baseline:
 Dropping an AWR baseline:
 We can also specify a template for creating and dropping baseline based on repeating time periods:
 Workload Repository Views
 Automation of AWR reports ?
 License Needed to Use AWR
 Community Discussions
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.