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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:51 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(51): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(66): id_of(Object(PDO), 'uri', '/notes/developm...') #2 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758206439, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #3 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/packages/dbms/spm/api/sql_plan_baseline/drop(54): insert_webrequest() #4 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 51