the statement cache for a JDBC connection pool
performance, WebLogic Server can cache prepared and callable statements
used in your applications (enabled by default). When an application or
EJB calls any of the statements stored in the cache, WebLogic Server
reuses the statement stored in the cache. Each database connection in a
data source has it's own statement cache. For more information, see
Increasing Performance with the Statement Cache.
To configure the statement cache for a JDBC data source:
If you have not already done so, in the Change Center of the Administration Console, click Lock & Edit (see Use the Change Center).
Domain Structure tree, expand
Services > JDBC, then select Data
Summary of Data Sources page, click the data
Configuration: Connection Pool tab.
Statement Cache Type, select one of the
LRU - After the Statement
Cache Size is met, the Least Recently Used statement
is removed when a new statement is used.
Fixed - The first Statement
Cache Size number of statements is stored and stay
fixed in the cache. No new statements are cached unless the cache
is manually cleared or the cache size is increased.