DECLARE my_plans pls_integer; BEGIN my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id => '9twu5t2dn5xd'); END; |
Which statement is true about the plan being loaded into the SQL plan baseline by the above command?
A. It is loaded with the FIXED status.
B. It is loaded with the ACCEPTED status.
C. It is not loaded with the ENABLED status.
D. It is not loaded with the ACCEPTED status.
答案:(B)
解析:
DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sql_id IN VARCHAR2, plan_hash_value IN NUMBER:=NULL, sql_text IN CLOB, fixed IN VARCHAR2:='NO', enabled IN VARCHAR2:='YES') RETURN PLS_INTEGER; |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/17013648/viewspace-1264805/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/17013648/viewspace-1264805/