SQL Quarantine

Disable Automatic Quarantine

• What is SQL Quarantine?
• Disable Automatic Quarantine

Quarantine Configurations

• Create a Quarantine Configuration for a SQL Statement by SQL ID
• Create a Quarantine Configuration for a SQL Statement by Plan Hash Value
• Create a Quarantine Configuration for a SQL Statement by SQL Text
• Delete a Quarantine Configuration
• Enable a Quarantine Configuration
• Disable a Quarantine Configuration
• Moving Quarantine Configurations Between Databases

Quarantine Thresholds

• Set Quarantine Thresholds for a Given Quarantine Configuration
• Query Quarantine Thresholds for a Given Quarantine Configuration

Useful Quarantine Views

• v$quarantine
• dba_sql_quarantine
• v$sql

---

Published 1st April 2022