Oracle 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
Hallo Mike,
wir rennen in dieses Problem – auf einem Server:
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name ‘_optimizer_adaptive_plans’
… wir haben ihn aus dem spfile genommen.
Gruß
Oliver
Hallo Oliver,
ich vermute, Ihr habe ein Patch Bundle, das neuer ist.
Lies Dir bitte kurz den Eintrag hier auch durch:
https://mikedietrichde.com/2017/10/19/fixes-for-adaptive-features-are-included-in-oracle-12-1-0-2-october-2017-bp/
Herzliche Gruesse,
Mike