Monitor DB Connections

Hi All,

Is there any Way to Monitor DB Connection Pool usages while JBoss is running with Oracle DB using jmx-console, Can some one explain if this is Possible.

Thanks
Srinivas

Hi Srinivas,

Yes, you can monitor the connection pool usage from the JMX console, following is the JMX console path

jboss.jca -> name=<YOUR_DS_NAME>,service=ManagedConnectionPool

It would show you details like AvailableConnectionCount, ConnectionCreatedCount, InUseConnectionCount etc

Thank you for the Response

We have the Server configured in Cluster mode, Is there any way to access jmx-console

When I tried with <Domain name>/jmx-console it i snot accessible

Thanks
Srinivas

HI Srinivas,

JMX console shows details about only 1 server at a time, however if you have servers running in cluster then you have to open that number of JMX consoles say you have two servers running in a cluster all_node1 running on port 8180 and all_node2 running on port 8280 then the URL for them would be like as follows

all_node1
http://localhost:8180/jmx-console/

all_node2
http://localhost:8280/jmx-console/

However if you need only one console to monitor all the nodes then JON which is JBoss Operations Network would be the best options for you.

Thank You, I will Check this