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

Exadata Only Database Features – Some Highlights And Why You Need To Know

Event: Connect 2022
Stream: Architecture, Cloud Database & Technology

The Oracle Database has a number of key features that are only available on the Exadata platform. Even if you don't currently work with Exadata, understanding some of these capabilities can be important and useful for any future endeavors. Free access to the Oracle Autonomous Database Cloud environments can certainly help with keeping up to date with some of these unique capabilities. This session will explore some of these Exadata only database features, including Zone Maps, SQL Quarantine, Real-Time Statistics, High Frequency Statistics Gathering, PDB Snapshot Carousel and some of the Automatic features, such as Automatic Indexing, Automatic Zone Maps and Automatic Materialized Views.

Automatic Indexing: An Update On Improvements and New Capabilities

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

One the most impressive and exciting database innovations introduced in Oracle Database 19c is "Automatic Indexing", an expert system built into the database engine that not only recommends potential new indexes to create, but will actually introduce new indexes in a safe and automated manner. This session explores in-depth this ground breaking feature, detailing how Automatic Indexing works, how it can be deployed and highlights a number of improvements and new capabilities that have been introduced since Automatic Indexing was first released. Attendees will gain an excellent appreciation of the power to Automatic Indexing and how this feature can substantially assist in reducing the risk of having an sub-optimal indexing strategy that causes performance implications.