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