Public Appearances

I currently have scheduled the following public appearances:

When Where What
2010-03-10 Dallas (USA) I will be presenting at the Hotsos Symposium 2010. The presentation is entitled “Diagnosing Parallel Executions Performance” (see abstract below).
2010-03-31 Genève (CH) Oracle Database 11g Release 2 TechnoCircle – Together with a collegue of mine I will be presenting a one-day seminar about the new features of 11gR2.
2010-04-16 Billund (DK) I will be presenting at the Miracle OpenWorld 2010. The presentations are entitled “Diagnosing Parallel Executions Performance” and “SQL Plan Baselines” (see abstracts below).
2010-06-22/23 Berlin (DE) Optimizing Oracle Performance – I will be presenting a two-day seminar based on the chapters 1, 2, 8, 9, 10 and 11 of my book. The event is organized by DOAG.
  • Diagnosing Parallel Executions Performance: The purpose of parallel executions is to distribute the execution of a single SQL statement over several sessions executed by several CPUs. There are, naturally, advantages and disadvantages to this. The main advantage is related to performance. In fact, provided that necessary resources are available, response time might be dramatically reduced. The main disadvantage is that the diagnosis of performance problems is more difficult. This is mainly due to the fact that Oracle’s instrumentation is mostly implemented at the session level. As a result, the challenge is to correctly aggregate information coming from several sessions in order to fully describe how a SQL statement is being executed.
    The aim of this presentation is to describe how to find, aggregate and interpret execution plans and statistics coming from V$ views such as active session history and SQL trace.
  • SQL Plan Baselines: A SQL plan baseline is an object associated with a SQL statement that is designed to influence the query optimizer while it generates execution plans. As of Oracle Database 11g, SQL plan baselines substitute stored outlines. Actually, they can be considered an enhanced version of stored outlines.
    The aim of this presentation is to explain what SQL plan baselines are, how to create and manage them, and when to use them.