6.409 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: COMPILATION ERROR EXECUTION ERROR
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: ALTERNATE PLAN SQL PATCH
MITIGATION_NAME	VARCHAR2(128)		Mitigation name
MITIGATION_DETAILS	CLOB		Mitigation details
STATUS	CHAR(7)		Mitigation status: SUCCESS FAILURE
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 Database 23ai.