AWR REPORT:

AWR collects database statistics every 60 minutes (on the hour) out of the box 
(this is configurable), and this data is maintained for a week and then purged.
ü The Oracle database uses AWR for problem detection and analysis as well as for 
self-tuning.A number of different statistics are collected by the AWR, 
including wait events, time model statistics, active session history statistics, 
various system- and session-level statistics, object usage statistics, and 
information on the most resource-intensive SQL statements.
ü To properly collect database statistics, set the initialization parameter 
STATISTICS_LEVEL to TYPICAL (the default) or ALL.
ü The AWR consists of a number of tables owned by the SYS schema and typically stored 
in the SYSAUX tablespace (currently no method exists that I know of to move these
 objects to another tablespace).
Recommendations before getting an AWR Report :

Collect Multiple AWR Reports

It’s always good to have two AWR Reports, one for good time (when database was 
performing well), second when performance is poor. This way Remote DBA can easily 
compare good and bad report to find out the culprit.

Stick to Particular Time

“Database is performing slow” will not help anymore to resolve performace issues. 
We have to have a specific time like Database was slow yesterday at 1 Pm and 
continue till 4Pm. Here, DBA will get a report for these three hours.

Split Large AWR Report into Smaller Reports

Instead of having one report for long time like one report for 4hrs. it’s
 better to have four reports each for one hour. This will help to isolate the problem.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8