4.49 DBA_ALERT_HISTORY
DBA_ALERT_HISTORY
describes a time-limited history of alerts which are no longer 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) |
|
|
|
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 message 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 |
|
|
|
Resolution:
|
|
|
|
PDB name |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|