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 AI Database 26ai.