Automatic Workload Repository (AWR)

Automatic Workload Repository (AWR) is used to collect performance statistics including: 

•  Wait events used to identify performance problems. 
• Time model statistics indicating the amount of DB time associated with a process from the V$SESS_TIME_MODEL and V$SYS_TIME_MODEL views. 
• Active Session History (ASH) statistics from the V$ACTIVE_SESSION_HISTORY view. 
• Some system and session statistics from the V$SYSSTAT and V$SESSTAT views. 
• Object usage statistics. 
• Resource intensive SQL statements. 

Please find find below a sample report.