What AWR Tells You

An AWR report answers the following key questions:

• What was the database doing most during the time window?
• What were the top resource consumers?
• Was the database waiting on something?
• Did any SQL dominate CPU, I/O, or elapsed time?