jump to navigation

Announcement: “Oracle Indexing Internals and Best Practices Seminar” – Berlin 8-9 May 2019 !! January 30, 2019

Posted by Richard Foote in Oracle Indexes.
add a comment

I’m very excited to announce I’ll be running my highly acclaimed “Oracle Indexing Internals and Best Practices” seminar in conjunction with the German Oracle User Group (DOAG) in Berlin, Germany on 8-9 May 2019.

The venue will be the DOAG Offices in Berlin (DOAG Office, 6th Floor, Tempelhofer Weg 64, 12347 Berlin).

Because of venue size and for a quality educational experience, numbers will be strictly limited. This will be one of the very few times I’ll have to run this seminar in Europe this year, so please book early to avoid disappointment.

For all the details on how to maximise Database/Application performance with judicious use of indexes and why this seminar has been such a popular and well received educational experience, please visit my Indexing Seminar Page.

The cost of the seminar is as follows:

DOAG Members: 980 Euro Buy Now Button

Other Participants: 1400 Euro Buy Now Button

DOAG membership will need to be validated, else fee will be refunded and place lost.

Note: If you can make it to this seminar in Berlin, you there are still some places available for both webinar series running on 4-8 March 2019 and on 26-30 March 2019. Full details on my Indexing Internals Webinar Page.

Hope to see some of you in Berlin on 8-9 May 2019 for what I’m sure will be a fantastic event !!

If you have any questions, please contact me: richard@richardfooteconsulting.com.

Announcement: New “Oracle Diagnostics and Performance Tuning” Seminar Now Available !! January 14, 2019

Posted by Richard Foote in Performance Tuning Seminar, Performance Tuning Webinar.
1 comment so far

OMC Training

It’s been a work in progress for quite some time, with many of my customers asking when will it be completed. Well, I’m very excited to announce that I have finally completed my new 2 day “Oracle Diagnostics and Performance Tuning” seminar and that it’s ready to be presented.

I already have a number of private bookings for this in the coming months, with some public events and webinars to be scheduled shortly. If you’re interested in having this run at your site, contact me as I can customise it and run it exclusively at your premises for a great price. No waiting for the seminar to come near you and no travel expenses for your employees. Just the seminar/webinar for your staff, with just the topics that are of most interest to your organisation. We can even look at some of your specific performance issues, collectively analyse your associated diagnostic reports and actually diagnose and resolve your performance issues as part of the seminar.

For more information or to request a seminar near you, please email me at richard@richardfooteconsulting.com.

For all the details of this new seminar, see below or visit my “Oracle Diagnostics and Performance Tuning Seminar” page.


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.

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


Note: Numbers are strictly limited due to the small class nature of the seminars. Please book early to avoid disappointment as seminars are not scheduled regularly.

For a list of all upcoming seminars, see the Seminar Dates page.


Seminar Content (subject to minor change)

Section One: Basic Tuning Concepts

  • Common (but flawed) Tuning Methodology
  • THE Correct Tuning Methodology
  • Importance of Response Times
  • Importance of Database Time and Concurrent Active Sessions
  • Introduction to Oracle Wait Interface
  • The Correct Mentality To Performance Tuning
  • Importance Of Instrumentation


Section Two: Database Tuning

In Section Two, we explore how to best diagnose any performance issues as quickly as possible to accurately determine any root issue(s) and so apply the most appropriate resolutions. We explore a number of real world examples as well as providing the opportunity to go through any reports participants may wish to share.

As part of determining how to best resolve a number of real world examples, we get the opportunity to explore the internals of the database and the importance of understanding a number of crucial Oracle database concepts (e.g. latch contention, redo log mechanism, RAC cache fusion, etc.).

Because of the abundance of Oracle database instrumentation and the wealth of data available in (say) AWR Reports, many Oracle professionals feel swamped and are uncertain how to correctly read these types of reports when trying to diagnose a performance issue. In this section, we look at both WHEN and HOW to read the various reports to very quickly and reliably determine any performance issues and so know with certainty how to apply the most appropriate solution.

We explore the following Oracle supplied database diagnostics methods and when each of them are most appropriate to determine and resolve performance issues using a methodical tuning methodology:

  • Statspack Reports
  • Automatic Workload Repository (AWR) Reports
  • Automatic Database Diagnostic Monitor (ADDM) Reports
  • Active Session History (ASH) Reports
  • (Advanced) SQL Trace Files


Section Three: SQL Tuning

One of the most common reasons for poor performance is related to poorly running, inefficient SQL statements. In this section we explore in details a number of important concepts and Oracle capabilities (up to and including Oracle Database 18c) in relation to maximising the performance and stability of SQL statements. Topics covered include:

  • CBO Internals And How The CBO Costs SQL Statements
  • Why Is The More “Expensive” Costed SQL Often The Faster
  • Differences between ALL_ROWS and FIRST_ROWS(n) optimization
  • Setting Optimizer Based Parameters
  • CPU Cost Model and System Statistics
  • Schema Statistics Gathering Tips
  • Histogram Internals
  • Extended Statistics and Virtual Columns
  • Dynamic Sampling
  • Displaying and Reading Execution Plans
  • Managing Outlier Data
  • Join Processing, Join Types and Join Methods
  • Adaptive Query Optimization
  • Adaptive Plans
  • Cardinality Feedback
  • Adaptive Statistics
  • SQL Plan Directives
  • SQL Blocks
  • SQL Transformations
  • 10053 Trace Report
  • SQL Monitor Reports
  • SQL Hints (and when/how to use appropriately)
  • SQL Patching
  • SQL Plan Stability
  • SQL Profiles
  • SQL Stored Outlines
  • Migrating Stored Outlines to SQL Plan Management (Baselines)
  • SQL Plan Management (Baselines)
  • Baselines Use Cases


For more information or to request a seminar near you, please email richard@richardfooteconsulting.com.


New “Let’s Talk Database” events in Australia/NZ in February/March 2019 !! January 8, 2019

Posted by Richard Foote in Oracle Indexes.
add a comment

seminar photo

Very excited to announce some new “Let’s Talk Database” events scheduled for February 2019 in various locations in Australia/NZ:

Canberra: Wednesday, 20 February 2019: Registration Link

Sydney: Thursday, 21 Feburary 2019: Registration Link

Brisbane: Friday, 22 Feburary 2019: Registration Link

Melbourne: Wednesday, 27 February 2019: Registration Link

Wellington: Friday, 1 March 2019: Registration Link


I’ll be covering two interesting topics at these events:

Oracle Database Appliance: During my days at Oracle Corporation, I had quite a bit to do with helping customers on the ODA and always felt it was an great solution that often got drowned out by Exadata and other Oracle engineered solutions. In the session, I’ll be discussing the various unique advantages on running Oracle Databases on the Oracle Database Appliance (ODA), some of the new features available on the ODA (including now Hybrid Columnar Compression), some use cases for deploying Oracle Databases on the ODA and importantly, some of the more common mistakes and misunderstanding regarding how to best maintain an ODA environment.

Indexing and Partitioning: As databases get ever larger in size and complexity, the Oracle Partitioning option has become more common and a more important feature in Oracle database deployments. This presentation will look at some of the important indexing strategies that can be applied in a Partitioned Database environment in order to effectively maximise both database performance and database management practices. It will also discuss some newer features introduced in 12c R2 and 18c that simplifies the migration to an effective partitioning strategy.

The agenda on the day will be as follows:

8:30 a.m.  Registration & Coffee

9:00 a.m.  Oracle Database Appliance

10:15 a.m. Networking break

10:30 a.m. Indexing with Partitioning

12:00 p.m. Networking lunch

1:00 p.m. Event Close


So lots of database stuff to talk about and the best part is that’s all free !!

Simply follow the registration link to book your place. But please book early to avoid disappointment as places are strictly limited (all venues are the local Oracle offices).

Hope to see you at one of these events !!