OPTIMIZER_ADAPTIVE_FEATURES obsolete in Oracle 12.2

The Oracle Database 12.1 parameter OPTIMIZER_ADAPTIVE_FEATURES has been made OBSOLETE (i.e. must be removed from the SPFILE when upgrading) in Oracle Database 12.2.

It gets replaced with two parameters of whom one is enabled, the other one is disabled by default:

  • OPTIMIZER_ADAPTIVE_PLANS=TRUE by default
  • OPTIMIZER_ADAPTIVE_STATISTICS=FALSE by default

Nigel Bayliss, our “Optimizer” Product Manager has blogged about it already with way more detailed insights.

But as Oracle Database 12.2 on-premises is not available how should you deal with this feature in Oracle Database 12.1?

Enabling ADAPTIVE Features of Oracle 12.2 in 12.1

 

 

–Mike
.

10 thoughts on “OPTIMIZER_ADAPTIVE_FEATURES obsolete in Oracle 12.2

  1. Pavel,

    are you sure? In my envs (unless I change it) "Plans" is TRUE and "Stats" is FALSE by default. Any other parameters you have set in addition such as OPTIMIZER_FEATURES_ENABLE to a lower value?

    Cheers
    Mike

  2. Pingback: Enabling ADAPTIVE Features of Oracle 12.2 in 12.1 | Upgrade your Database - NOW!

  3. Hi Mike,

    I noticed in this edition comparison chart for 12c (https://www.oracle.com/au/products/database/enterprise-edition/comparisons/index.html) that Adaptive Execution Plans is listed as an Enterprise only feature. Via SR 3-15068257241, it was confirmed that this should only be available for Enterprise Edition.

    As this functionality is currently available in Standard Edition in 12.1.0.2 (and enabled by default), do you know what the plan is to restrict SE2 usage of this feature in the future?

    • Adam,

      very interesting topic – please let me clarify this with the optimizer team.

      Cheers
      Mike

    • Adam,

      thanks for bringing this to my attention. I will release a blog post next week with some explanation. And don’t worry, regardless of the parameter, the functionality is not there in 12.2 SE2 – and it won’t raise an error.

      Cheers
      Mike

Leave a Reply

Your email address will not be published. Required fields are marked *