Oracle 视图 DBA_OUTSTANDING_ALERTS 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_OUTSTANDING_ALERTS存储当前正处于活动状态的所有警告，以及处理每个警告的信息（如果有的话）。此视图可提供以下信息：
– 警告ID：每条警告都有唯一的标识符。
– 优先级：警告的重要程度（最高，高，中，低）。
– 状态：指示警告是否被消除（已清除）。
– 信息：实际警告内容。
要在一般情况下查看当前激活的警告，可以使用以下查询：
SELECT F.Warning_id, F.priority, F.status, F.Info
FROM DBA_OUTSTANDING_ALERTS F
WHERE F.Status ‘CLEARED’
ORDER BY F.priority;
官方英文解释
DBA_OUTSTANDING_ALERTS describes alerts which the server considers to be outstanding.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Alert sequence number |
|
|
|
|
|
ID of the alert reason |
|
|
|
Owner of the object on which the alert was issued |
|
|
|
|
Name of the object |
|
|
|
|
Name of the subobject (for example: partition) |
|
|
|
|
Object type (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 |
|
|
|
|
Message 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 the originating host |
|
|
|
|
Originating instance name |
|
|
|
|
Originating instance number |
|
|
|
|
User ID |
|
|
|
|
Execution Context ID |
|
|
|
|
ID of an error instance plus a sequence number |
|
|
|
|
Sequence number of the state transition for the alert |
|
|
|
|
PDB name |
|
|
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
