BEA WebLogic Server Tuning Guide

15
MaxCapacity="4"
Name="sqlmxPool”
StatementCacheSize="0"
Properties="maxStatements=100"
ShrinkPeriodMinutes="30"
ShrinkingEnabled="false"
SqlStmtMaxParamLength="10"
SqlStmtParamLoggingEnabled="false"
SqlStmtProfilingEnabled="false"
SupportsLocalTransaction="true"
Targets="joecluster"
TestConnectionsOnRelease="false"
TestConnectionsOnReserve="false"
URL="jdbc:sqlmx:"/>
Sample JDBC Connection Pool Element extracted from a configuration using the XA driver:
<JDBCConnectionPool
CapacityIncrement="1"
ConnLeakProfilingEnabled="false"
DriverName="com.hp.nsk.xares.WLSTxSQLMXDataSource"
InitialCapacity="4"
KeepLogicalConnOpenOnRelease="false"
KeepXAConnTillTxComplete="true" MaxCapacity="4"
Name="sqlmxPool"
NeedTxCtxOnClose="false"
NewXAConnForCommit="false"
PrepStmtCacheProfilingEnabled="false"
PrepStmtCacheProfilingThreshold="10"
StatementCacheSize="0"
Properties="maxStatements=100"
RecoverOnlyOnce="false"
RefreshMinutes="0"
ShrinkPeriodMinutes="30"
ShrinkingEnabled="true"
SqlStmtMaxParamLength="10"
SqlStmtParamLoggingEnabled="false"
SqlStmtProfilingEnabled="false"
SupportsLocalTransaction="true"
Targets="joecluster"
TestConnectionsOnRelease="false"
TestConnectionsOnReserve="false"
URL="jdbc:sqlmx:"/>
3.9 Configuring WebLogic Server Execute Threads
The configuration of Execute Threads is a key aspect of WebLogic Server tuning. However, unlike the 7.0 SP1
release of WebLogic Server on the NonStop server, the 8.1 SP3 release of WebLogic Server on the NonStop server
does have native code multiplexer support. This greatly reduces the complexity of configuring the execute threads.
By default, WebLogic Server 8.1 SP3 is configured with 25 threads for the production environment and 15 threads
for development application environments. Also, it is possible for applications to specify their own execute queue
with a dedicated set of threads.