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.… [Read More]

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:

Adaptive - EE only

Adaptive Features: Enterprise Edition only – from the Oracle 12.2 License Guide

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:

Adaptive Plans - EE only

Adaptive Execution Plans – Enterprise Edition only – from www.oracle.com

What does this mean for SE2?

[Read More]