2.377 SQL_ERROR_MITIGATION

Use SQL_ERROR_MITIGATION to enable or disable automatic error mitigation for SQL statements.

Property	Description
Parameter type	String
Syntax	SQL_ERROR_MITIGATION = { ON | OFF }
Default value	ON
Modifiable	ALTER SESSION, ALTER SYSTEM
Modifiable in a PDB	Yes
Basic	No
Oracle RAC	Different instances can use different values.

Set this parameter to ON to enable automatic error mitigation for SQL statements; set it to OFF to disable automatic error mitigation for SQL statements.

Note:

This parameter is available starting with Oracle Database 23ai.