Applications Manager provides out-of-the-box performance metrics and helps you visualize the health and availability of an Oracle NoSQL server farm. Database administrators can login to the web client and visualize the status and Oracle NoSQL performance metrics.
Supported Versions: Oracle Nosql 12.1.2 and above.
Applications Manager uses Java Management Extensions (JMX) to monitor Oracle NoSQL database servers. Before adding a monitor, ensure the following:
Using the REST API to add a new Oracle NoSQL monitor: Click here
Follow the given steps to create a Oracle NoSQL server monitor:
Applications Manager monitors Oracle NoSQL based on the performance attributes listed below. These metrics provide deep visibility into the health and operational status of your database components. You can also configure thresholds for attributes to receive alerts when performance limits are exceeded.
Following are the list of tabs that are shown in Oracle NoSQL monitor:
The Overview section displays the availability and performance history for the past 6 hours. It also provides detailed information on Admin instances, memory and thread utilization metrics.
| Parameter | Description |
|---|---|
| ADMIN ATTRIBUTES | |
| Admin ID | Number of an Admin instance. |
| Http Port | The port number used by the Admin Console web application. |
| Log File Count | Number of log files that are kept. |
| Log File Limit | The maximum size of log files. |
| Master | Whether this Admin is the master among Admin instances. |
| Available Storage Node | The amount of memory known to be available on this Storage Node, in megabytes. |
| MEMORY DETAILS | |
| Free Physical | The amount of free physical memory (in Gigabytes). |
| Free Swap Space | The free virtual memory size (in Gigabytes). |
| Total Physical | The total amount of physical memory (in Gigabytes). |
| Total Swap Space | The total size of virtual memory held by the JVM (in Gigabytes). |
| Committed Virtual | The amount of virtual memory that is guaranteed to be available to the running process (in Gigabytes). |
| THREAD DETAILS | |
| Daemon Thread | The number of daemon threads currently running. |
| Peak Thread | The peak live thread count since the Java virtual machine started or peak was reset. |
| Live Thread | The number of live threads currently running. |
| Total Threads Started | The total number of threads created and also started since the Java virtual machine started. |
| Parameter | Description |
|---|---|
| NODE GENERAL DETAILS | |
| Replicated Node Id | The RepNodeId, in its String form |
| Replication State | Represents the status of a node in the replication group |
| Size of Cache(MB) | The size of the BDB-JE cache (in Mega Bytes). |
| Commit Lag | Average commit lag(in milliseconds) for a given replication node's update operations during a given time interval. |
| Commit Lag Threshold | Average commit lag (in milliseconds) for a given replication node during a given time interval exceeds the value returned by this method, a notification event will be sent to any parties that have registered interest. |
| Heap Memory(MB) | The size of the Java heap for this Replication Node (in Mega Bytes). |
| Collect Environment Status | If true, then the underlying BDB-JE subsystem will dump statistics into a local .stat file. |
| Service Status | Displays the operational state of services like Admin, Storage Nodes, and Replication Nodes. |
| Mount Point | Indicates the file system location where the storage node data directory is mounted. |
| NODE INTERVAL DETAILS | |
| Replicated Node Id | The RepNodeId, in its String form. |
| Interval Start Time | The beginning timestamp of a performance monitoring interval for database metrics. |
| Interval Average Latency / Min | Average latency of database operations during the interval. |
| Interval Maximum Latency / Min | Maximum observed latency of database operations during the interval. |
| Interval Throughput / Min | The number of database operations processed per minute in the interval. |
| Interval Total Outputs / Min | Total number of successful outputs |
| NODE INTERVAL DETAILS | |
| Replicated Node Id | The RepNodeId, in its String form. |
| Interval Start Time | The beginning timestamp of a performance monitoring interval for database metrics. |
| MultiInterval Average Latency / Min | Average latency of database operations over multiple intervals. |
| MultiInterval Maximum Latency / Min | The highest latency recorded across multiple intervals |
| MultiInterval Throughput / Min | Aggregated throughput of database operations across multiple intervals. |
| MultiInterval Total Outputs / Min | Total outputs generated across multiple intervals. |
| Parameter | Description |
|---|---|
| STORAGE DETAILS | |
| Number of Replicated Nodes | The number of Replication Nodes that can be hosted on this Storage Node. |
| Number of CPUs | The number of CPUs known to be available on this Storage Node. |
| Registry Port | The port number of the Storage Node's RMI registry. |
| Storage Node ID | The StorageNodeId number of this Storage Node. |
| HA Host Name | The name of the network interface used for communication between Replication Nodes. |
| HA Port Range | The range of port numbers available for assigning to Replication Nodes that are hosted on this Storage Node. |
| Host Admin | True if this Storage Node hosts an Admin instance. |
| Root Directory Path | The pathname of the store's root directory. |
| Store Name | The configured name of the store to which this Storage Node belongs. |
| Boot Class Path | Represents the class path used by the JVM for bootstrap classes during startup. |
| Class Path | Specifies the class path where user-defined and application-specific classes are loaded. |
| Spec Vendor | Indicates the vendor or organization that implemented the JVM specification. |
| Spec Version | Denotes the version of the JVM specification being used. |
| VM Name | The name of the Java Virtual Machine implementation. |
| VM Vendor | The vendor or provider of the JVM implementation. |
Thank you for your feedback!
