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:
|
