Public Appearances

I currently have scheduled the following public appearances:

When Where What
2015-03-04 Dallas (USA) I will present a paper entitled “Adaptive Dynamic Sampling” at Hotsos Symposium 2015. The abstract is available below.
2015-03-12/13 Cruise ship (Oslo-Kiel-Oslo) I will present two papers entitled “Adaptive Dynamic Sampling” and “Execution Plans” at OUGN Vårseminar 2015. The abstracts are available below.
2015-03-19 Baden (CH) I will present, in German, a paper entitled “Die Oracle Database In-Memory Option auf dem Prüfstand” at a SIG organized by SOUG. The abstract is available below.
2015-04-18 Lugano (CH) I will present, in Italian, a paper entitled “Designing for Performance: Database Related Worst Practices” at VOXXED Days Ticino. The abstract is available below.
2015-04-20 Utrecht (NL) I will present a paper entitled “Adaptive Query Optimization” at Planboard DBA Symposium. The abstract is available below.
2015-04-28 München (DE) With a colleague of mine (Peter Welker) I will present, in German, a half-day seminar entitled “Die Oracle Database In-Memory Option auf dem Prüfstand”. Detailed information about the event, which is organized by Trivadis, is available here.
2015-04-29 Frankfurt (DE) With a colleague of mine (Peter Welker) I will present, in German, a half-day seminar entitled “Die Oracle Database In-Memory Option auf dem Prüfstand”. Detailed information about the event, which is organized by Trivadis, is available here.
2015-05-21 Prangins (CH) I will present, in French, a paper entitled “Adaptive Dynamic Sampling” at a SIG organized by SOUG. The abstract is available below.
  • Adaptive Dynamic Sampling (EN): Based on object statistics stored in the data dictionary, the query optimizer can’t always accurately estimate the cost of an operation or predicate. When the query optimizer recognizes such a case, in some situations it can gather additional statistics through dynamic sampling. The original implementation of dynamic sampling was introduced in Oracle Database 9.2 and, up to 11.2.0.3, only marginally improved. However, Oracle Database 11.2.0.4 and 12.1 introduces a new implementation that completely changes the way dynamic sampling works. The aim of this presentation is to explain and demonstrate how the new implementation works.
  • Adaptive Dynamic Sampling (FR): En se basant sur les statistiques objets stockées dans le dictionnaire des données, l’optimiseur n’arrive pas toujours précisément à évaluer le cout d’une opération ou d’un prédicat. Lorsque l’optimiseur rencontre un tel cas, il peut, sous certaines conditions, récolter des statistiques supplémentaires au travers du “dynamic sampling” (échantillonnage dynamique). La version initiale de l’échantillonnage dynamique fut introduite en version 9.2, mais cette fonctionnalité ne fut que marginalement améliorée jusqu’en 11.2.0.3. Depuis les versions 11.2.0.4 et 12c, une nouvelle implémentation change totalement la manière de fonctionner de l’échantillonnage dynamique. Le but de cette présentation est d’expliquer et démontrer comment cette nouvelle implémentation fonctionne.
  • Die Oracle Database In-Memory Option auf dem Prüfstand!:Oracle Database In-Memory, mit der Version 12.1.0.2 eingeführt, verspricht In-Memory-Leistung ohne Änderung der Anwendung zu liefern. Ebenso soll die Komplexität der Datenbankadministration klein sein und keine Gefährdung der Nutzung von anderen Oracle Database Funktionalitäten auftreten. In diesem Vortrag wird die In-memory Option erklärt und mit zahlreichen Demos der Einsatz in der Praxis vorgestellt.
  • Execution Plans: An execution plan describes the operations carried out by the SQL engine to execute a SQL statement. 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 session is to describe in detail how you should perform these three actions.
  • Designing for Performance: Database Related Worst Practices: Optimal performance is not simply a product one can buy but rather the results of an accurate planning and a correct implementation. Given that applications should be designed for performance, it would be useful to cover an approach to doing that in great detail. However, for obvious reasons, it is not a subject that can be covered in a presentation. For this reason, I limit myself to briefly describing the top most common database-related design problems that frequently lead to suboptimal performance.
  • Adaptive Query Optimization: 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.

A list of past public appearances can be seen here.