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
Supported Media Types
- application/json
Query Parameters
-
limit(optional): integer(int32)
The maximum number of records to return.
-
q(optional): string
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.
Response
Supported Media Types
- application/json
200 Response
Returns database alerts.
Root Schema : MonitoringAlerts
Type:
Show Source
object
-
count(optional):
integer
Total number of records in the current response.
-
hasMore(optional):
boolean
Indicates if there are more records to be retrieved.
-
items(optional):
array items
-
limit(optional):
integer
The actual page size limit on number of records applied by the server.
-
links(optional):
array links
-
offset(optional):
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(optional):
string
Directory location of the Automatic Diagnostic Repository (ADR).
-
client_id(optional):
string
ID of the client or security group that the message relates to.
-
component_id(optional):
string
ID of the product or component that originated the message.
-
con_id(optional):
integer
The ID of the container to which the data pertains.
-
detailed_location(optional):
string
Absolute pathname of supplemental detail file on the originating host.
-
downstream_comp_id(optional):
string
ID of a component that the originating component is working with on the downstream (server) side.
-
error_instance_id(optional):
integer
ID of the instance where error occurred.
-
error_instance_sequence(optional):
integer
Instance sequence where error occurred.
-
execution_context_id(optional):
string
Identifies the thread of execution that the originating component participates in.
-
execution_context_sequence(optional):
integer
Execution sequence of the thread that the originating component participates in.
-
filename(optional):
string
Physical file on disk.
-
host_address(optional):
string
IP of other network address of the originating host for the message.
-
host_id(optional):
string
DNS hostname of originating host.
-
links(optional):
array links
-
message_arguments(optional):
string
Arguments to be bound with the generic text of the message.
-
message_group(optional):
string
Name of the group to which the message belongs.
-
message_id(optional):
string
ID of the message.
-
message_level(optional):
integer
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.
-
message_text(optional):
string
Fully formed and localized text of the message.
-
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.
-
module_id(optional):
string
ID of the module that originated the message. This value is unique within a component.
-
normalized_timestamp(optional):
string
Date and time when the message originated, normalized for clock drift to the Oracle Enterprise Manager repository time.
-
organization_id(optional):
string
ID of the organization that wrote the originating component, usually the domain of the organization.
-
originating_timestamp(optional):
string
Date and time when the message was generated.
-
partition(optional):
integer
Segment number of physical file.
-
problem_key(optional):
string
Describes the key for the current problem that the message is associated with.
-
process_id(optional):
string
ID of the process that originated the message.
-
record_id(optional):
integer
Record number for the message (this value is same as the row number).
-
supplemental_attributes(optional):
string
Supplemental attributes that are specific to a message. This field contains the impacts for an incident type error message.
-
supplemental_details(optional):
string
Supplemental data that is specific to a particular program and error message required to complete the diagnosis.
-
thread_id(optional):
string
ID of the thread of the process that originated the message.
-
upstream_comp_id(optional):
string
ID of a component that the originating component is working with on the upstream (client) side.
-
user_id(optional):
string
ID of the user that originated the message.
-
version(optional):
integer
Oracle ARB logging standard version number for the message.