Smart Plug-in for WebLogic Server Reference Guide

1-52

Chapter 1

Metric B260_JDBCConnectionPoolUtil

Monitor Template Name WLSSPI_0260

Metric Name JDBC Connection Pool Utilization Percent

Metric Type Alarming, Reporting

Description Percentage utilization of available JDBC connections in connection pool.

WebLogic 6.0/6.1 or Both Both

Severity: Condition Two conditions:

Critical: WLSSPI-0260.1, threshold, 98%

Major: WLSSPI-0260.2 , threshold 95%

Collection Interval 5m

Message Group WebLogic

Message Text WLSSPI-0260.1: % utilization of available JDBC connections in connection

pool (<$VALUE>%) too high (>=<$THRESHOLD>%

Instruction Text The JDBC connection pool utilization has exceeded the threshold value.

Probable cause: The number of available JDBC connections is low.

Potential impact: Performance degradation caused by having to wait for a

JDBC connection to a DBMS.

Suggested action: If the database system can support additional connections,

the WebLogic administrator should increase the number of connections

available for this 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 Application Bank Report (ASCII Report)

Area JDBC