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
See the following PL/SQL block:DECLARE -my_plans pls_integer,BEGIN -My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sq
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
See the following PL/SQL block:DECLARE -my_plans pls_integer,BEGIN -My_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE(sq
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!