Over the coming months, I’ll be speaking at the following events.
|2008-10-15 16:15-17:15||AOUG Expertentreff, Vienna (A)||Query Optimizer 11g|
|2008-10-21 10:45-12:00||TrivadisOPEN, Zürich (CH)||Query Optimizer 11g|
|2008-10-22 11:30-12:45||TrivadisOPEN, Zürich (CH)||Bloom Filters|
|2008-12-02 14:00-14:45||DOAG Konferenz, Nürnberg (D)||Query Optimizer 11g|
|2008-12-05 10:00-12:00||UKOUG Conference, Birmingham (UK)||Execution Plans|
The abstracts of the presentations are the following (at the events in DACH I’ll give the presentations in German; hence the first abstract is in German…):
- Query Optimizer 11g: Mit jedem neuen Release wird der Query Optimizer verbessert. 11g ist da keine Ausnahme. Diese Präsentation zeigt Ihnen die zentralen Verbesserungen in den folgenden Bereichen: Object Statistics, Optimization Techniques, SQL Plan Baselines und Bind Variable Peeking.
Jede Verbesserung wird anhand einer Demo live gezeigt und gibt Aufschluss wie das Feature in der Praxis zum Einsatz kommt und welchen Applikationsvorteil es bringt.
- Bloom Filters: A bloom filter is a data structure used to support membership queries. Simply put, a bloom filter is used to test whether an element is a member of a given set or not. Since Oracle Database 10g Release 2 bloom filters are used in various situations. Unfortunately, no information about their usage is available in Oracle documentation. The aim of this presentation is to explain not only what bloom filters are, but also, and foremost, to describe how the database engine makes use of them. Specifically, it explains how the database engine uses bloom filters to reduce data communication between slave processes in parallel joins and to implement join-filter pruning.
- Execution Plans: An execution plan describes the operations carried out by the SQL engine to execute a SQL statement. Every time you have to analyze a performance problem related to a SQL statement, or simply question the decisions taken by the query optimizer, you must know the execution plan. 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.