SQL_ERROR_MITIGATION

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