Examine the following PL/SQL block:
SET SERVEROUTPUT ON
SET LONG 10000
ECLARE report clob;
BEGIN
report := DBMS_SPM.EVOLVE_SQL_PLAN_BASELINE();
DBMS_OUTPUT.PUT_LINE(report);
END;
Which statement describes the effect of the execution of the above PL/SQL block?
A.
The plan baselines are verified with the SQL profiles.
B.
All fixed plan baselines are converted into nonfixed plan baselines.
C.
All the nonaccepted SQL profiles are accepted into the plan baseline.
D.
The nonaccepted plans in the SQL Management Base are verified with the existing plan
baselines.
Non-accepted plans can be verified by executing the evolve_sql_plan_baseline function. This function will execute the non-accepted plan and compare its performance to the best accepted plan. The execution is performed using the conditions (e.g., bind values, parameters, etc.) in effect at the time the non-accepted plan was added to the plan history. If the non-accepted plan’s performance is better, the function will make it accepted, thus adding it to the SQL plan baseline