OPTIMIZER_CAPTURE_SQL_QUARANTINE

OPTIMIZER_CAPTURE_SQL_QUARANTINE enables or disables the automatic creation of SQL Quarantine configurations.

Property	Description
Parameter type	Boolean
Default value	false
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Range of values	true | false
Basic	No
Oracle RAC	Different instances can use different values.

Values:

• true

  Enables the automatic creation of SQL Quarantine configurations. If the Resource Manager terminates a SQL statement because the statement has exceeded resource limits, then the database automatically creates a SQL Quarantine configuration for the execution plan used by the terminated SQL statement. Note that the plan for a terminated SQL statement is quarantined, not the statement itself.

• false

  Disables the automatic creation of SQL Quarantine configurations.

See Also:

• “DBA_SQL_QUARANTINE”

• “OPTIMIZER_USE_SQL_QUARANTINE”

• Oracle AI Database SQL Tuning Guide for more information about SQL Quarantine