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

Channel Avatar
3 Comments
X
Share
AWR Report Analysis - How to Read AWR Report? Performance Tuning and Troubleshooting - PT 2
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: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter: https://twitter.com/mallik034
instagram: https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA

Regards,
Mallikarjun Ramadurg
Mobile: 966 543796525
WhatsApp: 91 9880616848
Blog: https://mallik034.blogspot.com/
LinkedIn: https://www.linkedin.com/in/mallikarjun-ramadurg-397a751a
twitter:https://twitter.com/mallik034
Instagram:https://www.instagram.com/mallik034/
YouTube:https://www.youtube.com/channel/UC-RwDqukbxZVwYoxN-E3zRA

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *

Responses (3)

  1. Howdy would you mind stating which blog platform you’re working with?
    I’m going to start my own blog in the near future but I’m having a hard time making a decision between BlogEngine/Wordpress/B2evolution and Drupal.
    The reason I ask is because your design seems different then most blogs and
    I’m looking for something completely unique. P.S My apologies for getting off-topic but I had to ask!
    I saw similar here: sklep internetowy and also here: e-commerce

  2. Hi, this weekend is fastidious in favor of me, for the reason that
    this time i am reading this impressive informative paragraph here at
    my house. I saw similar here: sklep internetowy and also here: dobry sklep

  3. Hi all, here every one is sharing these kinds of
    knowledge, so it’s pleasant to read this weblog, and I used to pay a quick visit this web site everyday.!