Richard Foote

Richard Foote 300x300

Richard Foote

Director & Principal Consultant

Richard Foote Consulting

Biography

Based in Canberra, Australia, Richard has been working in the IT industry for over 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, E4 Enkitec Extreme Exadata Expo and Trivadis Performance Days. He is especially renowned for his research and knowledge of Oracle indexing structures, hosts an internationally acclaimed blog on Oracle Indexing and has developed in-depth seminars on Oracle Indexing Internals which he has presented in some 20 countries. In 2017 Richard started his own independent consulting and training business (www.richardfooteconsulting.com) and is planning on delivering his Oracle Index Internals training as a webinar in March 2019.

Papers

Oracle Database AWR/Statspack Workshop

Event: Workshop 2021
Stream: Architecture, Cloud Database & Technology

When an application suddenly runs “slow” or when people start complaining about the “poor performance” of the database, there’s often some uncertainty in how to most quickly and most accurately determine the “root” cause of any such slowdown and effectively address any associated issues. One of the available tools in the DBA toolkit is the Automatic Workload Repository (AWR) Report, but many struggle to determine if it’s an appropriate report for the issue at hand and then how to read, decipher, and extract any useful information from the wealth of database diagnostic information available in AWR reports. In this workshop, we explore a Tuning Methodology that helps Oracle professionals to both quickly and reliably determine if an AWR (or Statspack) report is the correct tool to use in determining the actual root causes of Oracle database performance issues.  Looking at several real-world scenarios, this workshop will show participants when to consider using AWR reports and then how to diagnose performance issues confidently and reliably by extracting the relevant details from such AWR reports.  Accurately determining the root causes of performance issues ensures the effectiveness and timeliness of any applied resolutions. Participants will also be able to submit their own database AWR reports for analysis during the workshop and using the taught methodologies and techniques, identify any global performance issues within their own databases.