beautypg.com

Table 18–10, Jdbc connection pool statistics – Sun Microsystems GLASSFISH ENTERPRISE 820433510 User Manual

Page 183

background image

The statistics available for the JDBC connection pool are shown in the following table.

TABLE 18–10

JDBC Connection Pool Statistics

Statistic

Units

Data Type

Description

numconnfailedvalidation

Number

CountStatistic

The total number of connections
in the connection pool that failed
validation from the start time
until the last sample time.

numconnused

Number

RangeStatistic

Provides connection usage
statistics. The total number of
connections that are currently
being used, as well as information
about the maximum number of
connections that were used (the
high water mark).

numconnfree

Number

CountStatistic

The total number of free
connections in the pool as of the
last sampling.

numconntimedout

Number

BoundedRangeStatistic

The total number of connections
in the pool that timed out
between the start time and the last
sample time.

averageconnwaittime

Number

CountStatistic

Indicates the average wait time of
connections for successful
connection request attempts to
the connector connection pool.

waitqueuelength

Number

CountStatistic

Number of connection requests
in the queue waiting to be
serviced.

connectionrequestwaittime

RangeStatistic

The longest and shortest wait
times of connection requests. The
current value indicates the wait
time of the last request that was
serviced by the pool.

numconncreated

Milliseconds

CountStatistic

The number of physical
connections that were created
since the last reset.

numconndestroyed

Number

CountStatistic

Number of physical connections
that were destroyed since the last
reset.

About Monitoring

Chapter 18 • Monitoring Components and Services

183