Home

For information on upcoming seminars, consulting services, rates or availability, please email richard@richardfooteconsulting.com.

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 Health Assessments.

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.

I’m also running an exciting new 2 day “Oracle Performance Diagnostics and Tuning” seminar.

This is a must attend seminar aimed at Oracle professionals (both DBAs and Developers) who are interested in Performance Tuning.  The seminar will detail how to maximise the performance of both Oracle databases and associated applications and how to diagnose and address any performance issues as quickly and effectively as possible.

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. In this seminar, we explore a Tuning Methodology that helps Oracle professionals to both quickly and reliably determine the actual causes of performance issues and so ensure the effectiveness of any applied resolutions.

Looking at a number of real world scenarios and numerous actual examples and test cases, this seminar will show participants how to confidently and reliably diagnose performance issues. The seminar explores in much detail the various diagnostics tools and reports available in Oracle to assist in determining any database performance issue and importantly WHEN and HOW to effectively use each approach. Additionally, participants are also invited to share their own database/SQL reports where we can apply the principles learnt in diagnosing the performance of their actual databases/applications (we can communicate prior to the event on how to best get any reports of interest).

One of the more common reasons for poor Oracle performance is inefficient or poorly running SQL. This seminar explores in much detail how SQL is executed within the Oracle database, the various issues and related concepts important in understanding why SQL might be inefficient and the many capabilities and features Oracle has in helping to both resolve SQL performance issues and to maintain the stability and reliability of SQL execution.

For full details of the “Oracle Performance Diagnostics and Tuning” Seminar, see the Performance Tuning page.

These seminars/webinars are developed and personally delivered by Richard “Mr Index” Foote, a well-respected expert in Oracle Database technologies and are currently scheduled in the following locations:

Webinar Dates

NEW DATES!!

“Oracle Indexing Internals“ Webinar: 8-12 August 2022 (between 09:00 GMT and 13:00 GMT daily): SOLD OUT!!

“Oracle Performance Diagnostics and Tuning“ Webinar: 22-25 August 2022 (between 09:00 GMT and 13:00 GMT daily): SOLD OUT!!

“Special Combo Price for both August 2022 Webinars“: SOLD OUT!!

 

The above webinars now have the maximum number of attendees I’m comfortable in having in one session and are now officially sold out. I unfortunately have no timeframe when I may run another webinars series. If you were interested in attending this training, please contact me to get yourself on a waiting list: richard@richardfooteconsulting.com.

 

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 upcoming seminars, consulting services, rates or availability, please email richard@richardfooteconsulting.com.

RFC Icon