Oracle 视图 V$DIAG_INCIDENT 官方解释，作用，如何使用详细说明
本站中文解释
V$DIAG_INCIDENT视图提供了数据库检查失败的报告，也被称为故障报告，这些报告可以帮助DBA诊断和解决数据库问题。
该视图用于显示数据库检查期间检测到的问题，并为每个问题显示可以使用的解决方法。可以使用视图来检查哪些检查失败，以及与每个失败有关的信息。在发现问题后，可以按照提供的解决方案进行处理，然后可以跟踪问题的解决过程。
使用V（$）DIAG_INCIDENT视图非常简单，只需要简单地使用SELECT语句运行视图来获取有关数据库上发生检查失败的信息。例如，下面的查询可以用来获取有关视图的所有行：
SELECT *
FROM V$DIAG_INCIDENT;
官方英文解释
V$DIAG_INCIDENT contains information about all incident metadata records present in the Automatic Diagnostic Repository (ADR) for the current container (PDB).
| Column | Datatype | Description |
|---|---|---|
|
|
|
ID for the current incident |
|
|
|
ID for the problem that the incident is associated with |
|
|
|
Displays the date and time when the incident was created |
|
|
|
Displays the date and time when the incident was closed |
|
|
|
Describes the current status for the incident. Possible values include:
|
|
|
|
For internal use only |
|
|
|
Describes the flood control status for the current incident. Possible values include:
|
|
|
|
Displays the error facility for the current incident |
|
|
|
Displays the error number for the current incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Signalling component for the given incident |
|
|
|
Signalling sub-component for the given incident |
|
|
|
Displays the suspect component for the given incident |
|
|
|
Displays the suspect sub-component for the given incident |
|
|
|
Execution context ID for the current incident |
|
|
|
Describes the internal representation of the incident impact for the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Displays error-arguments associated with the given incident |
|
|
|
Describes the container unique ID to which the data pertains |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
