Home -> Mailing Lists -> Oracle-L -> Re: Oracle SQL Plan Baseline

Re: Oracle SQL Plan Baseline

From: Neil Chandler <neil_chandler_at_hotmail.com>
Date: Wed, 13 Mar 2019 11:43:46 +0000
Message-ID: <DB7PR10MB2090F1E3B4664EB4404AD6E3854A0_at_DB7PR10MB2090.EURPRD10.PROD.OUTLOOK.COM> 








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;


/




Plans Loaded : 0


--
http://www.freelists.org/webpage/oracle-l


Received on Wed Mar 13 2019 - 12:43:46 CET












Original text of this message