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