If you have read the previous post on automatic query reoptimation, this post is the continuation of the same, by looking them closely.
All the examples used are from oracle white paper.
Parameters that influence optimizer to use adaptive features
SQL> show parameter adaptive NAME TYPE VALUE ———————————— ———– —————————— optimizer_adaptive_features boolean FALSE optimizer_adaptive_reporting_only boolean […]
Follow Me!!!