Performance Monitoring Infrastructure (PMI) collects performance data for 4.0 and 5.0 Java Database Connectivity (JDBC) data sources. For a 4.0 data source, the data source name is used. For a 5.0 data source, the Java Naming and Directory Interface (JNDI) name is used.
The JDBC connection pool counters are used to monitor the performance of JDBC data sources.
Name | Key | ID | Description | Granularity | Type | Level | Overhead |
CreateCount | connectionPoolModule.numCreates | 1 | The total number of connections created | Per connection pool | CountStatistic | All | Low |
CloseCount | connectionPoolModule.numDestroys | 2 | The total number of connections closed. | Per connection pool | CountStatistic | All | Low |
AllocateCount | connectionPoolModule.numAllocates | 3 | The total number of connections allocated | Per connection pool | CountStatistic | All | Low |
ReturnCount | connectionPoolModule.numReturns | 4 | The total number of connections returned | Per connection pool | CountStatistic | All | Low |
PoolSize | connectionPoolModule.poolSize | 5 | The size of the connection pool | Per connection pool | BoundedRangeStatistic | All | High |
FreePoolSize | connectionPoolModule.freePoolSize | 6 | The number of free connections in the pool (apply to 5.0 DataSource only) | Per connection pool | BoundedRangeStatistic | Basic | High |
WaitingThreadCount | connectionPoolModule.concurrentWaiters | 7 | The number of threads that are currently waiting for a connection | Per connection pool | RangeStatistic | All | High |
FaultCount | connectionPoolModule.faults | 8 | The total number of faults, such as timeouts, in the connection pool | Per connection pool | CountStatistic | All | Low |
PercentUsed | connectionPoolModule.percentUsed | 9 | The average percent of the pool that is in use | Per connection pool | RangeStatistic | Basic | High |
PercentMaxed | connectionPoolModule.percentMaxed | 10 | The average percent of the time that all connections are in use | Per connection pool | RangeStatistic | All | High |
UseTime | connectionPoolModule.avgUseTime | 12 | The average time, in milliseconds, that a connection is used (applies to 5.0 DataSource only). Difference between the time at which the connection is allocated and returned. This value includes the JDBC operation time. | Per connection pool | TimeStatistic | All | Medium |
WaitTime | connectionPoolModule.avgWaitTime | 13 | The average waiting time in milliseconds until a connection is granted | Per connection pool | TimeStatistic | All | Medium |
ManagedConnectionCount | connectionPoolModule.numManagedConnections | 14 | The number of ManagedConnection objects in use for a particular connection pool (applies to V5.0 DataSource objects only) | Per connection factory | CountStatistic | All | Low |
ConnectionHandleCount | connectionPoolModule.numConnectionHandles | 15 | The number of Connection objects in use for a particular connection pool (applies to 5.0 DataSource only) | Per connection factory | CountStatistic | All | Low |
PrepStmtCacheDiscardCount | connectionPoolModule.prepStmtCacheDiscards | 21 | The total number of statements discarded by the least recently used (LRU) algorithm of the statement cache | Per connection pool | CountStatistic | All | Low |
JDBCTime | connectionPoolModule.jdbcOperationTimer | 22 | The amount of time in milliseconds spent running in the JDBC driver, which includes time spent in the JDBC driver, network, and database (applies to 5.0 DataSource only). | Per data source | TimeStatistic | All | Medium |