About Monitoring
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. |
|
|
|
|
Chapter 18 • Monitoring Components and Services | 183 |