AWR Report Oracle DB Performance Issue Analysis

• workload repository is a collection of persistent system performance statistics owned by SYS.
• It resides in SYSAUX tablespace.
• By default snapshot are generated once every 60 min and maintained for 7 days.
• Each snapshot has a unique ID know as "snap_id". Snapshot detail can be found in "dba_hist_snapshot" view.
• If we have Database performance issue and not the Database machine, then AWR Report is the place to look at.
• AWR is not used for real-time performance monitoring like the v$ tables.
• It is used for historical analysis of performance.
• AWR complements but doesn't replace real-time monitoring.

References:

• http://nonfunctionaltestingtools.blogspot.com/2015/04/steps-to-analyze-awr-report-in-oracle.html