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: MeanInterval: 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 |