Automatic Workload Repository

Automatic Workload Repository — Oracle's built-in repository of periodic database performance snapshots used for workload, wait-event, SQL, and resource analysis.

Oracle Runtime Context

AWR is most useful for comparing intervals and identifying where database time is spent. A report is evidence, not a diagnosis by itself: workload changes, DB time, wait classes, top SQL, I/O, CPU saturation, and plan changes must be interpreted together.

Oracle wait event
SQL tuning
DB time
execution plan

Oracle Runtime Context

Related Oracle Concepts