jump to navigation

Hotsos Symposium 2017: Feb 27 – Mar 2 Dallas, Texas (I’m Afraid of Americans) February 6, 2017

Posted by Richard Foote in Oracle Indexes.


In just 3 weeks time, I’ll again have the pleasure of presenting at the awesome Hotsos Symposium in Dallas, Texas. It’s simply the best conference with regard to Oracle performance tuning anywhere.

This year, I’ll be presenting on a couple of topics:

New Index Features Introduced in Oracle Database 12c Release 2

Oracle Database 12c Release 2 is now available in both Oracle DBaaS and Exadata Express Cloud Services and will soon be generally available. Oracle 12.2 has introduced a number of extremely useful new indexing features and enhancements. These include cool capabilities such as tracking index usage, advanced index compression enhancements, deferred invalidation of cursors during index creation/rebuild, automatic index maintenance during new online operations and JSON indexing enhancements. These will all be discussed in much detail with examples on how they can be usefully deployed.

Real World Examples on how to use AWR Reports to Solve Performance Issues

I often get called in by customers to determine and address the root cause of database performance issues. Depending on the issue, a request for a simple Automatic Workload Repository (AWR) report is often sufficient to accurately diagnose the root problem(s). However, many DBAs find AWR reports daunting as they contain so much database diagnostic information, they don’t even know where to begin to find the truly useful information.

In this session, I begin by discussing the basic concepts of response times, DB times, the Oracle Wait Interface and how to focus on what is truly important. I then look at how to best read an AWR report to quickly go to the most relevant sections that detail any specific issues. I also discuss a general tuning and diagnostic methodology that ensures one can quickly determine whether an AWR report will indeed be sufficient and how to accurately and consistently use the AWR report to pinpoint and determine root causes for global database performance issues. We’ll go through a number of actual “real-life” examples that highlight various performance issues and how one accurately determines the actual root issues through an appropriate AWR report.


Looking forward to catching up with a number of my Oracle friends. Hopefully you can make it, learning lots of really useful stuff in relation to Oracle Performance Tuning is guaranteed 🙂


1. Magnus Johansson - February 6, 2017

I will visit Hotsos symposium and looking forward to attend your sessions. I have tried for a long time to attend one of your presentations in Europe but never been able to.

Liked by 1 person

Richard Foote - February 17, 2017

Hi Magnus

There was a period there when I seemed to be forever running my seminars in Europe !! Hope I don’t disappoint at Hotsos, see you there soon.


Magnus Johansson - February 21, 2017

I am sure it Will be great ! My first visit to Hotsos, really looking forward to it.
Looking forward to meet you !



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: