Hello Friends,

Here with one more topic on.

AWR Report Analysis How to Read AWR Report? Performance Tuning and Troubleshooting PT 2:
=============================================================================
Main Steps to Analyze AWR Report
Database Details
Host Configuration
Snap Shot Detail
Load Profile
Instance Efficiency Percentages
Top 5 Timed Foreground Events
Time Model Statistics
Operating System Statistics – Detail
SQL Ordered by Elapsed Time
SQL Ordered by CUP Time

Recommendations before getting an AWR Report.
1. Collect Multiple AWR Reports
2. Stick to Particular Time
3. Split Large AWR Report into Smaller Reports (30 mins)

How to Run?
@?/rdbms/admin/awrrpt.sql;
@?/rdbms/admin/awrrpti.sql
@?/rdbms/admin/awrgrpt.sql ;
@?/rdbms/admin/awrgrpti.sql;

FAQ: How to Use AWR reports to Diagnose Database Performance Issues (Doc ID 1359094.1)
FAQ: Automatic Workload Repository (AWR) Reports (Doc ID 1599440.1)
How To Understand AWR Report / Statspack Report [ID 842884.1]

#AWR #PerformanceTuning #PT #top #vmstat #iostat #free #sar #RAC #exadata #oracle #oracledatabase #oracledba #database #databaseperformanceIssue #databases


Please do follow me and support me on,

Blog: https://mallik034.blogspot.com/'>https://mallik034.blogspot.com/
LinkedIn:   / mallikarjunramadurg397a751a  
twitter:   / mallik034  
instagram:   / mallik034  
YouTube:   / @mallik034  

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/'>https://mallik034.blogspot.com/
LinkedIn:   / mallikarjunramadurg397a751a  
twitter:  / mallik034  
Instagram:  / mallik034  
YouTube:   / @mallik034