Get count of recent alerts by message level
get
/database/monitoring/alerts_recent_summaries/by_message_level
Group by message level on V$DIAG_ALERT_EXT originating within the last 7 days. In an Oracle RAC environment, data returned by this service may vary according to the instance to which a session is connected. A client requires SQL Administrator role to invoke this service.
Request
There are no request parameters for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Summary of alerts from the last 7 days, aggregated by message level.
Root Schema : MonitoringAlertsSummaryMessageLevelItem
Type:
object
Title:
MonitoringAlertsSummaryMessageLevelItem
This object represents a summary of V$DIAG_ALERT_EXT records by message level. The list of attributes may vary depending on database version.
Show Source
-
con_id(optional):
integer(int32)
The ID of the container to which the data pertains.
-
inst_id(optional):
integer(int32)
Oracle Real Application Clusters instance number for which this data relates to. In a non-RAC database this number will be 1.
-
latest_messages(optional):
string
The text of the last 5 messages at this message level.
-
links(optional):
array links
-
message_level(optional):
integer(int32)
Level the message belongs to. Lower level values imply higher severity for errors.
-
message_level_name(optional):
string
A text description of the corresponding message level value.
-
number_of_messages(optional):
integer(int32)
The count of records that have this message level.