AWR (Automatic Workload Repository)

The Automatic Workload Repository (AWR) is a built-in feature in Oracle databases that automatically collects and stores performance data over time. It helps database administrators monitor system health, identify issues, and analyze performance trends by maintaining detailed reports on server activity, resource usage, and workload patterns. This information enables informed decision-making for optimizing database performance and troubleshooting problems efficiently without manual data collection.