Database Management Diagnosability Functions

Package: DBMS_CLOUD_OCI_DM_DIAGNOSABILITY

LIST_ALERT_LOGS Function

Lists the alert logs for the specified Managed Database.

Syntax

FUNCTION list_alert_logs (
  managed_database_id varchar2,
  time_greater_than_or_equal_to timestamp with time zone DEFAULT NULL,
  time_less_than_or_equal_to timestamp with time zone DEFAULT NULL,
  level_filter varchar2 DEFAULT NULL,
  type_filter varchar2 DEFAULT NULL,
  log_search_text varchar2 DEFAULT NULL,
  is_regular_expression number DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_dm_diagnosability_list_alert_logs_response_t;

Parameters

Parameter	Description
`managed_database_id`	(required) The OCID of the Managed Database.
`time_greater_than_or_equal_to`	(optional) The optional greater than or equal to timestamp to filter the logs.
`time_less_than_or_equal_to`	(optional) The optional less than or equal to timestamp to filter the logs.
`level_filter`	(optional) The optional parameter to filter the alert logs by log level. Allowed values are: 'CRITICAL', 'SEVERE', 'IMPORTANT', 'NORMAL', 'ALL'
`type_filter`	(optional) The optional parameter to filter the attention or alert logs by type. Allowed values are: 'UNKNOWN', 'INCIDENT_ERROR', 'ERROR', 'WARNING', 'NOTIFICATION', 'TRACE', 'ALL'
`log_search_text`	(optional) The optional query parameter to filter the attention or alert logs by search text.
`is_regular_expression`	(optional) The flag to indicate whether the search text is regular expression or not.
`sort_by`	(optional) The possible sortBy values of attention logs. Allowed values are: 'LEVEL', 'TYPE', 'MESSAGE', 'TIMESTAMP'
`sort_order`	(optional) The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. Allowed values are: 'ASC', 'DESC'
`page`	(optional) The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.
`limit`	(optional) The maximum number of records returned in the paginated response.
`opc_request_id`	(optional) The client request ID for tracing.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://dbmgmt.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

LIST_ATTENTION_LOGS Function

Lists the attention logs for the specified Managed Database.

Syntax

FUNCTION list_attention_logs (
  managed_database_id varchar2,
  time_greater_than_or_equal_to timestamp with time zone DEFAULT NULL,
  time_less_than_or_equal_to timestamp with time zone DEFAULT NULL,
  urgency_filter varchar2 DEFAULT NULL,
  type_filter varchar2 DEFAULT NULL,
  log_search_text varchar2 DEFAULT NULL,
  is_regular_expression number DEFAULT NULL,
  sort_by varchar2 DEFAULT NULL,
  sort_order varchar2 DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_dm_diagnosability_list_attention_logs_response_t;

Parameters

Parameter	Description
`managed_database_id`	(required) The OCID of the Managed Database.
`time_greater_than_or_equal_to`	(optional) The optional greater than or equal to timestamp to filter the logs.
`time_less_than_or_equal_to`	(optional) The optional less than or equal to timestamp to filter the logs.
`urgency_filter`	(optional) The optional parameter to filter the attention logs by urgency. Allowed values are: 'IMMEDIATE', 'SOON', 'DEFERRABLE', 'INFO', 'ALL'
`type_filter`	(optional) The optional parameter to filter the attention or alert logs by type. Allowed values are: 'UNKNOWN', 'INCIDENT_ERROR', 'ERROR', 'WARNING', 'NOTIFICATION', 'TRACE', 'ALL'
`log_search_text`	(optional) The optional query parameter to filter the attention or alert logs by search text.
`is_regular_expression`	(optional) The flag to indicate whether the search text is regular expression or not.
`sort_by`	(optional) The possible sortBy values of attention logs. Allowed values are: 'URGENCY', 'TYPE', 'MESSAGE', 'TIMESTAMP', 'SCOPE', 'TARGET_USER'
`sort_order`	(optional) The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Ascending order is the default order. Allowed values are: 'ASC', 'DESC'
`page`	(optional) The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.
`limit`	(optional) The maximum number of records returned in the paginated response.
`opc_request_id`	(optional) The client request ID for tracing.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://dbmgmt.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

SUMMARIZE_ALERT_LOG_COUNTS Function

Get the counts of alert logs for the specified Managed Database.

Syntax

FUNCTION summarize_alert_log_counts (
  managed_database_id varchar2,
  time_greater_than_or_equal_to timestamp with time zone DEFAULT NULL,
  time_less_than_or_equal_to timestamp with time zone DEFAULT NULL,
  level_filter varchar2 DEFAULT NULL,
  group_by varchar2 DEFAULT NULL,
  type_filter varchar2 DEFAULT NULL,
  log_search_text varchar2 DEFAULT NULL,
  is_regular_expression number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_dm_diagnosability_summarize_alert_log_counts_response_t;

Parameters

Parameter	Description
`managed_database_id`	(required) The OCID of the Managed Database.
`time_greater_than_or_equal_to`	(optional) The optional greater than or equal to timestamp to filter the logs.
`time_less_than_or_equal_to`	(optional) The optional less than or equal to timestamp to filter the logs.
`level_filter`	(optional) The optional parameter to filter the alert logs by log level. Allowed values are: 'CRITICAL', 'SEVERE', 'IMPORTANT', 'NORMAL', 'ALL'
`group_by`	(optional) The optional parameter used to group different alert logs. Allowed values are: 'LEVEL', 'TYPE'
`type_filter`	(optional) The optional parameter to filter the attention or alert logs by type. Allowed values are: 'UNKNOWN', 'INCIDENT_ERROR', 'ERROR', 'WARNING', 'NOTIFICATION', 'TRACE', 'ALL'
`log_search_text`	(optional) The optional query parameter to filter the attention or alert logs by search text.
`is_regular_expression`	(optional) The flag to indicate whether the search text is regular expression or not.
`page`	(optional) The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.
`limit`	(optional) The maximum number of records returned in the paginated response.
`opc_request_id`	(optional) The client request ID for tracing.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://dbmgmt.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

SUMMARIZE_ATTENTION_LOG_COUNTS Function

Get the counts of attention logs for the specified Managed Database.

Syntax

FUNCTION summarize_attention_log_counts (
  managed_database_id varchar2,
  time_greater_than_or_equal_to timestamp with time zone DEFAULT NULL,
  time_less_than_or_equal_to timestamp with time zone DEFAULT NULL,
  urgency_filter varchar2 DEFAULT NULL,
  group_by varchar2 DEFAULT NULL,
  type_filter varchar2 DEFAULT NULL,
  log_search_text varchar2 DEFAULT NULL,
  is_regular_expression number DEFAULT NULL,
  page varchar2 DEFAULT NULL,
  limit number DEFAULT NULL,
  opc_request_id varchar2 DEFAULT NULL,
  region varchar2 DEFAULT NULL, 
  endpoint varchar2 DEFAULT NULL,
  credential_name varchar2 DEFAULT NULL
) RETURN dbms_cloud_oci_dm_diagnosability_summarize_attention_log_counts_response_t;

Parameters

Parameter	Description
`managed_database_id`	(required) The OCID of the Managed Database.
`time_greater_than_or_equal_to`	(optional) The optional greater than or equal to timestamp to filter the logs.
`time_less_than_or_equal_to`	(optional) The optional less than or equal to timestamp to filter the logs.
`urgency_filter`	(optional) The optional parameter to filter the attention logs by urgency. Allowed values are: 'IMMEDIATE', 'SOON', 'DEFERRABLE', 'INFO', 'ALL'
`group_by`	(optional) The optional parameter used to group different attention logs. Allowed values are: 'URGENCY', 'TYPE'
`type_filter`	(optional) The optional parameter to filter the attention or alert logs by type. Allowed values are: 'UNKNOWN', 'INCIDENT_ERROR', 'ERROR', 'WARNING', 'NOTIFICATION', 'TRACE', 'ALL'
`log_search_text`	(optional) The optional query parameter to filter the attention or alert logs by search text.
`is_regular_expression`	(optional) The flag to indicate whether the search text is regular expression or not.
`page`	(optional) The page token representing the page from where the next set of paginated results are retrieved. This is usually retrieved from a previous list call.
`limit`	(optional) The maximum number of records returned in the paginated response.
`opc_request_id`	(optional) The client request ID for tracing.
`region`	(optional) OCI region id. e.g us-phoenix-1 for US West (Phoenix).
`endpoint`	(optional) The endpoint of the service to call using this function. e.g https://dbmgmt.{region}.oci.{secondLevelDomain}.If both endpoint and region are given, then endpoint takes precedence.
`credential_name`	(optional) The name of the credential for authenticating with the corresponding cloud native API.

Oracle Cloud Infrastructure Documentation

LIST_ALERT_LOGS Function

LIST_ATTENTION_LOGS Function

SUMMARIZE_ALERT_LOG_COUNTS Function

SUMMARIZE_ATTENTION_LOG_COUNTS Function