Creating a Single Baseline

A single baseline is captured at a single, fixed time interval. For example, a single baseline may be captured on February 5, 2009 from 5:00 p.m. to 8:00 p.m.

You can choose future start and end times to create a baseline that captures future database activity. If both the start time and the end time are in the future, then 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.

To create a single 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 Single.

5. Click Continue.

   The Create Baseline: Single Baseline page appears.

6. In the Baseline Name field, enter a name for the baseline.

7. Under Baseline Interval, select whether to use a snapshot range or a time range for the baseline. Do one of the following:

   • To use a range, select Snapshot Range. Complete the following steps:

     • Under Select Time Period, select a start time for the baseline by selecting Period Start Time and the snapshot icon below the Active Sessions chart that corresponds to the desired start time.

     • Select an end time for the baseline by selecting Period End Time and the snapshot icon below the Active Sessions chart that corresponds to the desired end time.

     • Optionally, to view older snapshots that are not displayed below the Active Sessions chart, expand Change Chart Time Period. Enter the desired start date in the Chart Start Date field and the desired end date in the Chart End Date field, and click Go.

   • To use a time range, select Time Range. Complete the following steps:

     • In the Start Time fields, select a start time for the baseline.

     • In the End Time fields, select an end time for the baseline.

8. Click Finish.

   The AWR Baselines page reappears with the newly created baseline displayed.