At page 383 of my book I wrote the following sentence (BTW, the same information is also provided by Table 9-3 at page 381): With B-tree indexes, IS NULL conditions can be applied only through composite B-tree indexes when several SQL conditions are applied and at least one of them is not based on IS […]
SIOUG Conference in Portoroz
This is a short note to point out that I just added to the Public Appearances page the next conference organized by the Slovenian Oracle User Group (SIOUG) in Portoroz. It will take place on September 27-29. My talk, entitled “Join Techniques”, is based on chapter 10 of my book. It will be a shorter […]
Oracle OpenWorld Schedule
Back from two weeks of vacation I noticed that the schedule of the next OpenWorld is available here. The detailled information about my session, which is based on chapter 10 of my book, is the following: ID# S316683 Title Join Techniques Abstract This presentation explains how the query optimizer joins multiple sets of data to […]
Troubleshooting Oracle Performance – Downloadable Files
This is just a short note to point out that I just uploaded a new version of the scripts related to TOP. The new ZIP is available through this page. The change log is the following: connect.sql Added DBM10205, DBA10205, DBM11201 and DBA11201 chapter02bind_variables.sql Because of 11g modified/added queries against V$SQL_SHARED_CURSOR chapter02sharable_cursors.sql Added SET SERVEROUTPUT […]
Related-Combine Operation „UNION ALL (RECURSIVE WITH)“
To make easier the interpretation of execution plans, in chapter 6 of TOP I defined three types of operations: standalone operations, unrelated-combine operations, and related-combine operations. For combine operations I also added a list of all operations of each type. Since in 11.2 a new related-combine operation is available, I decided to write this short […]
Ad: Optimizing Oracle Performance Seminar in Berlin
In one month I will be in Berlin 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. You can read the full description of the seminar (incl. agenda) here. Just be careful that the spoken language will be German (slides […]
Chinese Edition of TOP Available!
Few weeks ago the Chinese Edition of my book, Troubleshooting Oracle Performance, was published by China-Pub! Honestly, this is something I did not expect when publishing the book. Even though I still have to touch one of them myself, let me spend few words about it… I still remember when I saw for the first […]
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 […]
A-Rows and DML Statements
Today’s post is dedicated to the Metalink SR identified by the number 6468252.994. I know, this number says nothing to you. For me, however, it’s a very well known number. The reason is quite simple… Even if I open this SR almost two years ago (to be precise, September 5, 2007), it was closed few […]
Troubleshooting Oracle Performance – Downloadable Files
This is just a short note to point out that I just uploaded a new version of the scripts related to TOP.The new ZIP is available through this page. The change log is the following (as you can see there are only few changes compared to the last time): chapter07/object_stats.sql New file chapter07/outline_with_ffs.sql New file […]