Zum Inhalt springen

Regionaltreffen Nürnberg / Franken: Adaptive Features mit Stefan Köhler

15. März 2018 in Nürnberg

Regio Nürnberg / Franken



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, old and new dynamic sampling code, new SQL Plan Directive implementation with 12.2) really work or (when) not and how you can troubleshoot them. As usual it includes several geeky deep-dive demos.


Der Vortrag findet in deutscher Sprache statt.






Zum Autor:


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.

Stefan Köhler Independent Oracle Performance Consultant und Researcher (Soocs)



TH Nürnberg, Raum WE.014, Wassertorstrasse 10, 90489 Nürnberg


Martin Klier Performing Databases GmbH Zum Profil
Thomas Köppel Siemens AG Zum Profil