Hotsos Training Day

Jonathan LewisHotsos is very pleased to announce that Jonathan Lewis is this year's training day speaker scheduled for March 12, 2009.


Jonathan Lewis is a freelance consultant with more than 20 years experience in using the Oracle database engine.

He specializes in design, trouble-shooting, and lecturing on the best use of the engine. Jonathan is a frequent speaker on the international circuit and has addressed audiences in more than 35 different countries in presentations lasting from 45 minutes to three solid days. He was a founding member of the Oak Table network, and one of the first individuals to be contacted by Oracle University for their "Celebrity Seminar" events.

His first book "Practical Oracle 8i" is still worth reading, despite being three generations behind the latest version, and his most recent book "Cost Based Oracle Fundamentals" still receives enthusiastic reviews. (Volume 2 - devoted to trouble-shooting - is on its way).


The topic for Training Day 2009 is entitled "Understanding Trouble-Shooting".Jonathan Lewis

Identifying performance problems in an Oracle database is not very difficult — if you have the right approach.

In this tutorial, we learn about trouble-shooting by going back to the basics, and building from there to a strategy that minimizes the time we spend finding the problems that matter.

We start by identifying the key features of a performant system. This helps us to recognise what's missing from a system that is performing badly, and allows us to decide on the most cost-effective improvements that we can risk making. We then review the information that Oracle makes available to us to identify real-time problems, and the three main ways we can access that information to address particular classes of problem.

At the end of this day you will be able to pick the best approach to identifying the most important flaws in a system, and identify the best tactical and strategic fixes for those problems.


Training Day will begin at 8:30 a.m. and end at 4:45 p.m.


  • $500

Registration Cancellation Policy

  • 100% refund if cancelled on or before January 2, 2009
  • 50% refund if cancelled between January 3, 2009 and February 13, 2009
  • Cancellations submitted February 14, 2009 and after will not be refunded

Training Day 2006