I currently have scheduled the following public appearances:
|2015-03-02/04||Dallas (USA)||I will present a paper entitled “Adaptive Dynamic Sampling” at Hotsos Symposium 2015. The abstract is available below.|
|2015-03-12/14||Cruise ship (Oslo-Kiel-Oslo)||I will present two papers entitled “Adaptive Dynamic Sampling” and “Execution Plans” at OUGN Vårseminar 2015. The abstract of the first presentation is available below.|
|2015-04-18||Lugano (CH)||I will present at VOXXED Days Ticino. The topic has still to be defined.|
- 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 184.108.40.206, only marginally improved. However, Oracle Database 220.127.116.11 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.
A list of past public appearances can be seen here.