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 Oracle Database cloud solutions:
- Base Database Service
- Exadata Database Service on Dedicated Infrastructure (ExaDB-D)
- Exadata Database Service on Cloud@Customer (ExaDB-C@C)
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.
Certain key metrics are available for the Base Database Service, ExaDB-D, and ExaDB-C@C without enabling Database Management. These metrics are emitted in the
oci_database
and oci_database_cluster
namespaces by the Database service, and you can use them to monitor Oracle Databases
and Exadata VM clusters. Irrespective of whether Database Management is enabled or not, the metrics displayed on the Base Database
Service, ExaDB-D, and ExaDB-C@C pages are emitted by the Database service. For
information on the metrics and dimensions related to the
oci_database
and oci_database_cluster
namespaces, see:
- Available Metrics for Base Database Service Resources
- Metrics for Oracle Exadata Database Service on Dedicated Infrastructure in the Monitoring Service
- Metrics for Exadata Database Service on Cloud@Customer 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. |
resourceType |
The type of database, for example,
NON_CDB .
|
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 |
ApplyLag |
Apply Lag | seconds |
The number of seconds the standby database is behind the primary database. Statistic: Mean Interval: 5 minutes Resource group: Not applicable for PDBs. |
5 minutes |
dbRole primaryDbid primaryDbUniqueName |
ApplyLagDataRefreshElapsedTime |
Apply Lag Data Refresh Elapsed Time | seconds |
The elapsed time since the Statistic: Mean Interval: 5 minutes Resource group: Not applicable for PDBs. |
5 minutes |
dbRole primaryDbid primaryDbUniqueName |
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 |
BackupDuration |
Backup Duration | seconds |
The duration of the last database backup. Statistic: Mean Interval: 30 minutes Only applicable for SI and RAC CDBs. |
30 minutes |
status backupType deviceType |
BackupSize |
Backup Size | GB |
The size of the last database backup. Statistic: Mean Interval: 30 minutes Only applicable for SI and RAC CDBs. |
30 minutes |
status backupType deviceType |
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 |
EstimatedFailoverTime |
Estimated Failover Time | seconds |
The number of seconds required to fail over to the standby database. Statistic: Mean Interval: 5 minutes Resource group: Not applicable for PDBs. |
5 minutes |
dbRole primaryDbid primaryDbUniqueName |
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 |
RecoveryWindow |
Recovery Window | seconds |
The current recovery window of a database. Statistic: Mean Interval: 15 minutes Only applicable for SI and RAC CDBs version 19c and later. |
15 minutes |
deviceType |
RedoApplyRate |
Redo Apply Rate | MB per second |
The redo apply rate on the standby database. Statistic: Mean Interval: 5 minutes Resource group: Not applicable for PDBs. |
5 minutes |
dbRole primaryDbid primaryDbUniqueName |
RedoGenerationRate |
Redo Generation Rate | MB per second |
The redo generation rate on the primary database. Statistic: Mean Interval: 5 minutes Resource group: Not applicable for PDBs. |
5 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) |
TransportLag |
Transport Lag | seconds |
The number of seconds of redo not yet available on the standby database. Statistic: Mean Interval: 5 minutes Resource group: Not applicable for PDBs. |
5 minutes |
dbRole primaryDbid primaryDbUniqueName |
TransportLagDataRefreshElapsedTime |
Transport Lag Data Refresh Elapsed Time | seconds |
The elapsed time since the Statistic: Mean Interval: 5 minutes Resource group: Not applicable for PDBs. |
5 minutes |
dbRole primaryDbid primaryDbUniqueName |
UnprotectedDataWindow |
Unprotected Data Window | seconds |
The current unprotected data window of a database. Statistic: Mean Interval: 15 minutes Only applicable for SI and RAC CDBs version 19c and later. |
15 minutes |
deviceType |
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 |