Oracle Cloud Infrastructure Documentation

Database Metrics

You can monitor the health, capacity, and performance of your Oracle Cloud Infrastructure Database service resources by using (Monitoring service) A measurement related to health, capacity, or performance of a given resource. Example: CpuUtilization, The trigger rule and query to evaluate and related configuration, such as notification details to use when the trigger is breached. Alarms passively monitor your cloud resources using metrics in Monitoring., and notifications. For more information, see Monitoring Overview and Notifications Overview.

Note

Database metrics are currently available only for Autonomous Databases in serverless deployments.

This topic describes the metrics emitted by the Database service in the oci_autonomous_database namespace.

Resources: Autonomous Databases.

Overview of the Autonomous Database Metrics

The Database service metrics help you measure useful quantitative data about your Autonomous Databases, such as CPU and storage utilization, the number of successful and failed database logon and connection attempts, database operations, SQL queries, and transactions, and so on. You can use metrics data to diagnose and troubleshoot problems with Autonomous Databases. For a complete list of available metrics for Autonomous Databases, see Available Metrics: oci_autonomous_database.

To view a default set of metrics charts in the Console, navigate to the Autonomous Database that you're interested in, and then click Metrics. You also can use the Monitoring service to create custom queries.

Prerequisites

IAM policies: To monitor resources, you must be given the required type of access in a An IAM document that specifies who has what type of access to your resources. It is used in different ways: to mean an individual statement written in the policy language; to mean a collection of statements in a single, named "policy" document (which has an Oracle Cloud ID (OCID) assigned to it); and to mean the overall body of policies your organization uses to control access to resources. written by an administrator, whether you're using the Console or the REST API with an SDK, CLI, or other tool. The policy must give you access to the monitoring services as well as the resources being monitored. If you try to perform an action and get a message that you don’t have permission or are unauthorized, confirm with your administrator the type of access you've been granted and which A collection of related resources that can be accessed only by certain groups that have been given permission by an administrator in your organization. you should work in. For more information on user authorizations for monitoring, see the Authentication and Authorization section for the related service: Monitoring or Notifications.

Available Metrics: oci_autonomous_database

The metrics listed in the following table are automatically available for any Autonomous Database that you create. You do not need to enable monitoring on the resource to get these metrics.

Database service metrics for Autonomous Databases include the following (Monitoring service) A qualifier provided in a metric definition. Example: Resource identifier (resourceId), provided in the definitions of oci_computeagent metrics.:

AutonomousDBType
The type of Autonomous Database, Autonomous Data Warehouse (ADW) or Autonomous Transaction Processing (ATP).
displayName
The friendly name of the Autonomous Database.
region
The A collection of availability domains located in a single geographic location. in which the Autonomous Database resides.
resourceId
The An Oracle-assigned unique ID called an Oracle Cloud Identifier (OCID). This ID is included as part of the resource's information in both the Console and API. of the Autonomous Database.
resourceName
The name of the Autonomous Database.

In the following table, metrics that are marked with an asterisk (*) can be viewed only on the Service Metrics page of the Oracle Cloud Infrastructure Console.

Metric Metric Display Name Unit Description Dimensions
CurrentLogons* Current Logons count The number of successful logons during the selected interval.

AutonomousDBType

displayName

region

resourceId

resourceName

CpuUtilization CPU Utilization percent The CPU utilization expressed as a percentage, aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of OCPUs.
ExecuteCount Execute Count count The number of user and recursive calls that executed SQL statements during the selected interval.
FailedConnections* Failed Connections count The number of failed database connections.
FailedLogons Failed Logons count The number of logons that failed because of an invalid username and/or password, during the selected interval.
ParseCount* Parse Count (Total) count The number of hard and soft parses during the selected interval.
QueuedStatements Queued Statements count The number of queued SQL statements, aggregated across all consumer groups, during the selected interval.
RunningStatements Running Statements count The number of running SQL statements, aggregated across all consumer groups, during the selected interval.
Sessions Sessions count The number of sessions in the database.
StorageUtilization Storage Utilization percent The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.
TransactionCount* Transaction Count count The combined number of user commits and user rollbacks during the selected interval.
UserCalls* User Calls count The combined number of logons, parses, and execute calls during the selected interval.

Using the Console

To view default metric charts for a single Autonomous Database
To view default metric charts for multiple Autonomous Databases

Using the API

For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.

Use the following APIs for monitoring: