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.