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 happen.
First of all, the information displayed is correct:
Adaptive Execution Plans are an Enterprise Edition only feature.
But there’s no need to tweak any parameters or fear license issues. The feature is simply turned off in our code for Standard Edition 2 (SE2) regardless of how the parameter
optimizer_adaptive_plans has been set.
Thanks Nigel for shedding some light!