Get count of alerts by message type
get
/database/monitoring/alerts_summaries/by_message_type
Group by message type on V$DIAG_ALERT_EXT. 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 brokedown by message type.
Root Schema : MonitoringAlertsSummaryMessageTypeItem
Type:
object
This object represents a summary of V$DIAG_ALERT_EXT records by message type. The list of attributes may vary depending on database version.
Show Source
-
con_id(optional):
integer
The ID of the container to which the data pertains.
-
inst_id(optional):
integer
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 type.
-
links(optional):
array links
-
message_type(optional):
integer
Type of the message, indicating that a different type of response is required.
-
message_type_name(optional):
string
A text description of the corresponding message type value.
-
number_of_messages(optional):
integer
The count of records that have this message type.