Oracle 视图 DBA_ALERT_HISTORY_DETAIL 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_ALERT_HISTORY_DETAIL是系统视图，它包含所有警报行为的历史记录，所有用户都可以查看。
DBA_ALERT_HISTORY_DETAIL视图中包含了ALERT_ID，ENABLED，LAST_TRIGGERED，NEXT_TRIGGER，ELAPSED_TIME，RESULT，SEQUENCE_NUMBER，MESSAGE这些字段，用来跟踪警报行为的信息。ALERT_ID字段指定触发器，ENABLED字段表示警报是否启用，LAST_TRIGGERED字段表示警报上次触发的时间，NEXT_TRIGGER字段表示警报下次触发的时间，ELAPSED_TIME字段表示触发和回复需要的时间，RESULT字段表示警报的执行结果，SEQUENCE_NUMBER字段表示警报的触发编号，MESSAGE字段表示警报信息等。
使用DBA_ALERT_HISTORY_DETAIL视图可以查看警报的执行状态、触发的日期和执行的结果等信息，可以帮助数据库管理员了解警报的执行状态，进行调整和更新。
官方英文解释
DBA_ALERT_HISTORY_DETAIL describes a time-limited history of cleared and outstanding alerts.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Alert sequence number |
|
|
|
ID of the alert reason |
|
|
|
|
Owner of the object on which alert is issued |
|
|
|
|
Name of the object |
|
|
|
|
Name of the subobject (for example: partition) |
|
|
|
|
Type of the object (for example: table, tablespace) |
|
|
|
|
Reason for the alert |
|
|
|
|
Time when the alert was last updated |
|
|
|
|
Time when the alert was first created |
|
|
|
|
Advice of the recommended action |
|
|
|
|
Name of the advisor to be invoked for more information |
|
|
|
|
Value of the related metrics |
|
|
|
|
Message type:
|
|
|
|
|
Name of the message group to which the alert belongs |
|
|
|
|
Severity level (1 to 32) |
|
|
|
|
ID of the client or security group to which the alert relates |
|
|
|
|
ID of the module that originated the alert |
|
|
|
|
Process id |
|
|
|
|
DNS host name of the originating host |
|
|
|
|
IP or other network address of originating host |
|
|
|
|
Originating instance name |
|
|
|
|
Originating instance number |
|
|
|
|
User ID |
|
|
|
|
Execution Context ID |
|
|
|
|
ID of an error instance plus a sequence number |
|
|
|
|
Resolution:
|
|
|
|
|
|
Sequence number of the state transition for the alert |
|
|
|
PDB name |
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
