Oracle NoSQL

Table 1-380 Supported Configuration Metrics for Oracle NoSQL Database

Metric Group Name Unit Description
Storage Node Configuration Storage Node N/A Storage Node
Storage Node Configuration Storage Node Identifier N/A Storage Node Identifier
Storage Node Configuration Storage capacity N/A Capacity to run multiple replication nodes
Storage Node Configuration Allocated CPUs N/A CPU allocated to the storage node
Store Configuration Total Capacity N/A Total capacity of replication nodes in the store
Store Configuration Storage Nodes N/A Total number of storage nodes in the store
Store Configuration Total Partitions N/A Total partitions of the store
Resource Allocation Total CPUs N/A Total number of CPUs allocated or available to the entity
Resource Allocation Total Memory GB Total amount of usable Physical RAM allocated or available to the entity

Table 1-381 Supported Status and Performance Metrics for Oracle NoSQL database

Metric Group Category Name Unit Description
omc_nosqlNodeCPU Load Storage Node N/A Storage Node
omc_nosqlNodeCPU Load Storage Node Identifier N/A Storage Node Identifier
omc_nosqlNodeCPU Load CPU Load N/A CPU Load for the storage node
omc_nosqlNodeCPU Utilization CPU Usage sec All CPUs usage during the interval by the storage node
omc_nosqlNodeCPU Utilization CPU Utilization % Percentage of CPU that was utilized by the storage node
omc_nosqlNodeMemory Utilization Storage Node N/A Storage Node
omc_nosqlNodeMemory Utilization Storage Node Identifier N/A Storage Node Identifier
omc_nosqlNodeMemory Capacity Heap Memory Allocated GB Amount of heap memory allocated for the storage node
omc_nosqlNodeMemory Capacity Non-heap Memory Allocated GB Amount of non-heap memory allocated for the storage node
omc_nosqlNodeMemory Utilization Heap Memory Used GB Amount of heap memory used by the storage node
omc_nosqlNodeMemory Utilization Non-heap Memory Used GB Amount of non-heap memory used by the storage node
Storage Nodes Status Availability Storage Node N/A Storage Node
Storage Nodes Status Availability Storage Node Id N/A Storage Node Identifier
Storage Nodes Status Availability Storage Node Status N/A Storage Node status
Replication Nodes Performance Response Storage Node N/A Storage Node
Replication Nodes Performance Response Replication Node N/A Replication Node
Replication Nodes Performance Response Replication Node Latency ms Latency in replication node
Replication Nodes Performance Response Replication Node commit lag ms Average commit lag for update operations in the replication node
Replication Nodes Performance Load Singleton Throughput ops/sec Singleton operations per second in the replication node
Replication Nodes Performance Load Multi-operations Throughput ops/sec Multi-operations sequences per second in the replication node
Replication Nodes Performance Load Replication Node Requests reqs/sec Requests per second in the replication node
Store Performance Response Latency ms Average Latency of the store
Store Performance Load Requests Rate reqs/sec Number of requests per second in the store
Store Performance Load Operations Rate ops/sec Number of requests per second in the store
CPU Utilization CPU Usage sec All CPUs usage during the interval
CPU Utilization CPU Utilization % Percentage of CPU that was utilized
CPU N/A Interval sec Interval of metric collection
Memory Load Memory Usage GB Memory used in GB
Memory Utilization Memory Utilization % Percentage of memory that is utilized
Memory N/A Interval sec Interval of metric collection

Table 1-382 Supported Status and Performance Metrics for Relational Database

Metric Group Category Name Unit Description
Storage Space Usage Capacity Storage Space Allocated GB Storage space allocated in GB
Storage Space Usage Utilization Storage Space Utilization % Percent of storage space utilized
Storage Space Usage Load Space Used GB Storage space used in GB
Load Load Logons N/A The number of logons during the last collection interval
Load N/A Logons Rate logons/sec Number of logons per second during the last collection interval
Load N/A Transactions N/A Number of transactions during the last collection interval
Load N/A Transaction Rate txns/sec Number of transactions per second during the last collection interval
Load N/A Executions N/A Number of executions during the last collection interval
Load N/A Executions Rate executions/sec Number of executions per second during the last collection interval
Load N/A Network I/O bytes Number of bytes sent and received over the network during the last collection interval
Load N/A Network I/O Rate bytes/sec Network I/O in bytes per second during the last collection interval
Top SQL Executions Load SQL ID N/A Unique identifier for the SQL statement
Top SQL Executions N/A Top SQL Text N/A SQL text of the top-ranked SQL queries
Top SQL Executions Response Executions Count N/A Execution Count of the top-ranked SQL queries
Top SQL Executions N/A Total Elapsed Time ms Total time used to execute the SQL statement. This includes CPU time and wait time
I/O Per Second Load I/O Per Second IOPS I/O per second
I/O Per Second N/A I/O Bandwidth Usage MB/sec I/O bandwidth usage during the last collection interval
Instance CPU Configuration Instance Name N/A RDB Instance
Instance CPU N/A Host Name N/A Host name of the instance
Instance CPU Utilization CPU Usage sec All CPUs usage during the interval for this instance
Instance CPU N/A CPU Utilization % Percentage of CPU that was utilized in this instance
Instance CPU N/A Interval sec Interval of metric collection
Instance Memory Usage Configuration Instance Name N/A RDB instance
Instance Memory Usage N/A Host Name N/A Host name of the instance
Instance Memory Usage Load Instance Memory Usage GB Memory used in GB
Instance Memory Usage Utilization Memory Utilization % Percentage of memory that is utilized in this instance
Instance Memory Usage N/A Interval sec Interval of metric collection
I/O Per Second Instance Level Configuration Instance Name N/A RDB instance
I/O Per Second Instance Level N/A Host Name N/A Host name of the instance
I/O Per Second Instance Level Load I/O Per Second IOPS I/O per second for this instance
I/O Per Second Instance Level N/A I/O bandwidth usage during the last collection interval for this instance MB/sec I/O bandwidth usage during the last collection interval for this instance

Table 1-383 Supported Status and Performance Metrics for Hosted Target

Metric Group Category Name Unit Description
CPU Utilization CPU Usage sec All CPUs usage during the interval
CPU N/A CPU Utilization % Percentage of CPU that was utilized
CPU N/A Interval sec Interval of metric collection
Memory Load Memory Usage GB Memory used in GB
Memory Utilization Memory Utilization % Percentage of memory that is utilized
Memory N/A Interval sec Interval of metric collection

Table 1-384 Status and Performance Metrics for Generic Target

Metric Group Category Name Unit Description
Response Availability Status N/A Status of the target