Metrics in the oracle_oci_database_cluster Namespace
You can monitor the health, capacity, and performance of your
External Database System components by using metrics, alarms, and notifications. The
topics in this section describe the metrics emitted by Database Management in the oracle_oci_database_cluster
namespace for the components in an External Database System.
The metrics for the External Database System components help identify and resolve any operational issue before it impacts database performance.
Valid alarm intervals for the metrics 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.
Dimensions
The metrics for the External Database System components include the following common dimensions.
| Dimension | Description |
|---|---|
resourceId |
The OCID of the component. |
resourceName |
The name of the component. |
dbSystemId |
The OCID of the External Database System. |
deploymentType |
The deployment type of the
associated database. The deployment type is
onprem.
|
Metrics for the oracle_asm Resource
The following metrics monitor the health, capacity, and performance of the ASM instances in the External Database System.
| Metric Name | Metric Display Name | Unit | Description and Metric Chart Defaults | Collection Frequency | Dimensions |
|---|---|---|---|---|---|
DatabaseAllocatedSpace |
Database Allocated Space | MB |
The allocated space in a disk group for a database. Statistic: Mean Interval: 30 minutes |
30 minutes |
databaseName diskGroupName |
DiskFreeSpace |
Disk Free Space | GB |
The free space in a disk. Statistic: Mean Interval: 30 minutes |
30 minutes |
diskGroupName diskName |
DiskGroupFreeSpace |
Disk Group Free Space | GB |
The free space in a disk group. Statistic: Mean Interval: 30 minutes |
30 minutes | diskGroupName |
DiskGroupTotalSpace |
Disk Group Total Space | GB |
The total space in a disk group. Statistic: Mean Interval: 30 minutes |
30 minutes | diskGroupName |
DiskGroupUsableFreeSpace |
Disk Group Usable Free Space | GB |
The usable free space in a disk group. Statistic: Mean Interval: 30 minutes |
30 minutes | diskGroupName |
DiskGroupUsableTotalSpace |
Disk Group Usable Total Space | GB |
The total usable space in a disk group, subject to redundancy. Statistic: Mean Interval: 30 minutes |
30 minutes | diskGroupName |
DiskGroupUsableUtilization |
Usable Disk Group Utilization | percent |
The percentage of usable space used in a disk group. Statistic: Mean Interval: 30 minutes |
30 minutes | diskGroupName |
DiskGroupUtilization |
Disk Group Utilization | percent |
The percentage of space used in a disk group. Statistic: Mean Interval: 30 minutes |
30 minutes | diskGroupName |
DiskTotalSpace |
Disk Total Space | GB |
The total space in a disk. Statistic: Mean Interval: 30 minutes |
30 minutes |
diskGroupName diskName |
DiskUtilization |
Disk Utilization | percent |
The percentage of space used in a disk. Statistic: Mean Interval: 30 minutes |
30 minutes |
diskGroupName diskName |
IOPS |
IOPS | operations per second |
The total number of IO operations processed per second by a disk group for a database. Statistic: Mean Interval: 5 minutes |
5 minutes |
databaseName diskGroupName instanceName |
IOSize |
IO Size | MB per operation |
The average size of an IO operation. Statistic: Mean Interval: 5 minutes |
5 minutes |
databaseName diskGroupName instanceName |
IOThroughput |
IO Throughput | MB per second |
The total IO throughput of a disk group for a database. Statistic: Mean Interval: 5 minutes |
5 minutes |
databaseName diskGroupName instanceName |
MonitoringStatus |
Monitoring Status | NA |
The monitoring status of the ASM. If metric collection fails, error information is captured in this metric. Statistic: Min Interval: 1 minute |
5 minutes |
collectionName errorCode errorSeverity |
ResponseTime |
Response Time | milliseconds per request |
The time taken by a disk group to process an IO request. Statistic: Mean Interval: 5 minutes |
5 minutes |
databaseName diskGroupName instanceName |
Status |
Status | NA |
The status of an ASM instance. Statistic: Min Interval: 1 minute |
1 minute | instanceName |
Metrics for the oracle_cluster Resource
The following metrics monitor the health, capacity, and performance of clusters in the External Database System.
| Metric Name | Metric Display Name | Unit | Description and Metric Chart Defaults | Collection Frequency | Dimensions |
|---|---|---|---|---|---|
ClusterInterconnectErrorRate |
Interconnect Errors | count |
The cluster interconnect error rate. Statistic: Mean Interval: 5 minutes |
5 minutes | agentHostName |
ClusterInterconnectReadRate |
Interconnect Read Rate | MB per second |
The cluster interconnect read rate. Statistic: Mean Interval: 5 minutes |
5 minutes | agentHostName |
ClusterInterconnectWriteRate |
Interconnect Write Rate | MB per second |
The cluster interconnect write rate. Statistic: Mean Interval: 5 minutes |
5 minutes | agentHostName |
MonitoringStatus |
Monitoring Status | NA |
The monitoring status of the cluster or cluster node. If metric collection fails, error information is captured in this metric. Statistic: Min Interval: 1 minute |
5 minutes |
collectionName errorCode errorSeverity |
Status |
Status | NA |
The status of the software processes running as part of a cluster node. Statistic: Min Interval: 1 minute |
1 minute |
agentHostName componentName nodeName |
Metrics for the oracle_db_node Resource
The following metrics monitor the health, capacity, and performance of the database nodes in the External Database System.
| Metric Name | Metric Display Name | Unit | Description and Metric Chart Defaults | Collection Frequency | Dimensions |
|---|---|---|---|---|---|
CpuUsed |
CPU Used | millisecond |
The CPU used in the time interval. Statistic: Mean Interval: 1 minute |
1 minute | agentHostName |
CpuUtilization |
CPU Utilization | percent |
The CPU utilization expressed as a percentage. Statistic: Mean Interval: 1 minute |
1 minute | agentHostName |
DiskReadRate |
Disk Reads | MB per second |
The rate at which data is read from a disk. Statistic: Mean Interval: 1 minute |
1 minute | agentHostName |
DiskWriteRate |
Disk Writes | MB per second |
The rate at which data is sent to a disk. Statistic: Mean Interval: 1 minute |
1 minute | agentHostName |
MemoryUsed |
Memory Used | GB |
The total memory used. Statistic: Mean Interval: 1 minute |
1 minute | agentHostName |
MemoryUtilization |
Memory Utilization | percent |
The percentage of memory utilized. Statistic: Mean Interval: 1 minute |
1 minute | agentHostName |
NetworkReadRate |
Network Reads | MB per second |
The rate at which data is received across a network interface. Statistic: Mean Interval: 1 minute |
1 minute |
agentHostName interfaceName |
NetworkWriteRate |
Network Writes | MB per second |
The rate at which data is sent across a network interface. Statistic: Mean Interval: 1 minute |
1 minute |
agentHostName interfaceName |
StorageUsed |
Storage Used | GB |
The total storage space used. Statistic: Mean Interval: 30 minutes |
30 minutes |
agentHostName fileSystem |
StorageUtilization |
Storage Utilization | percent |
The percentage of storage space utilized. Statistic: Mean Interval: 30 minutes |
30 minutes |
agentHostName fileSystem |
TotalCpu |
Total CPU | count |
The total number of CPUs available. Statistic: Mean Interval: 30 minutes |
30 minutes | agentHostName |
TotalMemory |
Total Memory | GB |
The total amount of memory available. Statistic: Mean Interval: 30 minutes |
30 minutes | agentHostName |
Metrics for the oracle_lsnr Resource
The following metrics monitor the health, capacity, and performance of listeners in the External Database System.
| Metric Name | Metric Display Name | Unit | Description and Metric Chart Defaults | Collection Frequency | Dimensions |
|---|---|---|---|---|---|
ActiveConnections |
Active Connections | count |
The number of active connections at collection time. Statistic: Mean Interval: 5 minutes |
5 minutes | NA |
EstablishedConnections |
Established Connections | connections per minute |
The number of successfully established connections. Statistic: Mean Interval: 5 minutes |
5 minutes | NA |
MaxConnections |
Maximum Connections | count |
The maximum number of connections that the listener can handle. Statistic: Mean Interval: 5 minutes |
5 minutes | NA |
MonitoringStatus |
Monitoring Status | NA |
The monitoring status of the listener. If metric collection fails, error information is captured in this metric. Statistic: Min Interval: 1 minute |
5 minutes |
collectionName errorCode errorSeverity |
RefusedConnections |
Refused Connections | connections per minute |
The number of connections refused by the listener. Statistic: Mean Interval: 5 minutes |
5 minutes | NA |