Monitor a Database

You can monitor the health, capacity, and performance of a Database by using metrics, alarms, and notifications. Oracle Base Database Cloud@Customer publishes metrics to the Monitoring service, where you can view them by using the Console, the Monitoring API, or other supported tools.

Before you begin, review the following:

• Viewing metrics requires the appropriate IAM permissions. For more information, see Getting Started with Policies.
• By default, the Console displays metrics for the previous hour.
• Up to one hour of metric data might be unavailable after network connectivity is restored before metric collection resumes.

View metrics

Perform the following steps in the Console.

1. On the Data Infrastructures list page, select the Data Infrastructure that you want to work with. If you need help finding the list page or the Data Infrastructure, see List Data Infrastructures.

2. On the Data Infrastructure details page, select the VM Cluster tab to view the list of all VM Clusters.
3. On the VM Clusters tab, select the VM Cluster that you want to work with.

4. On the VM Cluster details page, select the Databases tab to view the list of all databases.

5. On the Databases tab, select the Database that you want to work with.

6. On the Database details page, select the Monitoring tab.

   A chart for each metric is displayed. By default, the metrics for the last hour are displayed.

Metric filters

Use filters to select the resource and time range for which you want to view the metrics.

Filter by date

Optionally, use the Date filter to constrain results to a specific start and end time (in UTC) or to select a predefined range.

1. Next to Applied filters, select Date.

2. Specify a custom time range by providing the following values:

   • Start date(Required): Select the start date for the time range.
   • Start time(Required): Enter the start time (UTC).
   • End date(Required): Select the end date for the time range.
   • End time(Required): Enter the end time (UTC).

   • Or, select a preset range:

     • Last hour
     • Last 6 hours
     • Last 12 hours
     • Last 24 hours
     • Last 7 days
     • Last 30 days
     • Last 90 days
3. Select Apply filter to refresh the results.

Metric charts

A separate chart is displayed for each metric. By default, charts show data for the last hour.

Change the interval and statistic

For each metric, you can set the Interval and Statistic independently, and then apply your changes.

1. For a metric chart, select the Interval and Statistic values.
2. Select Apply filter.

Interval

The time period used to calculate the metric data points. The default is Auto. Available intervals are: Auto, 1 minute, 5 minutes, 1 hour, 1 day.

Statistic

The aggregation method used to calculate the metric. The default is Mean. Available statistics are: Rate, Sum, Mean, Min, Max, Count, P50, P90, P95, P99, P99.9.

Metric Actions menu options

For each metric chart, you can select the following options from the Actions menu:

• Hide Legend
• View query in Metrics Explorer
• Copy chart URL
• Copy query (MQL)
• Create an alarm on this query
• Table view

Metrics emitted by the Database

This section describes the metrics emitted by the Database in the oci_database namespace.

The following metrics are automatically available for the Database. In addition to the metrics documented here, Oracle may analyze other operational metrics to support service operations and help maintain high availability.

Metric Display Name	Metric Name	Unit	Description	Dimensions
CPU Utilization	CpuUtilization	Percentage	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.	instanceNumber, instanceName, hostname, deploymentType, resourceId_{database/pdb}, resourceName_{database/pdb}
Storage Utilization	StorageUtilization	Percentage	The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.	deploymentType, resourceId_{database/pdb}, esourceName_{database/pdb}
Block Changes	BlockChanges	Changes per second	The Average number of blocks changed per second.	instanceNumber, instanceName, hostname, deploymentType, resourceId_{database/pdb}, resourceName_{database/pdb}
Execute Count	ExecuteCount	Count	The number of user and recursive calls that executed SQL statements during the selected interval.	instanceNumber, instanceName, hostname, deploymentType, resourceId_{database/pdb}, resourceName_{database/pdb}
Current Logons	CurrentLogons	Count	The number of successful logons during the selected interval.	instanceNumber, instanceName, hostname, deploymentType, resourceId_{database/pdb}, resourceName_{database/pdb}
Parse Count (Total)	ParseCount	Count	The number of hard and soft parses during the selected interval.	instanceNumber, instanceName, hostname, deploymentType, resourceId_{database/pdb}, resourceName_{database/pdb}