Subscriber Count

    459

Subscribe to Posts by Email

Pages

12c Database : Adaptive Execution Plans

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 […]

12c Database : Adaptive Query Optimization

Before to 12c, all the sql tuning features like ACS, SQL Profiles, SQL Outlines, SPM etc are for proactive tuning and plan stability. There is no way around to decide and change the optimizer decision on fly during the execution of a sql statement.

Since 12c, Oracle introduced the set of capabilities called "adaptive query […]