When to Escalate or Log a Baseline

If the AWR shows a shift in workload or a clear new bottleneck, capture and store:

  • The report ID
  • Top SQLs (SQL_ID and plan hash)
  • Wait events
  • Load profile

This gives you a complete snapshot to compare after changes or to include when engaging support.