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. |
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.
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 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 |
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 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 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 |
MonitoringUserPasswordExpiration |
Monitoring User Password Expiration | count |
The number of days left before the monitoring user password expires. Statistic: Last Interval: 24 hours |
24 hours |
isPerpetual |
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 |
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 |
RetentionPeriod |
Retention Period | count |
The number of days for which database backups are retained. Statistic: Mean Interval: 15 minutes Only applicable for SI and RAC CDBs. |
15 minutes | NA |
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 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 |