AWR Review Checklist

Snapshot Range Reviewed (Begin Snapshot ID - End Snapshot ID): _____________________________

Time Window (Start Time – End Time): _________________________

  1. SYSTEM LOAD
    • DB Time per Second:
      • Value: ________ — Is it high for this system?
    • CPU Usage per Second:
      • Value: ________ — Is DB Time >> CPU time? Suggests waits.
    • Executions per Second:
      • Value: ________ — Is there a spike or dip?
  2. TOP WAIT EVENTS
    Wait Event Time (s) Notes [ e.g., temp spill, I/O, locking ]
    1.    
    2.    
    3.    
  3. TOP SQL STATEMENTS
    SQL_ID Metric Value Comment (slow/overused/etc.)
    Elapsed Time  
      Buffer Gets    
      Executions    
  4. TEMPORARY SPACE USAGE
    • Temp Waits (for example, direct path read/write temp):
      • Observed? Yes / No
      • Notes: ___________________________________________
    • Operations likely causing spills (sorts, joins, and so on): ___________________________________________
  5. INSTANCE EFFICIENCY RATIOS
    • Buffer Cache Hit Ratio: _________ %
    • Parse to Execute Ratio: _________ (High = too many hard parses?)
  6. NOTABLE CHANGES COMPARED TO BASELINE
    Area What Changed Details
    Workload Increased / Decreased
    Waits New / Increased  
    Top SQL Changed / Same  
  7. INITIAL CONCLUSION / NEXT STEP

    _____________________________________________________

    (for example, Investigate temp usage, tune top SQL, compare plans, escalate to support)