Creating AWR Baselines

You can create two types of AWR baselines: single and repeating. The Create Baseline: Baseline Interval Type page gives the following explanations.

The single type of baseline has a single and fixed time interval: for example, from Jan 1, 2007, at 10:00 AM, to Jan 1, 2007, at 12:00 PM. The repeating type of baseline has a time interval that repeats over a time period: for example, every Monday from 10:00 AM to 12:00 PM for the year 2007.

To view the AWR Baseline page, click the AWR Baselines link on the Server tab of the Database Instance page (Server > AWR Baselines). On the Baseline page, click Create and follow the wizard instructions to create your baseline.

Note: Before you can set up AWR baseline metric thresholds for a particular baseline, you must compute the baseline statistics. Select Schedule Statistics Computation from the actions menu to compute the baseline statistics. There are several other actions available.

Single AWR Baseline

If you selected the Single option in the previous step, you access the page shown in this slide.
Select the time period corresponding to your interest in one of two ways:

•          Select the Snapshot Range option, and then set the period start time and period end time by following the directions on the page. If the icon that you want to select is not shown, you can change the chart time period.

•          Specify the time range, with a date and time for start and end times. With the Time Range option, you can choose times in the future.

When you are finished, click Finish to create the static baseline.

Note: If the end time of the baseline is in the future, a baseline template with the same name as the baseline will be created.

Creating a Repeating Baseline Template

You can define repeating baselines by using Enterprise Manager. In the wizard, after selecting Repeating in step 1, you can specify the repeat interval as shown in this slide. You specify the start time and the duration of the baseline. Then specify when the baseline statistics will be collected (daily or weekly; if weekly, for which days). Specify the range of dates for which this baseline template will collect statistics. Retention Time sets an expiration value for the baseline; a value of NULL indicates that the baseline never expires.

How to create repeating Baseline

After click on create select Repeating option you will get the following screen.