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