Get all alerts
get
/database/monitoring/alerts/
Returns records from 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
Query Parameters
-
limit: integer(int32)
The maximum number of records to return.
-
q:
Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.Examples
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
200 Response
Returns database alerts.
Root Schema : MonitoringAlerts
Type:
Show Source
object
-
count: integer
Total number of records in the current response.
-
hasMore: boolean
Indicates if there are more records to be retrieved.
-
items: array
items
-
limit: integer
The actual page size limit on number of records applied by the server.
-
links: array
links
-
offset: integer
The actual index from which the item resources are returned.
Nested Schema : items
Type:
Show Source
array
-
Array of:
object MonitoringAlertsItem
This object represents an alert log record from V$DIAG_ALERT_EXT. V$DIAG_ALERT_EXT shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR). The list of attributes may vary depending on database version.
Nested Schema : MonitoringAlertsItem
Type:
object
This object represents an alert log record from V$DIAG_ALERT_EXT. V$DIAG_ALERT_EXT shows the contents of the XML-based alert log in the Automatic Diagnostic Repository (ADR). The list of attributes may vary depending on database version.
Show Source
-
adr_home: string
Directory location of the Automatic Diagnostic Repository (ADR).
-
client_id: string
ID of the client or security group that the message relates to.
-
component_id: string
ID of the product or component that originated the message.
-
con_id: integer
The ID of the container to which the data pertains.
-
detailed_location: string
Absolute pathname of supplemental detail file on the originating host.
-
downstream_comp_id: string
ID of a component that the originating component is working with on the downstream (server) side.
-
error_instance_id: integer
ID of the instance where error occurred.
-
error_instance_sequence: integer
Instance sequence where error occurred.
-
execution_context_id: string
Identifies the thread of execution that the originating component participates in.
-
execution_context_sequence: integer
Execution sequence of the thread that the originating component participates in.
-
filename: string
Physical file on disk.
-
host_address: string
IP of other network address of the originating host for the message.
-
host_id: string
DNS hostname of originating host.
-
links: array
links
-
message_arguments: string
Arguments to be bound with the generic text of the message.
-
message_group: string
Name of the group to which the message belongs.
-
message_id: string
ID of the message.
-
message_level: integer
Level the message belongs to. Lower level values imply higher severity for errors.
-
message_level_name: string
A text description of the corresponding message level value.
-
message_text: string
Fully formed and localized text of the message.
-
message_type: integer
Type of the message, indicating that a different type of response is required.
-
message_type_name: string
A text description of the corresponding message type value.
-
module_id: string
ID of the module that originated the message. This value is unique within a component.
-
normalized_timestamp: string
Date and time when the message originated, normalized for clock drift to the Oracle Enterprise Manager repository time.
-
organization_id: string
ID of the organization that wrote the originating component, usually the domain of the organization.
-
originating_timestamp: string
Date and time when the message was generated.
-
partition: integer
Segment number of physical file.
-
problem_key: string
Describes the key for the current problem that the message is associated with.
-
process_id: string
ID of the process that originated the message.
-
record_id: integer
Record number for the message (this value is same as the row number).
-
supplemental_attributes: string
Supplemental attributes that are specific to a message. This field contains the impacts for an incident type error message.
-
supplemental_details: string
Supplemental data that is specific to a particular program and error message required to complete the diagnosis.
-
thread_id: string
ID of the thread of the process that originated the message.
-
upstream_comp_id: string
ID of a component that the originating component is working with on the upstream (client) side.
-
user_id: string
ID of the user that originated the message.
-
version: integer
Oracle ARB logging standard version number for the message.