DBA_SQL_ERROR_MITIGATIONS

Previous Next JavaScript must be enabled to correctly display this content

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