1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. OPTIMIZER_CAPTURE_SQL_QUARANTINE

2.244 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.

Note:

This parameter is available starting with Oracle Database 21c.

See Also: