I currently have scheduled the following public appearances:
|2014-04-03||Baden-Dättwil (CH)||I will present a paper entitled “ASH Analytics” at an event organized by SOUG. The abstract is visible below.|
|2014-04-29/30||Berlin (DE)||Berliner Expertenseminar zum Thema Oracle Database Query Optimizer – I will present a 2-day seminar organized by DOAG. For detail information have a look to the full description.|
|2014-05-20||Birmingham (GB)||I will present two papers at an event organized by Oracle Midlands. The first is “Adaptive Query Optimization”, the second is “Row Chaining and Row Migration Internals”. The abstracts are visible below.|
|2014-05-28||Paris (FR)||I will present a paper about the 12c query optimizer at the Paris Oracle Meetup.|
|2014-06-03||Düsseldorf (DE)||I will present a paper entitled “Adaptive Query Optimization” at DOAG Datenbank 2014. The abstract is visible below.|
|2014-06-11||Zürich (CH)||I will present a paper entitled “Adaptive Query Optimization” at CBO Days 2014. The abstract is visible below.|
|2014-06-17||Wien (AT)||I will present a paper entitled “Adaptive Query Optimization” at AOUG Anwenderkonferenz 2014. The abstract is visible below.|
- ASH Analytics: Active Session History (ASH) Analytics is a feature introduced in EM 12c. Simply put, it allows you to interactively explore ASH data. The aim of this session is not only to demonstrate what you can do with this feature, but it also introduce a methodological approach for using it successfully. In addition key concepts of ASH are introduced as well.
- Adaptive Query Optimization (German): Das Ziel des Query Optimizers ist es, nicht nur der SQL Engine Ausführungspläne zu liefern, wie auf die Daten zugegriffen werden soll, sondern vielmehr geht es darum, effiziente Ausführungspläne zu erstellen. Obwohl diese zentrale Komponente der Oracle Datenbank mit jedem Release verbessert wird, treten immer wieder Fälle auf, wo suboptimale Ausführungspläne generiert werden. Das Ziel der Präsentation ist zu erklären und mit einer Live-Demo zu zeigen, wie Oracle Database ab 12c mit dem Feature “Adaptive Query Optimization” des Query Optimizers weitere Verbesserungen implementiert hat und weniger suboptimale Ausführungspläne generieren kann.
- Adaptive Query Optimization (English): The aim of the query optimizer is not only to provide the SQL engine execution plans that describe how to process data but also, and more importantly, to provide efficient execution plans. Even though this central component of Oracle Database is enhanced with every new release, there are always cases where it generates suboptimal execution plans. The aim of this presentation is to describe and demonstrate how, with Adaptive Query Optimization, which is a set of features available as of Oracle Database 12c, the query optimizer is able to generate less suboptimal execution plans.
- Row Chaining and Row Migration Internals: The aim of this presentation is to answer the following question: What is the difference between a chained rows and a migrated row? What are the consequences of having chained/migrated rows? How to detect chained/migrated rows? How to avoid chained/migrated rows?
A list of past public appearances can be seen here.