Presentation Title: Real World Examples on how to use AWR Reports to Solve Performance Issues
Speaker: Mr Richard Foote OakTable Member
Company: Richard Foote Consulting
Presentation abstract: I often get called in to determine & address the root cause of database performance issues. Depending on the issue, a request for an Automatic Workload Repository (AWR) report is often sufficient to accurately diagnose the root problem(s).

In this session, I begin by discussing the basic concepts of response times, DB times, the Wait Interface & how to focus on what is truly important. I then look at how to best read an AWR report to quickly go to the most relevant sections that detail any specific issues. I also discuss a general tuning and diagnostic methodology that ensures one can quickly determine whether an AWR report will be sufficient and how to accurately and consistently use the AWR report to pinpoint and determine root causes for global database performance issues.

We spend most time going through a number of actual "real-life" examples highlighting various performance issues and how one accurately determines the actual root issues through an appropriate AWR Report

Presentation begins: 04/12/2017 16:55
Presentation duration: 110
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: All Experience Levels
Audience function: Oracle
Speaker biography: Based in Canberra, Australia, Richard has been working in the IT industry for nearly 30 years, 20 plus years with Oracle database technologies. Richard has supported and diagnosed the performance of numerous highly secure, mission-critical, large-scale applications. In 2002, he became a member of the world-renowned Oracle OakTable Network and an Oracle ACE Director in 2008. Richard is a very popular speaker and regularly presents at conferences including Oracle OpenWorld, IOUG Collaborate, Hotsos Symposium, AUSOUG InSync, ODTUG Kscope, UKOUG Conference and the E4 Enkitec Extreme Exadata Expo. He is especially renowned for his research and knowledge of Oracle indexing structures, hosts an internationally acclaimed blog on Index Internals and has developed in-depth seminars on Oracle Internals which he has presented in over some 18 countries. In 2017 Richard started his own independent consulting and training business ( and is planning on delivering his Index Internals seminar in the UK in February 2018.
Related topics: Database: 12c Database, Database: Performance & Internals
Hall: Hall 5

Tech17_-_Performance_Diagnostics_with_AWR_reports.pdf1.9 MB04/12/2017 22:55:33