Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 29th, 2011

 

Automatic Workload Repository (AWR) is the enhanced version of statspack and is used as performance gathering and reporting tool. AWR is basically used to gather performance related statistic such as system and session statistics, object usage statistics, time model statistics, query statistics in addition to database monitor and advisory information.

oracle2066

 Profile Answers by oracle2066 

• Dec 28th, 2011

 

You also have AWRSQRPT that collects statistics and tracks SQL statements as well.

Ora-Masala

• May 4th, 2016

 

The 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.

Diwakar

• Oct 20th, 2017

 

AWR-Automiatic Workload repository is the report which provides finer details of work that was performed on DB during specific period.
It provides following important details
1. Wait events causing delay.
2. Highlights query taking long Elapsed time or execution time.
3. report of CPU utilization and memory usage.
4. Blocking sessions.