Presentation Title: Adaptive Features or: How I Learned to Stop Worrying & Troubleshoot the Bomb
Speaker: Mr Ludovico Caldara Oracle ACE Director
Company: Trivadis
Presentation abstract: Adaptive Dynamic Sampling, Adaptive Execution Plans, SQL Plan Directives: these new features are the new performance troublemakers when migrating databases from 11g to 12c. The optimizer uses them to seek for the perfect execution plan, but does it always succeed? This session will focus on the first steps required to quickly troubleshoot performance issues due to the adaptive features.
Presentation begins: 07/12/2016 15:10
Presentation duration: 50
Presentation content level: 3 (1 = indepth, 5 = strategic overview)
Audience experience: Experienced/Expert
Audience function: Product Expert, Product User
Speaker biography:  Ludovico is a database specialist and Oracle ACE Director with several years of experience on the full Oracle stack (Clusterware, DataGuard, RAC, ASM, EM). He has administered literally thousands of databases in big datacenters so he has developed a natural leaning to automatization, monitoring and high availability. He is a blogger and a confirmed community contributor, with the "RAC Attack 12c" project and his RACSIG and SOUG board membership. Ludovico is currently working as a senior consultant at Trivadis in Lausanne, Switzerland, where he can cultivate his passion for technology, bike, snowboard and family.
Related topics: Database: 12c New Features, Database: Performance & Internals
Hall: Hall 5

Adaptive_Features_UKOUG.pdf2.0 MB08/11/2016 16:27:42