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 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 Execution Plans – Enterprise Edition only – from www.oracle.com
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!
Further Information?
–Mike
Hi Mike,
Sorry for digging up this old blog post.
I recently stumbled over two entries in DBA_FEATURE_USAGE_STATISTIC in an 19c Standard Edition Two during a health check at a customer. It listed usage for “Automatic Reoptimization“ and „SQL Plan Directive”. Some research led me to the conclusion, that “Automatic Reoptimization“ can only be “Adaptive Execution Plans”. You state, that the feature is disabled in the Standard Edition Two kernel.
However, when I query dba_sql_plan_directives I find directives for SYS and user schemata generated with reason “SINGLE TABLE CARDINALITY MISESTIMATE” and “JOIN CARDINALITY MISESTIMATE”.
How can that be, if it’s disabled in the kernel?
Perhaps it’s worth to open a SR to clarify.
Best regards,
Björn
Hi Bjoern,
my assumption is that “you” can’t use it actively, but that the database uses it secretly in the backend. Please try to set:
alter system set “_sql_plan_directive_mgmt_control”=0;
and drop any existing plan directives.
Cheers,
Mike