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

Not applicable for PDBs.

5 minutes

dbRole

primaryDbid

primaryDbUniqueName

ApplyLagDataRefreshElapsedTime Apply Lag Data Refresh Elapsed Time seconds

The elapsed time since the ApplyLag metric sample was last collected.

Statistic: Mean

Interval: 5 minutes

Resource group: oracle_dataguard

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

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

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

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

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

Not applicable for PDBs.

5 minutes

dbRole

primaryDbid

primaryDbUniqueName

TransportLagDataRefreshElapsedTime Transport Lag Data Refresh Elapsed Time seconds

The elapsed time since the TransportLagDataRefreshElapsedTime metric sample was last collected.

Statistic: Mean

Interval: 5 minutes

Resource group: oracle_dataguard

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