Tracing enabled - thanks Timur! At least I know why now...
declare
cnt number;
begin
dbms_spm.configure('spm_tracing',1);
cnt := dbms_spm.load_plans_from_sqlset(sqlset_name=>'NEIL',SQLSET_OWNER=>'NEIL_DBA');
dbms_output.put_line('Plans Loaded : '||to_char(cnt));
dbms_spm.configure('spm_tracing',0);
end;
/
From the trace:
load sts: sql_id=4jcxvz3adqbs2 phv=1905606778
load sts: plan has empty outline, skipping it
Neil.
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Neil Chandler <neil_chandler_at_hotmail.com>
Sent: 13 March 2019 11:16
To: oracle-l-freelists
Subject: Oracle SQL Plan Baseline
Does anyone know how to determine why an Oracle SQL Plan Baseline will not create from a SQL Tuning set? 11.2.0.3
select ... from dba_sqlset_statements where sqlset_name = 'NEIL
SQLSET_NAME SQLSET_OWNER SQLSET_ID SQL_ID PLAN_HASH_VALUE FORCE_MATCHING_SIGNATURE PARSING_SCHEMA_NAME
NEIL NEIL_DBA 35 4jcxvz3adqbs2 1905606778 6134983393191283611 APP
declare
cnt number;
begin
cnt := dbms_spm.load_plans_from_sqlset(sqlset_name=>'NEIL',SQLSET_OWNER=>'NEIL_DBA');
dbms_output.put_line('Plans Loaded : '||to_char(cnt));
end;
