11G OCM Configure baseline templates

References

Oracle® Database 2 Day + Performance Tuning Guide 11g Release 1 (11.1)

• Chapter 8, "Resolving Performance Degradation Over Time"
  • Managing Baselines
    • Creating a Baseline
      • Creating a Single Baseline
      • Creating a Repeating Baseline

Overview

The objective from the 11G OCM Upgrade Exam is:

Configure baseline templates

Reading Notes

In Creating a Single Baseline,:

You can choose a start time and an end time that are in the future to create a baseline that captures future database activity. If both the start time and the end time are in the future, a baseline template with the same name as the baseline will also be created. A baseline template is a specification that enables Oracle Database to automatically generate a baseline for a future time period.

Emphasis Mine

A baseline template can also be repeating. (See Creating a Repeating Baseline.)

Procedure

To create a single baseline

Use OEM as per Creating a Single Baseline:

1. From the Database Home page, click Server.
2. Under Statistics Management, click AWR Baselines.
3. Click Create