Smart Plug-in for WebLogic Server Reference Guide

Chapter 1
Metric B061_JDBCConPlWtCnt
1-53
Metric B061_JDBCConPlWtCnt
Monitor Template Name WLSSPI_0061
Metric Name JDBC Connect Pool Wait Count
Metric Type Alarming, Graphing
Description Number of clients waiting for a connection from connection pools.
WebLogic 6.0/6.1 or Both Both
Severity: Condition Warning: WLSSPI-0061.1, threshold, 10
Collection Interval 5m
Message Group WebLogic
Message Text WLSSPI-0061.1: # of clients waiting for a connection from connection pools
(<$VALUE>) too high (>=<$THRESHOLD>)
Instruction Text The number of clients waiting for a connection has exceeded the threshold
value.
Probable cause: The size of the connection pool is too small relative to the
number of current client sessions that require JDBC Connections.
Potential impact: Client connection requests will be forced to wait for an
available connection from the connection pool.
Suggested action: Increase the maximum size of the connection pool. A good
rule of thumb is that the maximum size of the connection pool should be equal
to the number of Execute Threads configured in the WebLogic Server. This
assumes that each thread uses one transaction to service a request and therefore
needs just one connection. If this is not the case, then a slightly larger
connection pool may be more efficient.
The connection pool minimum size should be equal to the maximum size. This
ensures that all database connections are acquired during server start-up and not
when the server is under load.
Action Operator-initiated graph
Area JDBC