Public Appearances

I currently have scheduled the following public appearances:

When Where What
2015-04-14 Ballerup (DK) I will deliver a presentation entitled “The Oracle Database In-Memory Option: Challenges and Possibilities” at the Trivadis DK opening event. More information is available here.
2015-04-18 Lugano (CH) I will deliver, in Italian, a presentation entitled “Designing for Performance: Database Related Worst Practices” at VOXXED Days Ticino. The abstract is available below.
2015-04-20 Utrecht (NL) I will deliver a presentation 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 deliver, in French, a presentation entitled “Adaptive Dynamic Sampling” at a SIG organized by SOUG. The abstract is available below.
2015-06-16 Wien (AT) I will deliver, in German, a presentation entitled “Adaptive Dynamic Sampling” at the conference organized by AOUG. 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.
  • 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.