Computing Threshold Statistics for Baselines

Computing threshold statistics for baselines enables you to graphically display the computed statistics in the charts on the Performance page.

To compute threshold statistics for baselines:

1. Access the AWR Baselines page, as explained in "Creating a Single Baseline".
2. Select the baseline for which you want to compute statistics.

   Select a baseline that does not already have computed statistics. These baselines are identified by No in the Statistics Computed column.

3. From the Actions list, select Schedule Statistics Computation, and then click Go.

   The Compute Threshold Statistics page appears.

   This example computes statistics for the baseline BASELINE_TUE_1120.

   
   Description of the illustration compute_threshold_stats.gif
4. In the Name field, enter a name for the task.

   Alternatively, you can choose to use the system-generated name.

5. In the Description field, enter a description for the task.

   Alternatively, you can choose to use the system-generated description.

6. Under Start, do one of the following:

   • Select Immediately to run the task immediately after it has been submitted.

   • Select Later to run the task at a later time as specified using the Date and Time fields.

   This computation is resource-intensive, so you may want to schedule it to run during off-peak hours.

7. Click Submit.

   The AWR Baselines page appears. A message informs you that statistics computation has been scheduled for the selected baseline.

See Also:

"Customizing the Database Performance page" for information about displaying computed statistics on the Performance page