1. Get Started with Performance Tuning
  2. Reactive Database Tuning
  3. Resolving Performance Degradation Over Time
  4. Using the AWR Compare Periods Reports
  5. Summary of the AWR Compare Periods Report
  6. Top Timed Events

Top Timed Events

The Top Timed Events section is one of the most useful sections in the report. This section displays the five timed events or operations that consumed the highest percentage of total DB time in each of the snapshot sets.

Description of awr_top5_timed_events.gif follows
Description of the illustration awr_top5_timed_events.gif

In this example, CPU time and the number of waits for database file sequential reads are significantly higher in the first period than in the second.