Search notes:

Oracle: DBMS_SPM.DROP_SQL_PLAN_BASELINE

declare
   res number;
begin
   
    for baslin IN (
        select
           sql_handle,
           plan_name
        from
           dba_sql_plan_baselines
        where
           sql_text like 'select%from xyz%' and
           parsing_schema_name = user
    ) loop

        res := dbms_spm.drop_sql_plan_baseline(baslin.sql_handle, baslin.plan_name);

    end loop;
end;
/

See also

dbms_spm

Index