users@glassfish.java.net

Re: Connection Pool Configurations and Monitoring Results

From: <glassfish_at_javadesktop.org>
Date: Wed, 12 Aug 2009 04:57:36 PDT

I think I'm going to be able to answer my last doubt as well. Looking at how this numbers are derived it got me thinking that this has to be some incremement figure on a total (without taking the cleaned connections to consideration). So I figured that that the 'NumConnDestroyed' should be taken into calculation on the actual number of connections on the pool. In my case it was 7. Which meant my current available connections should be 35 - 7 = 28. And consulting the sessions on oracle. It gave the exact number. I did few other sampling with other pools and this seemed to be what I should be looking for.

So If one wants to see from the GlassFish monitoring tool as to how many connections are consumed at a given time from a pool, they should derive it by (NumConnCreated - NumConnDestroyed).

That's my doubt clarified (unless someone else thinks otherwise). Hope this might help someone else. If not ignore me.

Cheers
-- Imran
[Message sent by forum member 'imranbohoran' (imranbohoran)]

http://forums.java.net/jive/thread.jspa?messageID=360076