Create a Quarantine Configuration for a SQL Statement by Plan Hash Value

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

Note
Be warned. The quarantine configuration is applied to ALL executions of SQLID for the given Plan Hash Value

---

Published 1st April 2022