Author: Richard Foote

Based in Canberra, Australia, Richard has been working in the IT industry for over 30 years, 20 plus years with Oracle database technologies and is widely regarded as a leading authority on Oracle Database technologies. He hosts the very popular and internationally respected 'Richard Foote Oracle Blog' focusing on Oracle Index internals. After migrating to Canberra, Australia from his native England in 1982, Richard obtained a Bachelor of Arts degree in Computing Studies in 1986. His first IT position was as a Cobol Programmer with the Australian Public Service. Richard worked in various roles, including Programming, Project Management, Data Modeling, Database Design, and finally specializing in Application/Database Tuning and Technical Training. In late 1996, Richard joined Oracle Corporation, as a DBA Specialist and Technical Trainer, based in the local Canberra office. He was regarded as one of the top DBA specialists and instructors in the Australasia region and won many internal awards and accolades. In 2002, Richard left Oracle Corporation to become an independent consultant. He worked at various Oracle sites in the Canberra region, specialising in helping to diagnose and resolve numerous performance issues. During this time, he served as President of the Australian Capital Territory Oracle User Group (ACTOUG) where he also presented regularly. In 2002, Richard also became a member of the well-respected Oracle OakTable Network. In 2005, Richard was permanently employed by the Australian Government as a DBA specialist, supporting mission critical, large scale Oracle databases. Richard is a very popular speaker and regularly presents at user group functions and international conferences including Oracle OpenWorld, IOUG Collaborate, Hotsos Symposium, AUSOUG InSync, ODTUG Kscope, UKOUG Tech Conference and the E4 Enkitec Extreme Exadata Expo. Accolades include special recognition for the highly innovative "Good DBA, Bad DBA" co-presentation at Oracle OpenWorld in Brisbane in 1999, Best Oracle Speaker at UKOUG in 2015 and Best 3 presentations at the Hotsos Symposium in 2017. He also presents a highly successful in-depth seminar on Index Internals and Best Practices, which he has presented in over a dozen countries. In 2008, recognised for his technical expertise in Oracle Databases, Richard was awarded the level of an Oracle ACE Director by Oracle Corporation. In late 2011, Richard re-joined Oracle Corporation as a Technical Pre-sales Consultant and as an Oracle Ace Employee. During this time, Richard worked with numerous Oracle customers in diagnosing and resolving complex database performance issues. In 2017, he was awarded the Best Solutions Consultant in the ANZ region, in part because of his highly successful "Let's Talk Database" series of events. He listens to the music of David Bowie, Pink Floyd and Radiohead as much as possible.

Richard Foote Consulting

Richard Foote Consulting is based in Canberra, Australia and provides specialist Oracle Database training and consulting services, focusing on Database Tuning, Performance Resolutions and Database Heath Assessments.

For information on seminars, consulting services, rates or availability, please email


Training Services

I currently present a fully updated and revised version of the very popular and successful “Oracle Indexing Internals and Best Practice” 2 day seminar, which has previously been run in some 18 countries. A must for every Oracle DBA, Developer, Solution Architect or anyone interested in designing, developing or maintaining high performance, highly scalable Oracle-based applications. This seminar examines most available Oracle index structures/options and discusses in considerable detail how indexes function, how/when they should be used and how they should be maintained. A key component of the seminar is how indexes are costed and evaluated by the Cost Based Optimizer (CBO) and how appropriate data management practices are vital for an effective indexing strategy.  Many Oracle databases/applications are currently running sub-optimally with inefficient workloads directly as a result of implementing an inappropriate indexing strategy.  The seminar covers many useful tips and strategies to maximise the benefits of indexes on database/application performance and scalability, as well as maximising Oracle database investments. Much of the material is exclusive to this seminar and is not generally available in Oracle documentation or in Oracle University courses.

For full details of the “Oracle Indexing Internals and Best Practices” seminar, see the Indexing Seminar page.

The seminar is developed and personally delivered by Richard “Mr Index” Foote, a well-respected expert in Oracle Database technologies. and is currently scheduled in the following locations:

Perth 30-31 October 2017: Enrollment Details Coming Soon

Adelaide 1-2 November 2017: Enrollment Details Coming Soon

Canberra 6-7 November 2017: Enrollment Details Coming Soon

Brisbane 8-9 November 2017: Enrollment Details Coming Soon

Melbourne 13-14 November 2017: Enrollment Details Coming Soon

Sydney 15-16 November 2017: Enrollment Details Coming Soon


For all currently scheduled dates, see the Seminar Dates page.


Consulting Services

Well-tuned Oracle Databases are obviously crucial for any organisation with benefits that include:

  • Better end-user experiences
  • More scalable and resilient applications
  • Maximise investments in both Oracle licensing and current infrastructure
  • Avoid or delay infrastructure upgrades or increases in licensing requirements
  • Reduced subscription requirements in Cloud-based migrations

Based on over 20 years experience in managing, tuning and trouble-shooting Oracle Databases, Richard Foote has tuned and successfully addressed complex performance issues for numerous Oracle customers. In many cases, this has resulted in 10+ times performance improvements and in some scenarios the cancellation of planned infrastructure upgrades.

Richard Foote Consulting specialises in Database Performance Tuning with services that include:

  • Database/Application Performance Tuning
  • Database Performance Troubleshooting and Resolutions
  • Database Health Checks and Assessments
  • On-The-Job Database Management Training
  • Cloud Migration Assessments
  • Platform Migration Assessments
  • Database Configuration and Feature Adaption Advice
  • Database New Features and Implementation Advice
  • General Database Management Advice


For more details on available Consulting Services, see the Consulting Services page.

For information on seminars, consulting services, rates or availability, please email