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 đŸ™‚