my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE (sql_id => ?9twu5t2dn5xd?;

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 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 *