exec DBMS_SQLTUNE.CREATE_SQLSET('sqlset_33x51afpuq0mx');
declare
baseline_ref_cursor DBMS_SQLTUNE.SQLSET_CURSOR;
begin
open baseline_ref_cursor for
select VALUE(p) from table(DBMS_SQLTUNE.SELECT_WORKLOAD_REPOSITORY(10504, 10505,'sql_id='||CHR(39)||'33x51afpuq0mx'||CHR(39)||' and plan_hash_value=3999990270 and instance_number=1',NULL,NULL,NULL,NULL,NULL,NULL,'ALL')) p;
DBMS_SQLTUNE.LOAD_SQLSET('sqlset_33x51afpuq0mx', baseline_ref_cursor);
end;
declare
my_integer pls_integer;
begin
my_integer := dbms_spm.load_plans_from_sqlset(sqlset_name => 'sqlset_33x51afpuq0mx',
sqlset_owner => 'SYS',
fixed => 'YES',
enabled => 'YES');
DBMS_OUTPUT.PUT_line(my_integer);
end;
/
select * from table(dbms_xplan.display_sql_plan_baseline('SQL_9dfa1d331ab96779'))
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_9vyhx6cdbktvhad382142 Plan id: 2906136899
Enabled: YES Fixed: NO Accepted: NO Origin: EVOLVE-LOAD-FROM-AWR
Plan rows: From dictionary
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_9vyhx6cdbktvhb0c0e3ba Plan id: 2965431229
Enabled: YES Fixed: NO Accepted: NO Origin: EVOLVE-LOAD-FROM-AWR
Plan rows: From dictionary
--------------------------------------------------------------------------------
Note
-----
- statistics feedback used for this statement
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_9vyhx6cdbktvhe14e12fe Plan id: 3999990270
Enabled: YES Fixed: YES Accepted: YES Origin: MANUAL-LOAD-FROM-STS
Plan rows: From dictionary
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_9vyhx6cdbktvhf5b96f1f Plan id: 4122570529
Enabled: YES Fixed: NO Accepted: NO Origin: EVOLVE-LOAD-FROM-AWR
Plan rows: From dictionary
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_9vyhx6cdbktvh02b9f50d Plan id: 45741329
Enabled: YES Fixed: NO Accepted: NO Origin: EVOLVE-LOAD-FROM-AWR
Plan rows: From dictionary
--------------------------------------------------------------------------------
Note
-----
- statistics feedback used for this statement
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_9vyhx6cdbktvh21375c10 Plan id: 557276179
Enabled: YES Fixed: NO Accepted: NO Origin: EVOLVE-LOAD-FROM-AWR
Plan rows: From dictionary
--------------------------------------------------------------------------------
Note
-----
- statistics feedback used for this statement
- Failed to use SQL plan baseline for this statement
--------------------------------------------------------------------------------
Plan name: SQL_PLAN_9vyhx6cdbktvh7222ae09 Plan id: 1914875409
Enabled: YES Fixed: NO Accepted: NO Origin: EVOLVE-LOAD-FROM-AWR
Plan rows: From dictionary
--------------------------------------------------------------------------------
Note
-----
- Failed to use SQL plan baseline for this statement
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.