Skip to Main Content

NoSQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to monitor Oracle NOSQL Database via jmx

3504709Feb 26 2020 — edited Apr 17 2020

Hi all,

I'm facing a problem on monitoring my nosql via the jmx interface.

The problem is that the jmx is active, and I can connect to the jmx interface but I can't see the "Oracle NOSQL Database" section in MBeans tab (look at the screenshot):

pastedImage_2.png

We've configured the jmx with this command "plan change-parameters -service <service> -wait -params mgmtClass=oracle.kv.impl.mgmt.jmx.JmxAgent".

More details about the environment:

- OS: Oracle linux 7.7

- Nosql version: 18.1.19

Can someone help me on this?

Thank you.

Marcantonio

Comments

Prabodh
Answer
Hi Jan,
I'm wondering what exactly is apex.jdbc.MaxStatementsLimit parameter for and if/how the value should be adjusted.
Documentation says only: Specify the maximum number of statements to cache for each connection. Default = 10>

These are JDBC parameters detailed here http://docs.oracle.com/cd/B19306_01/java.102/b14355/concache.htm#CDEBCBJC

You may change the Max numbers to higher values, but do not reduce them. These have a impact on the memory used, and may not necessarily result in improved performance. You may need to find the right set with some trial and error.

Cheers,
Marked as Answer by jan.navratil · Sep 27 2020
1 - 1

Post Details

Added on Feb 26 2020
25 comments
875 views