Public Appearances
I currently have scheduled the following public appearances:
| When | Where | What |
|---|---|---|
| 2010-09-16/17 | Ann Arbor (USA) | I will be presenting at the Michigan OakTable Symposium 2010. The presentations are entitled “Obtaining Execution Plans”, “Interpreting Execution Plans” and “Transaction Management Internals” (see abstracts below). |
| 2010-09-22 | San Francisco (USA) | I will be presenting at Oracle OpenWorld 2010. The presentation is entitled “Join Techniques” (see abstract below). |
| 2010-09-27 | Portoroz (SI) | I will be presenting at SIOUG 2010. The presentation is entitled “Join Techniques” (see abstract below). |
| 2010-11-18 | Nürnberg (DE) | I will be presenting at DOAG 2010. The presentation is entitled “Transaktions-Management Internas” (see abstract of “Transaction Management Internals” below; I will give the presentation in German). |
- Obtaining Execution Plans: An execution plan describes the operations carried out by the SQL engine to execute a SQL statement. Every time you have to analyze a performance problem related to a SQL statement, or simply question the decisions taken by the query optimizer, you must know the execution plan. Whenever you deal with an execution plan, you carry out three basic actions: you obtain it, you interpret it, and you judge its efficiency.
The aim of this presentation is to describe in detail how you should perform the first of these three actions. In other words, how to obtain execution plans. - Interpreting Execution Plans: An execution plan describes the operations carried out by the SQL engine to execute a SQL statement. Every time you have to analyze a performance problem related to a SQL statement, or simply question the decisions taken by the query optimizer, you must know the execution plan. Whenever you deal with an execution plan, you carry out three basic actions: you obtain it, you interpret it, and you judge its efficiency.
The aim of this presentation is to describe in detail how you should perform the second of these three actions. In other words, how to read execution plans. - Transaction Management Internals: Transactions, consistent reads and row-level locking are among the key features available in Oracle Database. In fact, without them, it would not be possible to properly implement three of the four ACID properties. The aim of this presentation is not to describe how they work from an application developer’s point of view. Instead, it is to describe how they are implemented and which structures are used at the block level to store the information related to them. Specifically, the presentation covers the following topics:
- How modified rows are linked to the transaction table and the undo information associated to it.
- What fast and deferred block cleanouts are and when they are used.
- What ITL waits and ITL deadlocks are and how to identify and avoid them. - Join Techniques: This presentation explains how the query optimizer joins multiple sets of data to each other. First it explains the operation of the basic join methods (nested loop, hash join, and merge join) and the possibilities we have to influence their performance. Then it presents some more advanced optimization techniques such as the transformations applied to joins, and partition-wise joins.