Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Performance Tuning Guide

- Previous: Thread Pool Settings
- Next: Tuning JDBC Connection Pools

### Monitoring JDBC Connection Pools

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.* *

- Previous: Thread Pool Settings
- Next: Tuning JDBC Connection Pools

- © 2010, Oracle Corporation and/or its affiliates