As mentioned on twitter check 1540948.1
Rgds,
Sachin
On Wed, Mar 13, 2019 at 7:44 AM Neil Chandler <neil_chandler@xxxxxxxxxxx>
wrote:
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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Neil Chandler <neil_chandler@xxxxxxxxxxx>
*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;
/
Plans Loaded : 0