Create a Quarantine Configuration for a SQL Statement by SQL ID 
--
-- Create a Quarantine Configuration for a SQL Statement by SQL ID
--
 
DECLARE
    quarantine_config VARCHAR2(30);
BEGIN
    quarantine_config := DBMS_SQLQ.CREATE_QUARANTINE_BY_SQL_ID(
                            SQL_ID => '&sqlID');
END;
/

Note
Be warned. The quarantine configuration is applied to ALL executions and ALL execution plans of the given SQL ID

Published 1st April 2022

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