Skip to content

Optimizer

Oracle 12c Adaptive Plan & inflection point

By Franck Pachot . The Oracle 12c Adaptive Plan feature was already presented by Nicolas Jardot in OOW 2013: Solving customer issues with the 12c Optimizer. I recently had to answer several questions about its behavior at execution time. Maybe the term ‘adaptive’ is misleading. It’s not that a join will stop and restart to another join method. Even with… 

A SQL statement is slow and suddenly fast? Have a look at “Cardinality Feedback”!

Discussing with some tuning gourous we were made aware about this feature. It is not so far from the adaptive cursor sharing perfectly described in  Chris’s blog : http://antognini.ch/papers/BindVariablePeeking_20090718.pdf

This feature, compares the real execution (number of returned/actual rows “A-rows”) with some expectations (number of expected rows “E-rows”) and chooses another plan for the next executions if the difference between

…