Can you explain what an AWR report is and what it is used for?

AWR (Automatic Workload Repository) is a built-in tool in Oracle Database that collects, stores, and analyzes database performance statistics over specific time intervals. The AWR report contains information about system load, resource usage, slow queries, locks, and other metrics.

The main purpose of the AWR report is to help administrators and developers identify performance bottlenecks, analyze the causes of slowdowns, and optimize database operation. The report is generated automatically or upon request and serves as a basis for troubleshooting.

Example of use: if the database is running slowly, you can generate an AWR report for the problematic period and analyze which queries or operations consume the most resources.