AWR Report Analysis - How to Read AWR Report? Performance Tuning and Troubleshooting - PT 2

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/
LinkedIn:   / mallikarjun-ramadurg-397a751a  
twitter:   / mallik034  
instagram:   / mallik034  
YouTube:   / @mallik034  

Regards,
Mallikarjun Ramadurg
Mobile: +966 543796525
WhatsApp: +91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn:   / mallikarjun-ramadurg-397a751a  
twitter:  / mallik034  
Instagram:  / mallik034  
YouTube:   / @mallik034