Which three statements are true about adaptive SQL plan management?
A.
It automatically performs verification or evolves non-accepted plans, in
COMPREHENSIVE mode when they perform better than existing accepted plans.
B.
The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
C.
It adds new, bettor plans automatically as fixed plans to the baseline.
D.
The non-accepted plans are automatically accepted and become usable by the optimizer
if they perform better than the existing accepted plans.
E.
The non-accepted plans in a SQL plan baseline are automatically evolved, in
COMPREHENSIVE mode, during the nightly maintenance window and a persistent
verification report is generated.
B,D,E
ADE
https://docs.oracle.com/database/121/NEWFT/chapter12101.htm#NEWFT002
2.2.4.2 Adaptive SQL Plan Management
With adaptive SQL plan management, DBAs no longer have to manually run the verification or evolve process for non-accepted plans. When automatic SQL tuning is in COMPREHENSIVE mode, it runs a verification or evolve process for all SQL statements that have non-accepted plans during the nightly maintenance window. If the non-accepted plan performs better than the existing accepted plan (or plans) in the SQL plan baseline, then the plan is automatically accepted and becomes usable by the optimizer. After the verification is complete, a persistent report is generated detailing how the non-accepted plan performs compared to the accepted plan performance. Because the evolve process is now an AUTOTASK, DBAs can also schedule their own evolve job at end time.
Unaccepted plans in a SQL plan baseline are automatically evolved during the nightly maintenance window and a persistent verification report is generated which means a DBA no longer has to manual evolve plans and they can go back days or weeks later and review what plans were evolved during each of the nightly maintenance windows.
Then the correct options are?
B,E are true, A is somehow ‘grey area’ as not fully/properly defined.
Agree with you. We should choose between A and D. And I prefer D, because we perform verification and evolving of non-accepted plan to *determine if better than exisiting*. “Better than existing” can’t be the precondition.
ADE