SET SERVEROUTPUT ON SET LONG 10000 DECLARE 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.
答案:(D)
解析:
DBMS_SPA.EVOLVE_SQL_PLAN_BASELINE
这个函数会演化与一个或多个SQL语句相关联的SQL plan baseline.
当一个或多个non-accepted 计划变为accepted计划的时候,一个SQL plan baseline就被演化了.
如果verify = 'YES',则每一个non-accepted计划的执行的性能要与SQL plan baseline中accepted的计划进行对比.
如果前者的性能要比后者好并且commit = 'YES',则这个non-accepted计划会变为accepted
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1263021/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1263021/