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 ACEOracle OAK-Table
Stefan Koehler follows his passion about Oracle since +15 years and specialized in Oracle performance tuning, especially in Oracle cost based optimizer (CBO) and database internal related topics. Nowadays he primarily works as an independent Oracle database performance consultant and researcher 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 and is recognized/rewarded as an Oracle ACE by Oracle’s ACE program.

These lectures could also interest you