Which statement is true about the plan being loaded into the SQL plan baseline by the above command?

Examine 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?

Examine 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 ACCEPTED status.

B.
It is not loaded with the ENABLED status.

C.
It is loaded with the FIXED status.

D.
It is not loaded with the ACCEPTED status.



Leave a Reply 0

Your email address will not be published. Required fields are marked *