Creating a Repeating Baseline

A repeating baseline is a baseline that repeats during a time interval over a specific period. For example, a repeating baseline may repeat every Monday from 8:00 a.m. to 10:00 a.m. from February 6, 2009 to February 6, 2010.

To create a repeating baseline: 

1. From the Database Home page, click Server.

   The Server page appears.

2. Under Statistics Management, click AWR Baselines.

   The AWR Baselines page appears with a list of existing baselines displayed.

3. Click Create.

   The Create Baseline: Baseline Interval Type page appears.

4. Select Repeating and then click Continue.

   The Create Baseline: Repeating Baseline Template page appears.

5. In the Baseline Name Prefix field, enter a name prefix for the baseline.

6. Under Baseline Time Period, specify the time of the day that you want the baseline to begin collecting AWR data and the duration of the baseline collection.

7. Under Frequency, do one of the following:

   • Select Daily if you want the baseline to repeat on a daily basis.

   • Select Weekly if you want the baseline to repeat on a weekly basis, and then select the day of the week on which the baseline will repeat.

8. Under Interval of Baseline Creation, complete the following steps:

   1. In the Start Time fields, select a date and time in the future when the data collection should begin.

   2. In the End Time fields, select a date and time in the future when the data collection should end.

9. Under Purge Policy, enter the number of days to retain captured baselines.

10. Click Finish.

    A baseline template with the same name as the baseline name prefix will be created. A baseline template is a specification that enables Oracle Database to automatically generate a baseline for a future time period.