Oracle SQL Plan Baseline

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



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:16:20 CET

Original text of this message