Friday, March 18, 2016

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.