Public Appearances

I currently have scheduled the following public appearances:

When Where What
2015-09-01 Birmingham (UK) I will deliver two presentations entitled “Designing for Performance: Database Related Worst Practices” and “Identification of Performance Problems without the Diagnostic Pack” at Oracle Midlands. The abstracts are available below.
2015-09-10 Zurich (CH) I will deliver a presentation entitled “The Oracle Database In-Memory Option: Challenges and Possibilities” at the Trivadis Performance Days. The abstract is available below.
2015-10-12/13 Portoroz (SI) I will deliver two presentations entitled “Designing for Performance: Database Related Worst Practices” and “Adaptive Dynamic Sampling” at SIOUG 2015. The abstracts are available below.
2015-10-13/16 Rovinj (HR) I will deliver two presentations entitled “Identification of Performance Problems without the Diagnostic Pack” and “Adaptive Dynamic Sampling” at HrOUG 2015. The abstracts are available below.
2015-10-25 San Francisco (USA) I will deliver a presentation entitled “The Oracle Database In-Memory Option: Challenges & Possibilities” at Oracle OpenWorld 2015. The abstract is available below. In addition, I will talk about “Real-time Monitoring of Composite Database Operations” during one of the two EOUC talks entitled “Twelve More Things About Oracle Database 12c”.
2015-11-17/19 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-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 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.
  • The Oracle Database In-Memory Option: Challenges and Possibilities: Oracle Database In-Memory, which was introduced with version 12.1.0.2, 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 list of past public appearances can be seen here.