Metrics for Exadata Cloud Infrastructure in the Database Management Service

Database Management provides comprehensive database performance diagnostics and management capabilities for Oracle Databases.

This article describes the metrics emitted by the Exadata Cloud Infrastructure Database service in the oracle_oci_database namespace for Oracle Databases.

To use database metrics for these Oracle Databases in Exadata Cloud Infrastructure Database Service, you must enable Database Management for the database you want to monitor. You can enable either Basic Management or Full Management for your database. See Enable Database Management for instructions.

Dimensions

All the metrics discussed in this topic include the following dimensions.

  • RESOURCEID - The OCID of the database.
  • RESOURCENAME - The name of the database.
  • DEPLOYMENTTYPE - The deployment type of the database.

Note: Valid alarm intervals are 5 minutes or greater due to the frequency at which these metrics are emitted. See To create an alarm for details on creating alarms.

The database metrics can be provided for the basic and full Database Management options.

The metrics listed in the following table are automatically available for Oracle Databases when the Basic Database Management option is enabled.

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

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 N/A
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 maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes N/A
StorageAllocatedByTablespace Allocated Storage Space By Tablespace GB

The maximum amount of space allocated by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

StorageUsed Storage Space Used GB

The maximum amount of space used during the interval.

Statistic: Max

Interval: 30 minutes

30 minutes N/A
StorageUsedByTablespace Storage Space Used By Tablespace GB

The maximum amount of space used by tablespace during the interval. For container databases, this metric provides data for root container tablespaces.

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 N/A
StorageUtilizationByTablespace Storage Space Utilization By Tablespace percent

The percentage of the space utilized, by tablespace. For container databases, this metric provides data for 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

The metrics listed in the following table are automatically available for Oracle Databases when the Full Database Management option is enabled.

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 tablespace, out of all allocated. For container databases, 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 CR (consistent-read) block receive time.

Statistic: Mean

Interval: 5 minutes

For RAC / cluster databases only.

5 minutes

instanceNumber

instanceName

hostName

BlockingSessions Blocking Sessions count

Current blocking sessions.

Statistic: Max

Interval: 15 minutes

Not applicable for container databases.

15 minutes N/A
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 ?? ??

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

??

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 pluggable databases.

15 minutes N/A
FRAUtilization Flash Recovery Area Utilization percent

The flash recovery area utilization.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
GCCRBlocksReceived GC CR Blocks Received blocks per second

The global cache CR (consistent-read) blocks received per second.

Statistic: Mean

Interval: 5 minutes

For RAC / cluster databases only.

5 minutes

instanceNumber

instanceName

hostName

GCCurrentBlocksReceived GC Current Blocks Received blocks per second

Represents global cache current blocks received per second. Statistic reports the mean value.

Statistic: Mean

Interval: 5 minutes

For Real Application Cluster (RAC) databases 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 / cluster databases only.

5 minutes

instanceNumber

instanceName

hostName

InvalidObjects Invalid Objects count

Invalid database objects count.

Statistic: Max

Interval: 24 hours

Not applicable for container databases.

24 hours N/A
IOPS IOPS operations per second

The average number of input-output 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 container databases, this metric provides data for root container tablespaces.

Statistic: Max

Interval: 30 minutes

30 minutes

tablespaceName

tablespaceType

MemoryUsage Memory Usage MB

Memory pool total size in MB.

Statistic: Mean

Interval: 15 minutes

15 minutes

instanceNumber

instanceName

hostName

memoryType (SGA, PGA)

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

MonitoringStatus Monitoring Status not applicable

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

Statistic: Mean

Interval: 5 minutes

5 minutes

collectionName

errorSeverity

errorCode

NonReclaimableFRA Non Reclaimable Fast Recovery Area percent

The Non-reclaimable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
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 problematic scheduled database jobs count.

Statistic: Max

Interval: 15 minutes

Not applicable for container databases.

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

The database processes count.

Statistic: Max

Interval: 1 minute

Not applicable for pluggable databases.

5 minutes

instanceNumber

instanceName

hostName

ProcessLimitUtilization Process Limit Utilization percent

The process limit utilization.

Statistic: Mean

Interval: 1 minute

Not applicable for pluggable databases.

5 minutes

instanceNumber

instanceName

hostName

ReclaimableFRA Reclaimable Fast Recovery Area percent

The reclaimable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
ReclaimableFRASpace Flash Recovery Area Reclaimable Space GB

The flash recovery area reclaimable space.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
RedoSize Redo Generated MB per second

The average amount of redo generated, in MB per second.

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 pluggable databases.

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

Unusable indexes count in database schema.

Statistic: Max

Interval: 24 hours

Not applicable for container databases.

24 hours schemaName
UsableFRA Usable Fast Recovery Area percent

The useable fast recovery area.

Statistic: Mean

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
UsedFRASpace Flash Recovery Area Usage GB

The flash recovery area space usage.

Statistic: Max

Interval: 15 minutes

Not applicable for pluggable databases.

15 minutes N/A
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