What is Automatic Workload Repository (AWR)?
The Automatic Workload Repository (AWR) is an integral piece of the server manageability functionality introduced in Oracle Database 10g. It provides a self-managing repository for storing workload statistics that are crucial for system monitoring and performance analysis. The AWR resides in the SYSAUX tablespace.