Statistics-gathering is enabled by default for JDBC Connection Pools. The following attributes are monitored:
numConnFailedValidation (count)Number of connections that failed validation.
numConnUsed (range)Number of connections that have been used.
numConnFree (count)Number of free connections in the pool.
numConnTimedOut (bounded range)Number of connections in the pool that have timed out.
To get the statistics, use these commands:
asadmin get --monitor=true serverInstance.resources.jdbc-connection-pool.*asadmin get --monitor=true serverInstance.resources.jdbc-connection-pool. poolName.* *