I currently have scheduled the following public appearances:
|2015-11-18||Nürnberg (DE)||I will deliver a presentation entitled “The Oracle Database In-Memory Option: Challenges & Possibilities” at DOAG 2015. The abstract is available below.|
|2015-11-20||Nürnberg (DE)||I will deliver a one-day seminar entitled “Oracle Database Advanced Optimization Techniques” at the DOAG 2015 Schulungstag. The content is based on chapter 15 of the 2nd edition of Troubleshooting Oracle Performance.|
|2015-11-24||Lausanne (CH)||I will deliver a presentation entitled “A gentle introduction to Oracle R Enterprise” at Swiss Data Forum 2015. The abstract is available below.|
|2015-12-07||Birmingham (UK)||I will deliver a presentation entitled “The Oracle Database In-Memory Option: Challenges & Possibilities” at UKOUG Tech15. The abstract is available below. In addition, I will join the Cost Based Optimizer panel organized by Jonathan Lewis.|
|2015-12-08||Birmingham (UK)||I will deliver a presentation entitled “Adaptive Dynamic Sampling” at UKOUG Tech15. The abstract is available below.|
- 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: The 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.
- 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 126.96.36.199, only marginally improved. However, Oracle Database 188.8.131.52 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.
- The Oracle Database In-Memory Option: Challenges and Possibilities: Oracle Database In-Memory, which was introduced with version 184.108.40.206, promises to deliver in-memory performance without modifying the application’s code, increasing the complexity of database administration, or jeopardizing the utilization of other Oracle Database functionalities. The aim of this presentation, after explaining the key concepts the Oracle Database In-Memory option is based on, is to review what you can expect from this new technology. Specifically, we’ll take a look at the situations where you can take advantage of it and what kind of overhead you should expect when enabling it.
- A gentle introduction to Oracle R Enterprise: R is a programming language that is widely used among statisticians, data miners and data scientists. Since 2012, Oracle provides an integration of R in its flagship database engine. The aim of this session is twofold. First, it shortly introduces the R technologies from Oracle. Second, it explains what Oracle R Enterprise is and what it can do for you.
A list of past public appearances can be seen here.