Webinar: AUSOUG - March/April/May-2019 -

  • Apr 24th - DevOps for DBA
  • May 1st - 18c New Features

 

AIOUG - Chennai Chapter

27-Apr-2019 Full Day Event

Performance Troubleshooting & DevOps for DBA

Click here to register

Subscribe to Posts by Email

Subscriber Count

    542

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