Oracle 12.2 adaptive features are enabled in Oracle 220.127.116.11 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 18.104.22.168 Windows BPs
We recommend to add two very important parameters to Oracle Database 22.214.171.124 installations.
The two very important fixes for bug# 22652097 and bug# 21171382 introduce the Oracle 12.2 SPFILE parameters
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 126.96.36.199.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 188.8.131.52.170531
- Bug 25917909 – CI BACKPORT OF BUG 22652097 FOR INCLUSION IN WINDOWS DB BP 184.108.40.206.170831
You will see the new parameters
optimizer_adaptive_statistics=FALSE once you apply the August (or any future) Bundle Patch on Oracle 220.127.116.11 on Windows.