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. 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. 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.

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

   The Compute Threshold Statistics page appears.

5. In the Name field, enter a name for the task.

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

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

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

7. 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.

8. Click Submit.

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