External Database Metrics
You can monitor the health, capacity, and performance of your External
Databases by using metrics, alarms, and notifications. This section describes the metrics
emitted by Database Management in the
oracle_oci_database
namespace for External Databases.
The metrics for External 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.
Dimensions
The metrics for External 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. The deployment type is
onprem .

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.
Metrics in the oracle_oci_database Namespace
The metrics listed in the following table are available for External Databases.
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 consistentread (CR) block receive time. Statistic: Mean Interval: 5 minutes For RAC CDBs and RAC nonCDBs 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 
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 
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 
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 
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 
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 
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 nonCDBs 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 nonCDBs 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 nonCDBs 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 in MB. Statistic: Mean Interval: 15 minutes 
15 minutes 
instanceNumber instanceName hostName memoryType (SGA, PGA) memoryPool (AllocatedPGA, BufferCache, FixedSGA, JavaPool, LargePool, LogBuffer, OtherPools, SharedPool, StreamsPool) 
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 
NonReclaimableFRA 
Non Reclaimable Fast Recovery Area  percent 
The nonreclaimable fast recovery area. Statistic: Mean Interval: 15 minutes Not applicable for PDBs. 
15 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 
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 
StorageAllocated 
Allocated Storage Space  GB 
The maximum amount of space allocated by tablespace during the interval. For CDBs, this metric provides data for root container tablespaces. Statistic: Max Interval: 30 minutes 
30 minutes  NA 
StorageAllocatedByTablespace 
Allocated Storage Space By Tablespace  GB 
The maximum amount of space allocated by tablespace during the interval. For CDBs, this metric provides data for 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 maximum amount of space used by tablespace during the interval. For CDBs, 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  NA 
StorageUtilizationByTablespace 
Storage Space Utilization By Tablespace  percent 
The percentage of the space utilized, by tablespace. For CDBs, 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 
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 
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 
WaitTime 
Wait Time  seconds per second 
The average rate of accumulation of nonidle 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 