Identify the two direct sources from where SQL plans can be loaded into the SQL plan
baselines. (Choose two.)
A.
Cursor cache
B.
Stored outline
C.
SQL Tuning Set
D.
Automatic Workload Repository (AWR) snapshots
Explanation:
The AWR snapshots needs to be loaded to STS at first, then load to SQL plan.
————————————————————— ( Link)
You can perform manual plan loading by:
Loading Plans from SQL Tuning Sets and AWR Snapshots
To load plans from a SQL tuning set, use the LOAD_PLANS_FROM_SQLSET function of
the DBMS_SPM package.
The following example loads the plans stored in the SQL tuning set named tset1:
DECLARE
my_plans PLS_INTEGER;
BEGIN
my_plans := DBMS_SPM.LOAD_PLANS_FROM_SQLSET( sqlset_name => ‘tset1’);
END;
/
To load plans from Automatic Workload Repository (AWR), load the plans stored in AWR
snapshots into a SQL tuning set before using the LOAD_PLANS_FROM_SQLSET function
as described in this section.
Loading Plans from the Shared SQL Area
To load plans from the shared SQL area, use the LOAD_PLANS_FROM_CURSOR_CACHE
function of the DBMS_SPM package. In the following example, Oracle Database loads the
plans located in the shared SQL area for the SQL statement identified by its sql_id:
DECLARE
my_plans PLS_INTEGER;
BEGIN
my_plans := DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE( sql_id =>
’99twu5t2dn5xd’);
END;
/