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

Adaptive Execution Plans – not available in Oracle SE2

I received an interesting question on the blog the other day: “Are Adaptive Plans an Enterprise Edition only feature?” What does the License Guide say? The Oracle Database 12.2 License Guide says: What does www.oracle.com say? This is the link the customer came across – also saying that Adaptive Execution Plans are an Enterprise Edition only feature: What does this mean for SE2? That is the question Adam had. Does this impact SE2? Will I get an error or – even worse – a license violation if I have optimizer_adaptive_plans=TRUE – which is the default? No, none of it will…