Technical data

5 Monitoring a WebLogic Server Domain
5-4 Administration Guide
Monitoring JDBC Connection Pools
Java Database Connectivity (JDBC) subsystem resources can also be monitored via
the Administration Console. The Monitoring tab for a JDBC connection pool allows
you to access a table listing statistics for the instances of that pool. As with other entity
tables in the Administration Console, you can customize the table to select which
attributes you want to be displayed.
A number of these attributes provide important information for managing client
database access.
The Waiters High field indicates the highest number of clients waiting for a connection
at one time. The Waiters field tells you how many clients are currently waiting for a
connection. The Connections High field indicates the highest number of connections
that have occurred at one time. The Wait Seconds High field tells you the longest
duration a client has had to wait for a database connection. These attributes allow you
to gauge the effectiveness of the current configuration is in responding to client
requests.
If the Connections High field value is close to the value of the Maximum Capacity field
(set on the Configuration Connections tab), you might consider increasing the value of
Maximum Capacity (the maximum number of concurrent connections). If the value in
the Waiters High field indicates that clients are subject to a long wait for database
access, then you might want to increase the size of the pool.
The value in the Shrink Period field is the length of time the JDBC subsystem waits
before shrinking the pool from the maximum. When the subsystem shrinks the pool,
database connections are destroyed. Creating a database connection consumes
resources and can be time-consuming. If your system has intermittent bursts of client
requests, a short shrink period might mean that database connections are being
recreated continually, which may degrade performance.