ocp-447

QUESTION NO: 447
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a
SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are
performed by the optimizer in this scenario? (Choose two.)

A. The optimizer adds the new plan to the plan history.
B. The optimizer selects the new plan for the execution of the SQL statement.
C. The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D. The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest
cost.
Answer: A,E

---

优化器使用计划基线参数设置为真。优化器生成SQL语句的计划，但没有找到与SQL计划基线匹配的计划。在
这种情况下优化器执行哪两个操作？

A.优化增加了新的计划到计划历史。

E.优化器在SQL计划基线为每个的可接受的计划估价，并挑选具有最低的成本的一个。

---