Under the hood of dynamic and adaptive database features

The Oracle database has a lot of dynamic & adaptive features which may influence the cost based optimizer or the SQL runtime engine. This session provides insights into how some of these features (e.g. cardinality feedback / statistics feedback) work or (when) not and how you can troubleshoot them. As usual it includes several deep-dive demos.

Tuesday, 2017-11-21
2:00 pm - 2:45 pm

Stefan Koehler

Freelance Consultant (Soocs)
Oracle OAK-Table
Stefan Koehler follows his passion about Oracle since +13 years and specialized in Oracle performance tuning, especially in Oracle cost based optimizer (CBO) and database internal related topics. Nowadays he primarily works as a freelance Oracle database performance consultant in large mission critical environments (e.g. +10 TB databases) for market-leading companies or multi-billion dollar enterprises in various industries all over the world. He usually supports his clients in understanding and solving complex Oracle performance issues and troubleshooting nontrivial database issues on short-term contracting basis. He is also a proud member of the OakTable Network.

These lectures could also interest you