Drop All Statements from an SQL Tuning Set Except the Fastest Plan Hash Value
--
-- Drop All Statements from an SQL Tuning Set Except the Fastest Plan Hash Value
-- 
 
declare
    phv varchar(1000);
 
begin
  select 'plan_hash_value !='||plan_hash_value||'' into phv from dba_sqlset_statements where elapsed_time=(select min(elapsed_time) from dba_sqlset_statements where sqlset_name='STS_8d65f5452jkjr');
  dbms_sqltune.delete_sqlset(sqlset_name=>'STS_8d65f5452jkjr',basic_filter=>''||phv||'');
end;
/

Published 1st November 2021

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License