Oracle Cloud Database Metrics

You can monitor the health, capacity, and performance of your Oracle Cloud Databases by using metrics, alarms, and notifications. This section describes the metrics emitted by Database Management in the oracle_oci_database namespace for Oracle Cloud Databases.

Oracle Cloud Databases are Oracle Databases running on the following co-managed Oracle Database cloud solutions:

  • Base Database Service
  • Oracle Exadata Database Service on Dedicated Infrastructure (Exadata Cloud Infrastructure)

The metrics for Oracle Cloud Databases help measure useful quantitative data, such as CPU and storage utilization, the number of successful and failed database logon and connection attempts, database operations, SQL queries, and transactions. You can use the metrics data to diagnose and troubleshoot issues.

Note

Certain key metrics are available for the Base Database Service and Exadata Cloud Infrastructure without enabling Database Management. These metrics are emitted in the oci_database_cluster and oci_database namespaces by the Database service, and you can use them to monitor Exadata VM clusters and Oracle Databases. Irrespective of whether Database Management is enabled or not, the metrics displayed on the Base Database Service and Exadata Cloud Infrastructure pages are emitted by the Database service. For information on the metrics and dimensions related to the oci_database_cluster and oci_database namespaces, see Available Metrics for Base Database Service Resources and Metrics for Oracle Exadata Database Service on Dedicated Infrastructure in the Monitoring Service.

If you've already enabled Database Management, you can continue to view all the metrics in the oracle_oci_database namespace. In addition, you can enable Database Management with the Full management option for advanced metrics and features such as fleet monitoring and SQL Tuning Advisor. For information on management options, see About Management Options. Note that enabling Database Management does not emit metrics for Exadata VM clusters, and in such a case you can use the metrics emitted by the Database service (oci_database_cluster namespace) and for Oracle Databases, you can use the metrics emitted by Database Management (oracle_oci_database namespace).

Dimensions

The metrics for Oracle Cloud Databases include the following dimensions.

Dimension Description
resourceId The OCID of the database.
resourceName The name of the database.
deploymentType The deployment type of the database.

Valid alarm intervals are 5 minutes or greater due to the frequency at which these metrics are emitted. For information on how to create alarms, see Managing Alarms.

Retention period is set for 90 days. For information on retention periods, see Storage Limits.

The database metrics are provided for the Basic and Full management options. If you've enabled Database Management with the Full management option, then the Full management metrics are available to you in addition to the Basic management metrics. For information on management options, see About Management Options.

Basic Management Metrics in the oracle_oci_database Namespace

The metrics listed in the following table are available for Oracle Cloud Databases enabled with the Basic management option.

Metric Name Metric Display Name Unit Description and Metric Chart Defaults Collection Frequency Dimensions
BlockChanges DB Block Changes changes per second

The average number of blocks changed per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

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.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

CurrentLogons Current Logons count

The number of successful logons during the selected interval.

Statistics: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

ExecuteCount Execute Count count

The number of user and recursive calls that executed SQL statements during the selected interval.

Statistic: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

MonitoringStatus Monitoring Status NA

The monitoring status of the resource. If metric collection fails, error information is captured in this metric.

Statistic: Mean

Interval: 5 minutes

5 minutes

collectionName

errorSeverity

errorCode

OcpusAllocated OCPU Allocated integer

The actual number of OCPUs allocated by the service during the selected interval of time.

Statistic: Count

Interval: 1 minute

5 minutes NA
ParseCount Parse Count (Total) count

The number of hard and soft parses during the selected interval.

Statistic: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

StorageAllocated Allocated Storage Space GB

The total amount of storage space allocated to the database at collection time.

Statistic: Max

Interval: 30 minutes

30 minutes NA
StorageAllocatedByTablespace Allocated Storage Space By Tablespace GB

The total amount of storage space allocated to the tablespace at collection time. In the case of CDBs, this metric provides root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

StorageUsed Storage Space Used GB

The total storage used by the database at collection time, including the space used by tablespaces, flash recovery area, control files, and log files.

Statistic: Max

Interval: 30 minutes

30 minutes NA
StorageUsedByTablespace Storage Space Used By Tablespace GB

The total amount of storage space used by tablespace at collection time. In the case of CDBs, this metric provides root container tablespace.

Statistic: Max

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

StorageUtilization Storage Utilization percent

The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces.

Statistic: Mean

Interval: 30 minutes

30 minutes NA
StorageUtilizationByTablespace Storage Space Utilization By Tablespace percent

The percentage of storage space utilized by the tablespace at the collection time. In the case of CDBs, this metric provides root container tablespaces.

Statistic: mean

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

TransactionCount Transaction Count count

The combined number of user commits and user rollbacks during the selected interval.

Statistic: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

UserCalls User Calls count

The combined number of logons, parses, and execute calls during the selected interval.

Statistic: Sum

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

Full Management Metrics in the oracle_oci_database Namespace

The metrics listed in the following table are available for Oracle Cloud Databases enabled with the Full management option.

Metric Name Metric Display Name Unit Description and Metric Chart Defaults Collection Frequency Dimensions
AllocatedStorageUtilizationByTablespace Allocated Space Utilization By Tablespace percent

The percentage of space used by a tablespace, out of allocated space. For CDBs, this metric provides data for root container tablespaces.

Statistic: Mean

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

AvgGCCRBlockReceiveTime Average GC CR Block Receive Time milliseconds

The average global cache consistent-read (CR) block receive time.

Statistic: Mean

Interval: 5 minutes

For RAC CDBs and RAC non-CDBs only.

5 minutes

instanceNumber

instanceName

hostName

BlockingSessions Blocking Sessions count

The current blocking sessions.

Statistic: Max

Interval: 15 minutes

Not applicable for CDBs.

15 minutes NA
CPUTime CPU Time seconds per second

The average rate of accumulation of CPU time by foreground sessions in the database instance over the time interval. The CPU time component of Average Active Sessions.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

dbmgmtJobExecutionsCount Job Executions count

The number of SQL job executions on a single Managed Database or a Database Group, and their status. Status dimensions can be the following values: "Succeeded", "Failed," "InProgress."

Statistic: Sum

Interval: 1 minute

NA

managedDatabaseId

managedDatabaseGroupId

jobId

status

DBTime DB Time seconds per second

The average rate of accumulation of database time (CPU + Wait) by foreground sessions in the database instance over the time interval. Also known as Average Active Sessions.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

FRASpaceLimit Flash Recovery Area Limit GB

The flash recovery area space limit.

Statistic: Max

Interval: 15 minutes

Not applicable for PDBs.

15 minutes NA
FRAUtilization Flash Recovery Area Utilization percent

The flash recovery area utilization.

Statistic: Mean

Interval: 15 minutes

Not applicable for PDBs.

15 minutes NA
GCCRBlocksReceived GC CR Blocks Received blocks per second

The global cache CR blocks received per second.

Statistic: Mean

Interval: 5 minutes

For RAC CDBs and RAC non-CDBs only.

5 minutes

instanceNumber

instanceName

hostName

GCCurrentBlocksReceived GC Current Blocks Received blocks per second

The global cache current blocks received per second.

Statistic: Mean

Interval: 5 minutes

For RAC CDBs and RAC non-CDBs only.

5 minutes

instanceNumber

instanceName

hostName

InterconnectTraffic Average Interconnect Traffic MB per second

The average internode data transfer rate.

Statistic: Mean

Interval: 5 minutes

For RAC CDBs and RAC non-CDBs only.

5 minutes

instanceNumber

instanceName

hostName

InvalidObjects Invalid Objects count

The number of invalid database objects.

Statistic: Max

Interval: 24 hours

Not applicable for CDBs.

24 hours NA
IOPS IOPS operations per second

The average number of IO operations per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

ioType (Read, Write)

IOThroughput IO Throughput MB per second

The average throughput in MB per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

ioType (Read, Write)

LogicalBlocksRead Logical Reads reads per second

The average number of blocks read from SGA/Memory (buffer cache) per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

MaxTablespaceSize Max Tablespace Size GB

The maximum possible tablespace size. For CDBs, this metric provides data for root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

MemoryUsage Memory Usage MB

The total size of the memory pool.

Statistic: Mean

Interval: 15 minutes

15 minutes

instanceNumber

instanceName

hostName

memoryType (SGA, PGA)

memoryPool (AllocatedPGA, BufferCache, FixedSGA, JavaPool, LargePool, LogBuffer, OtherPools, SharedPool, StreamsPool )

NonReclaimableFRA Non Reclaimable Fast Recovery Area percent

The non-reclaimable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for PDBs.

15 minutes NA
ParsesByType Parses By Type parses per second

The number of hard or soft parses per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

parseType (HardParse, SoftParse)

ProblematicScheduledDBMSJobs Problematic Scheduled DBMS Jobs count

The number of problematic scheduled database jobs.

Statistic: Max

Interval: 15 minutes

Not applicable for CDBs.

15 minutes type (Broken, Failed)
Processes Process Count count

The number of database processes.

Statistic: Max

Interval: 1 minute

Not applicable for PDBs.

5 minutes

instanceNumber

instanceName

hostName

ProcessLimitUtilization Process Limit Utilization percent

The process limit utilization.

Statistic: Mean

Interval: 1 minute

Not applicable for PDBs.

5 minutes

instanceNumber

instanceName

hostName

ReclaimableFRA Reclaimable Fast Recovery Area percent

The reclaimable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for PDBs.

15 minutes NA
ReclaimableFRASpace Flash Recovery Area Reclaimable Space GB

The flash recovery area reclaimable space.

Statistic: Mean

Interval: 15 minutes

Not applicable for PDBs.

15 minutes NA
RedoSize Redo Generated MB per second

The average amount of redo generated.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

SessionLimitUtilization Session Limit Utilization percent

The session limit utilization.

Statistic: Mean

Interval: 1 minute

Not applicable for PDBs.

5 minutes

instanceNumber

instanceName

hostName

Sessions Sessions count

The number of sessions in the database.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

TransactionsByStatus Transactions By Status transactions per second

The number of committed or rolled back transactions per second.

Statistic: Mean

Interval: 1 minute

5 minutes

instanceNumber

instanceName

hostName

transactionStatus (Committed, RolledBack)

UnusableIndexes Unusable Indexes count

The number of unusable indexes in the database schema.

Statistic: Max

Interval: 24 hours

Not applicable for CDBs.

24 hours schemaName
UsableFRA Usable Fast Recovery Area percent

The usable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for PDBs.

15 minutes NA
UsedFRASpace Flash Recovery Area Usage GB

The flash recovery area space usage.

Statistic: Max

Interval: 15 minutes

Not applicable for PDBs.

15 minutes NA
WaitTime Wait Time seconds per second

The average rate of accumulation of non-idle wait time by foreground sessions in the database instance over the time interval. The wait time component of Average Active Sessions.

Statistic: Mean

Interval: 5 minutes

5 minutes

instanceNumber

instanceName

hostName

waitClass