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

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?

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



Leave a Reply 0

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