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>
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-lReceived on Wed Mar 13 2019 - 12:16:20 CET