jump to navigation

Announcement: Registration Links For Upcoming Webinars Now Open (“Join The Gang”) May 25, 2022

Posted by Richard Foote in 18c New Features, 19c New Features, 21c New Features, Index Internals, Index Internals Seminar, Indexing Tricks, Oracle 21c, Oracle General, Oracle Index Seminar, Oracle Indexing Internals Webinar, Oracle Performance Diagnostics and Tuning Seminar, Oracle Performance Diagnostics and Tuning Webinar, Oracle19c, Performance Tuning, Performance Tuning Seminar, Performance Tuning Webinar, Richard Foote Consulting, Richard Foote Seminars, Richard Foote Training, Richard Presentations.
add a comment

The registration links for my upcoming webinars running in August are now open!!!

The price of each webinar is $1,600 AUD. There is a special price of $2,750 AUD if you wish to attend both webinars (just use the Special Combo Price button).

(Note: Do NOT use the links if you’re an Australian resident. Please contact me at richard@richardfooteconsulting.com for additional payment info and tax invoice that includes additional GST).

Just click the below “Buy Now” buttons to book your place for these unique, highly acclaimed Oracle training events (see some of my testimonials for feedback by previous attendees to these training events):


Oracle Indexing Internals Webinar: 8-12 August 2022 (between 09:00 GMT and 13:00 GMT daily) – $1,600 AUD: SOLD OUT!!

Oracle Performance Diagnostics and Tuning Webinar: 22-25 August 2022 (between 09:00 GMT and 13:00 GMT daily) – $1,600 AUD: SOLD OUT!!

Special Combo Price for both August 2022 Webinars$2,750 AUD: SOLD OUT!!


The links allow you to book a place using either PayPal or a credit card. If you wish to pay via a different method or have any questions at all regarding these events, please contact me at richard@richardfooteconsulting.com.

As I mentioned previously, for those of you on my official waiting list, I will reserve a place for you for a limited time.

As this will probably be the last time I will run these events, remaining places are likely to go quickly. So please book your place ASAP to avoid disappointment…


Read below a brief synopsis of each webinar:

Oracle Indexing Internals

This is a must attend webinar of benefit to not only DBAs, but also to Developers, Solution Architects and anyone else interested in designing, developing or maintaining high performance Oracle-based applications. It’s a fun, but intense, content rich webinar that is suitable for people of all experiences (from beginners to seasoned Oracle experts).

Indexes are fundamental to every Oracle database and are crucial for optimal performance. However, there’s an incredible amount of misconception, misunderstanding and pure myth regarding how Oracle indexes function and should be maintained. Many applications and databases are suboptimal and run inefficiently primarily because an inappropriate indexing strategy has been implemented.

This webinar 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 webinar 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. It also covers many useful tips and strategies to maximise the benefits of indexes on application/database performance and scalability, as well as in maximising Oracle database investments. Much of the material is exclusive to this webinar and is not generally available in Oracle documentation or in Oracle University courses.

For full details, see: https://richardfooteconsulting.com/indexing-seminar/


Oracle Performance Diagnostics and Tuning

This is a must attend webinar aimed at Oracle professionals (both DBAs and Developers) who are interested in Performance Tuning.  The webinar details 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 webinar will show participants how to confidently and reliably diagnose performance issues. The webinar 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.

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.

It’s a fun, but intense, content rich webinar that is suitable for people of all experiences (from beginners to seasoned Oracle experts).

For full details, see: https://richardfooteconsulting.com/performance-tuning-seminar/


If you have any questions about these events, please contact me at richard@richardfooteconsulting.com


Great Britain and Northern Ireland February 2018 Dates: “Oracle Indexing Internals and Best Practices” Seminar (Battle For Britain) November 17, 2017

Posted by Richard Foote in Index Internals Seminar, Oracle Indexes, Richard Foote Consulting, Richard Presentations.
1 comment so far

seminar photo


Attention Oracle Professionals in the United Kingdom !!

I have now finalised all the dates and venues for a series of my popular and critically acclaimed “Oracle Indexing Internals and Best Practices” seminar I’ll be running in the UK in February 2018.

I’m extremely excited as this will be the first time I’ve delivered this seminar in my old homeland, despite having now delivered versions of this seminar in some 18 countries.

This is a must attend seminar of benefit to not only DBAs, but also to Developers, Solution Architects and anyone else interested in designing, developing or maintaining high performance Oracle-based applications/databases. It’s a fun, but intense, content rich seminar that is suitable for people of all experiences (from beginners to seasoned Oracle experts). Full details of the 2 day seminar content can be found here.

Location, dates and registration for these events have been finalised as follows:

London 12-13 February 2018: (Hilton London Kensington). Tickets & Registration Link.

Birmingham 15-16 February 2018: (Novotel Birmingham Centre). Tickets & Registration Link.

Manchester 19-20 February 2018: (Novotel Manchester City Hotel). Tickets & Registration Link.

Glasgow 22-23 February 2018: (Glasgow Training Rooms). Tickets and Registration Link.

Belfast 26-27 February 2018: (Ormeau Business Park). Tickets and Registration Link.



Early Bird Rate (enrolments prior to 12 January 2018) £990.00 (+ VAT)

General Rate  (enrolments post 12 January 2018) £1200 (+VAT)

Prices include attendance to the seminar, both soft and hard copy of the extensive seminar materials, lunch and morning/afternoon tea/coffee.

All seminars will have strictly limited places to ensure a quality event for all attendees and all venues are booked with only small classes in mind. So I recommend booking early (as it’s cheaper) and to avoid possible disappointment. I won’t get to run these kind of events in the UK very often so take advantage of attending what will be a unique training opportunity while you can.

If you have any questions, please leave a comment or contact me at richard@richardfooteconsulting.com.

Hope to see you at one of these events next year !!


Presenting at UKOUG Tech14 Conference (Ian Fish, U K Heir) July 15, 2014

Posted by Richard Foote in Richard Presentations, UKOUG Tech14.
add a comment

I’ve been lucky enough to present at various conferences, seminars and user group events over the years in some 20 odd countries. But somewhere I’ve never quite managed to present at before is the place of my birth, the UK. Well this year, I’ve decided end my drought and submitted a number of papers for the UKOUG Tech14 Conference and the parallel OakTable World UK14 Conference which were all thankfully accepted. So the land of David Bowie, Coronation Street, Bruce Forsyth, televised darts and a touch of drizzle, here I come.

The conference this year is being held in balmy Liverpool on 8-10 December 2014.

I’ll be presenting (times subject to change):

Oracle Indexes Q&A Session With Richard Foote (at OakTable World UK14)
(08/12/2014 09:00 – 09:50)

Oracle Database 12c New Indexing Features
(09/12/2014 12:00 – 12:50)

Indexing In Exadata
(10/12/2014 11:30 – 12:20)


Hopefully I’ll get to meet some of you there 🙂

AUSOUG 3 ACEs Database Education Day – Perth 11th May 2009 April 28, 2009

Posted by Richard Foote in Richard Presentations, Richard's Musings.

Just a short note to say I’ll be presenting a 3 hour morning session on all things Oracle indexes at the 3 ACEs Database Education Day in Perth, Australia on 11th May 2009, presented by the Australian Oracle User Group.

Also presenting will be the rather clever Conner McDonald on an “Introduction To RAC” and the also equally rather clever Penny Cookson on “Bind Peeking – The Endless Tuning Nightmare”, so it should be a great day.

And the best news of all is that the event is free for all AUSOUG members with lunch provided. So for those of you lucky enough to get to Perth, follow the link above to book early and guarantee a place.


Also just want to quickly mention that I had the great pleasure of attending Tanel Poder’s “Advanced Oracle Troubleshooting Seminar” in Melbourne last week.

It’s a great seminar that I highly recommend. Although it certainly covers some “advanced” topics, I would actually recommend the seminar to not just experienced DBAs as advertised, but really any DBA who is serious about diagnosing and troubleshooting database related problems. Because by far the most important message from the seminar is that rather than guessing and hoping a database problem might be this or that, rather that hoping increasing or changing this or that parameter might help, rather than crossing your fingers and praying that moving all indexes into a larger blocksize might improves things as it appeared to when you tried it once before, why not actually use database and O/S instrumentation to systematically, accurately and reliably determine exactly what the issue really is and so immediately go about applying a solution that will actually address the real problem. The earlier a DBA learns this basic principle rather than relying on outdated and ultimately inefficient and ineffective “hit and miss” checklists, the earlier one will ultimately become an efficient and effective DBA.

Why guess when you can know …

And Tanel’s seminar provides some great advice, suggestions and the odd script or two (actually many) to go about systematically determining what really is wrong with your database and why it’s causing performance issues (be it globally or to a specific user or group of users). Like I said, a highly recommended seminar and it was great to see I’m not the only one who struggles to get through everything in a seminar in the two days !!