The statistics available for the JDBC connection pool are shown in the following table.
TABLE18–10 JDBC Connection PoolStatistics
Statistic Units DataType Description
numconnfailedvalidation Number CountStatistic The total numberof connections
in the connectionpool that failed
validation from thestart time
until the lastsample time.
numconnused Number RangeStatistic Provides connection usage
statistics. The totalnumber of
connections that arecurrently
being used, aswell as information
about the maximumnumber of
connections that wereused (the
high water mark).
numconnfree Number CountStatistic Thetotal number offree
connections in thepool as of the
last sampling.
numconntimedout Number BoundedRangeStatistic The totalnumber of connections
in the poolthat timed out
between the starttime and the last
sample time.
averageconnwaittime Number CountStatistic Indicates the average waittime of
connections for successful
connection request attemptsto
the connector connectionpool.
waitqueuelength Number CountStatistic Number ofconnection requests
in the queuewaiting to be
serviced.
connectionrequestwaittime RangeStatistic The longest andshortest wait
times of connectionrequests. The
current value indicatesthe wait
time of thelast request that was
serviced by thepool.
numconncreated Milliseconds CountStatistic The number of physical
connections that werecreated
since the lastreset.
numconndestroyed Number CountStatistic Numberof physical connections
that were destroyedsince the last
reset.
AboutMonitoring
Chapter18 • MonitoringComponents andServices 183