I currently have scheduled the following public appearances:
|2015-02-13||Online||I will present, in German, a webinar entitled “Identification of Performance Problems without the Diagnostic Pack”. The webinar is organized by DOAG.|
|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-04-18||Lugano (CH)||I will present a paper entitled “Designing for Performance: Database Related Worst Practices” at VOXXED Days Ticino.|
- 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 22.214.171.124, only marginally improved. However, Oracle Database 126.96.36.199 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.
- 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.
A list of past public appearances can be seen here.