Schedule demo

Oracle NoSQL Database Server Monitoring


Overview

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.

Creating a new Oracle NoSQL monitor

Supported Versions: Oracle Nosql 12.1.2 and above.

Prerequisites:

Applications Manager uses Java Management Extensions (JMX) to monitor Oracle NoSQL database servers. Before adding a monitor, ensure the following:

  • Enable JMX Agent: Activate the JMX agent on your database nodes by following the Oracle NoSQL JMX documentation.
  • Network Access: Verify that the JMX Port (Registry Port, 5000 by default) is open and reachable from the server where Applications Manager is installed.
  • User Permissions: If JMX authentication is enabled, Ensure the monitoring user has administrative privileges to access management MBeans.

Using the REST API to add a new Oracle NoSQL monitor:Click here

Follow the given steps to create a Oracle NoSQL server monitor:

  1. Click on New Monitor link.
  2. Select Oracle NoSQL.
  3. Enter the Display Name of the monitor
  4. Enter the IP Address or hostname of the host.
  5. Enter the JMX Port in which the JMX is running.
  6. Enter the Additional JMX Port in which the JMX is already running in any of the other machine of the same cluster.
  7. Choose the Credential Details either use below credentials or select from credential list
  8. Enter the Username and Password of the Oracle NoSQL.
  9. Enter JNDI Path ex. /jmxrmi
  10. Enter the polling interval time in minutes.
  11. Choose the Monitor Group from the combo box with which you want to associate Oracle database server Monitor (optional). You can choose multiple groups to associate your monitor.
  12. Click Add Monitor(s). This discovers Oracle database server from the network and starts monitoring them.

Monitored Parameters

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:

Overview

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.

ParameterDescription
ADMIN ATTRIBUTES
Admin IDNumber of an Admin instance.
Http PortThe port number used by the Admin Console web application.
Log File CountNumber of log files that are kept.
Log File LimitThe maximum size of log files.
MasterWhether this Admin is the master among Admin instances.
Available Storage NodeThe amount of memory known to be available on this Storage Node, in megabytes.
MEMORY DETAILS
Free PhysicalThe amount of free physical memory (in Gigabytes).
Free Swap SpaceThe free virtual memory size (in Gigabytes).
Total PhysicalThe total amount of physical memory (in Gigabytes).
Total Swap SpaceThe total size of virtual memory held by the JVM (in Gigabytes).
Committed VirtualThe amount of virtual memory that is guaranteed to be available to the running process (in Gigabytes).
THREAD DETAILS
Daemon ThreadThe number of daemon threads currently running.
Peak ThreadThe peak live thread count since the Java virtual machine started or peak was reset.
Live ThreadThe number of live threads currently running.
Total Threads StartedThe total number of threads created and also started since the Java virtual machine started.

Replicated Node Details

ParameterDescription
NODE GENERAL DETAILS
Replicated Node IdThe RepNodeId, in its String form
Replication StateRepresents the status of a node in the replication group
Size of Cache(MB)The size of the BDB-JE cache (in Mega Bytes).
Commit LagAverage commit lag(in milliseconds) for a given replication node's update operations during a given time interval.
Commit Lag ThresholdAverage 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 StatusIf true, then the underlying BDB-JE subsystem will dump statistics into a local .stat file.
Service StatusDisplays the operational state of services like Admin, Storage Nodes, and Replication Nodes.
Mount PointIndicates the file system location where the storage node data directory is mounted.
NODE INTERVAL DETAILS
Replicated Node IdThe RepNodeId, in its String form.
Interval Start TimeThe beginning timestamp of a performance monitoring interval for database metrics.
Interval Average Latency / MinAverage latency of database operations during the interval.
Interval Maximum Latency / MinMaximum observed latency of database operations during the interval.
Interval Throughput / MinThe number of database operations processed per minute in the interval.
Interval Total Outputs / MinTotal number of successful outputs
NODE INTERVAL DETAILS
Replicated Node IdThe RepNodeId, in its String form.
Interval Start TimeThe beginning timestamp of a performance monitoring interval for database metrics.
MultiInterval Average Latency / MinAverage latency of database operations over multiple intervals.
MultiInterval Maximum Latency / MinThe highest latency recorded across multiple intervals
MultiInterval Throughput / MinAggregated throughput of database operations across multiple intervals.
MultiInterval Total Outputs / MinTotal outputs generated across multiple intervals.

Configuration

ParameterDescription
STORAGE DETAILS
Number of Replicated NodesThe number of Replication Nodes that can be hosted on this Storage Node.
Number of CPUsThe number of CPUs known to be available on this Storage Node.
Registry PortThe port number of the Storage Node's RMI registry.
Storage Node IDThe StorageNodeId number of this Storage Node.
HA Host NameThe name of the network interface used for communication between Replication Nodes.
HA Port RangeThe range of port numbers available for assigning to Replication Nodes that are hosted on this Storage Node.
Host AdminTrue if this Storage Node hosts an Admin instance.
Root Directory PathThe pathname of the store's root directory.
Store NameThe configured name of the store to which this Storage Node belongs.
Boot Class PathRepresents the class path used by the JVM for bootstrap classes during startup.
Class PathSpecifies the class path where user-defined and application-specific classes are loaded.
Spec VendorIndicates the vendor or organization that implemented the JVM specification.
Spec VersionDenotes the version of the JVM specification being used.
VM NameThe name of the Java Virtual Machine implementation.
VM VendorThe vendor or provider of the JVM implementation.

Loved by customers all over the world

"Standout Tool With Extensive Monitoring Capabilities"

It allows us to track crucial metrics such as response times, resource utilization, error rates, and transaction performance. The real-time monitoring alerts promptly notify us of any issues or anomalies, enabling us to take immediate action.

Reviewer Role: Research and Development

carlos-rivero
"I like Applications Manager because it helps us to detect issues present in our servers and SQL databases."
Carlos Rivero

Tech Support Manager, Lexmark

Trusted by over 6000+ businesses globally