Written by I delivered a half-day seminar entitled “Adaptive Query Optimization” at an event organized by AOUG. It’s aim is to review the new or enhanced adaptive query optimization features of 12c/18c (adaptive plans, performance feedback, statistics feedback, SQL plan directives and dynamic statistics) from a practical point of view as well as to point out challenges related to them.