Oracle 12.2 Adaptive Features are enabled in Oracle 12.1.0.2 Windows BPs

Oracle 12.2 Adaptive Features are enabled in Oracle 12.1.0.2 Windows BPsOracle 12.2 adaptive features are enabled in Oracle 12.1.0.2 Windows BPs already, This is quite a surprise to me. But thanks to Michael Pfautz. He alerted me today.as he was wondering why his database didn’t start up anymore after he applied the August 31 Bundle Patch on Windows. It complained about the parameter optimizer_adaptive_features in the SPFILE. Michael had to remove this parameter before he could startup his database again.

Oracle 12.2 Adaptive Features are enabled in Oracle 12.1.0.2 Windows BPs

We recommend to add two very important parameters to Oracle Database 12.1.0.2 installations.

Enabling Oracle 12.2 Adaptive Features in Oracle 12.1.0.2

The two very important fixes for bug# 22652097 and bug# 21171382 introduce the Oracle 12.2 SPFILE parameters optimizer_adaptive_plans and optimizer_adaptive_statistics, and disable the automatic creation of extended statistics by default. See also MOS Note: 2187449.1: Oracle Highly Recommended Adaptive Feature Configuration Parameter Settings for 12.1.0.2.0

Unfortunately up to now you had to request the fixes every quarter on top of a Patch Set Update or Proactive Bundle Patch, often together with other fixes as merges. Once you install the patch for bug 22652097, you will have to remove optimizer_adaptive_features from your SPFILEs.

Roy did a quick research and we found out that:

  • Bug 25917907 – CI BACKPORT OF BUG 21171382 FOR INCLUSION IN WINDOWS DB BP 12.1.0.2.170531
  • Bug 25917909 – CI BACKPORT OF BUG 22652097 FOR INCLUSION IN WINDOWS DB BP 12.1.0.2.170831

You will see the new parameters optimizer_adaptive_plans=TRUE and optimizer_adaptive_statistics=FALSE once you apply the August (or any future) Bundle Patch on Oracle 12.1.0.2 on Windows.

–Mike

Leave a Reply

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