Set Thresholds for a Given Quarantine Configuration

--
-- Set Thresholds for a Given Quarantine Configuration
--
 
BEGIN
    DBMS_SQLQ.ALTER_QUARANTINE(
       QUARANTINE_NAME => '&SQL_QUARANTINE_NAME',
       PARAMETER_NAME  => 'CPU_TIME',
       PARAMETER_VALUE => '15');
 
    DBMS_SQLQ.ALTER_QUARANTINE(
       QUARANTINE_NAME => '&SQL_QUARANTINE_NAME',
       PARAMETER_NAME  => 'ELAPSED_TIME',
       PARAMETER_VALUE => '100');
END;
/

---

Published 1st April 2022