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