Public Appearances

I currently have scheduled the following public appearances:

When Where What
2016-04-20 Berlin (DE) I will deliver a one-day seminar entitled “Oracle Database 12c – New Performance Features” at an Expert Summit event organized by Oracle University. For additional information have a look to the flyer.
2016-05-12 Milano (IT) I’ll deliver, in Italian, two presentations entitled “Next-Generation Oracle Database – New Performance Features” and “Adaptive Dynamic Sampling” at the OTN EMEA Tour event organized by ITOUG. The abstracts are visible below. Additional information about the event are available here.
2016-05-14 Baku (AZ) I’ll deliver two presentations at the OTN EMEA Tour event organized by AzerOUG.
2016-05-16 Bucharest (RO) I’ll deliver three presentations entitled “Next-Generation Oracle Database – New Performance Features”, “Identification of Performance Problems without the Diagnostic Pack” and “Adaptive Dynamic Sampling” at the OTN EMEA Tour event organized by RoOUG. The abstracts are visible below. For additional information have a look to the flyer.
2016-05-18 Olten (CH) I’ll deliver, in German, two presentations entitled “Next-Generation Oracle Database – New Performance Features” and “Strategies for Keeping Object Statistics Up-to-Date” at the Training Day organized by SOUG. The abstracts are visible below. Additional information about the event are available here.
2016-05-19 Geneva (CH) I’ll deliver, in French, two presentations entitled “Next-Generation Oracle Database – New Performance Features” and “Strategies for Keeping Object Statistics Up-to-Date” at the Training Day organized by SOUG. The abstracts are visible below. Additional information about the event are available here.
  • Adaptive Dynamic Sampling: 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.
  • Designing for Performance: Database Related Worst Practices – Optimal performance is not simply a product one can buy but rather the results of 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.
  • Identification of Performance Problems without the Diagnostic Pack: Diagnostic Pack, which is an option available for the Enterprise Edition of Oracle Database only, gives access to a number of dynamic performance views and to the Automatic Workload Repository (AWR). Both are very useful for the identification of performance problems. On the one hand, dynamic performance views are mainly used for the analysis of performance problems while they are occurring. On the other hand, AWR is aimed at the analysis of performance problems that occurred in the past. The aim of this presentation is to describe how to perform analyses similar to those that can be carried out with the tools provided by the Diagnostic Pack even if you don’t have it.
  • Next-Generation Oracle Database – New Performance Features: With every new release of Oracle Database, a number of features aimed at improving performance are introduced. It goes without saying that the next generation will be no exception to the rule.
    The aim of this presentation is to preview, from a practical point of view, the latest enhancements for features related to the physical database design, query optimization and the In-Memory option.
  • Strategies for Keeping Object Statistics Up-to-Date: Object statistics describe the data stored in the database. Without them, the query optimizer could never make right decisions, such as finding the right join method for small or large result sets. In other words, without object statistics, the query optimizer can’t generate optimal execution plans.
    The dbms_stats package provides many features for managing object statistics. The question is, how and when should you use them to achieve a successful configuration? Answering this question is difficult. Probably no definitive answer exists. In other words, there is no single method that can be implemented in all situations. Therefore, the aim of this talk is to present a few strategies that I use to manage object statistics, making full use of the available features.

A list of past public appearances can be seen here.