See the following PL/SQL block:DECLARE -my_plans pls_integer,BEGIN -My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sq
Posted: Sun Jun 11, 2023 3:50 pm
See the following PL/SQL block: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
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