DBA_SQL_ERROR_MITIGATIONS
DBA_SQL_ERROR_MITIGATIONS describes automatic error mitigations for SQL statements.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SQL_ID |
VARCHAR2(13) |
Identifier for the relevant SQL statement | |
SIGNATURE |
NUMBER |
Unique SQL identifier generated from normalized SQL text | |
FORCE_MATCHING |
VARCHAR2(3) |
Indicates whether the signature is force matching (YES) or exact matching (NO) |
|
SQL_TEXT |
CLOB |
SQL text | |
INCIDENT_ID |
NUMBER |
ID for the incident associated with the error mitigation | |
PROBLEM_KEY |
VARCHAR2(64) |
Description of the problem | |
PROBLEM_TYPE |
VARCHAR2(17) |
Problem type:
|
|
CREATED |
TIMESTAMP(6) WITH TIME ZONE |
Date and time at which the first automatic error mitigation was created on this SQL | |
START_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Start date and time of automatic error mitigation | |
END_TIME |
TIMESTAMP(6) WITH TIME ZONE |
End date and time of automatic error mitigation | |
NOTES |
CLOB |
Mitigation notes | |
MITIGATION_TYPE |
VARCHAR2(14) |
Mitigation type:
|
|
MITIGATION_NAME |
VARCHAR2(128) |
Mitigation name | |
MITIGATION_DETAILS |
CLOB |
Mitigation details | |
STATUS |
CHAR(7) |
Mitigation status:
|
|
LAST_VERIFIED |
TIMESTAMP(6) WITH TIME ZONE |
Date and time at which the auto patch was last verified |
Note: This view is available starting with Oracle AI Database 26ai.