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
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.
(Choose two.)
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
15.1.1.2.1 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
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.
15.1.1.2.2 Loading Plans from the Cursor Cache
To load plans from the cursor cache, use the LOAD_PLANS_FROM_CURSOR_CACHE function of the DBMS_SPM package
http://docs.oracle.com/cd/B28359_01/server.111/b28274/optplanmgmt.htm