AWR Baseline

AWR Baselines

AWR Baseline contains a set of AWR snapshots for an “interesting or reference” period of time.

• Monitor the current state of the database instance and compare it to a previous state.
• Examine AWR or Statspack reports and instance files carefully.

Objectives

• Create AWR baselines
• Enable adaptive thresholds
• Create AWR baselines for future time periods
  
  

Topics

1. Automatic Workload Repository Baselines
2. Moving Window Baseline
3. Creating AWR Baselines
4. Performance Monitoring and Baselines
   
5. Defining Alert Thresholds Using a Static Baseline
6. Automatic Workload Repository Baselines
7. Baselines in Performance Page Settings
8. Managing Baselines with PL/SQL
9. Using EM to Configure and Changing Adaptive Threshold Settings
10. Comparative Performance Analysis with AWR Baselines

Refer the links below:

Resolving Performance Degradation Over Time
Using Automatic Workload Repository for Database Tuning: Tips for Expert DBAs