Oracle 视图 V$DIAG_ALERT_EXT 官方解释，作用，如何使用详细说明
本站中文解释
V$DIAG_ALERT_EXT视图是Oracle操作系统监控中提供的一个视图，用于查看系统产生的警报。视图包括以下信息：报警ID、警报名称、警报级别、扩展信息、报警消息及手动处理报警方法。
使用V$DIAG_ALERT_EXT视图之前需要先启动警报服务。可使用如下语句：
SQL> EXECUTE DBMS_SERVER_ALERT.START_SERVER_ALERT;
查询时可以使用如下SQL语句：
SQL> SELECT * FROM V$DIAG_ALERT_EXT;
官方英文解释
V$DIAG_ALERT_EXT shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR) for the current container (PDB).
| Column | Datatype | Description |
|---|---|---|
|
|
|
Date and time when the message was generated |
|
|
|
Date and time when the message originated, normalized for clock drift to the Oracle Enterprise Manager repository time |
|
|
|
ID of the organization that wrote the originating component, usually the domain of the organization |
|
|
|
ID of the product or component that originated the message |
|
|
|
DNS hostname of originating host |
|
|
|
IP of other network address of the originating host for the mesaage |
|
|
|
Type of the message, indicating that a different type of response is required. Possible values include:
|
|
|
|
Level the message belongs to. Lower level values imply higher severity for errors. Possible values include:
|
|
|
|
ID of the message |
|
|
|
Name of the group to which the message belongs |
|
|
|
ID of the client or security group that the message relates to |
|
|
|
ID of the module that originated the message. This value is unique within a component. |
|
|
|
ID of the process that originated the message |
|
|
|
ID of the thread of the process that originated the message |
|
|
|
ID of the user that originated the message |
|
|
|
For internal use only |
|
|
|
Absolute pathname of supplemental detail file on the originating host |
|
|
|
ID of a component that the originating component is working with on the upstream (client) side |
|
|
|
ID of a component that the originating component is working with on the downstream (server) side |
|
|
|
Identifies the thread of execution that the originating component participates in |
|
|
|
Execution sequence of the thread that the originating component participates in |
|
|
|
ID of the instance where error occurred |
|
|
|
Instance sequence where error occurred |
|
|
|
Fully formed and localized text of the message |
|
|
|
Arguments to be bound with the generic text of the message |
|
|
|
Supplemental attributes that are specific to a message. This field contains the impacts for an incident type error message. |
|
|
|
Supplemental data that is specific to a particular program and error message required to complete the diagnosis. Similar to the extra detail referred to in |
|
|
|
Segment number of physical file |
|
|
|
Record number for the message (this value is same as the row number) |
|
|
|
Physical file on disk |
|
|
|
For internal use only |
|
|
|
Describes the key for the current problem that the message is associated with |
|
|
|
ARB version number for the message |
|
|
|
The unique ID of the container to which the data pertains |
|
|
|
The ID of the container to which the data pertains |
|
|
|
The name of the container to which the data pertains |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
