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

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