Server User Manual

■
Idle Timeout: Maximum time in seconds that a connection can remain idle in the pool.
After this time, the pool can close this connection. This property does not control
connection timeouts on the database server.
Keep this timeout shorter than the database server timeout (if such timeouts are congured
on the database), to prevent accumulation of unusable connection in Enterprise Server.
For best performance, set Idle Timeout to zero (0) seconds, so that idle connections will not
be removed. This ensures that there is normally no penalty in creating new connections and
disables the idle monitor thread. However, there is a risk that the database server will reset a
connection that is unused for too long.
Isolation Level Settings
Two settings control the connection pool’s transaction isolation level on the database server:
■
Transaction Isolation Level: species the transaction isolation level of the pooled database
connections. If this parameter is unspecied, the pool uses the default isolation level
provided by the JDBC Driver.
■
Isolation Level Guaranteed: Guarantees that every connection obtained from the pool has
the isolation specied by the Transaction Isolation Level parameter. Applicable only when
the Transaction Isolation Level is specied. The default value is true.
This setting can have some performance impact on some JDBC drivers. Set to false when
certain that the application does not change the isolation level before returning the
connection.
Avoid specifying Transaction Isolation Level. If that is not possible, consider setting Isolation
Level Guaranteed to false and make sure applications do not programmatically alter the
connections’ isolation level.
If you must specify isolation level, specify the best-performing level possible. The isolation
levels listed from best performance to worst are:
1. READ_UNCOMMITTED
2. READ_COMMITTED
3. REPEATABLE_READ
4. SERIALIZABLE
Choose the isolation level that provides the best performance, yet still meets the concurrency
and consistency needs of the application.
Connection Validation Settings
The following settings determine whether and how the pool performs connection validation.
Pool Resize Quantity
Chapter 3 • Tuning the Enterprise Server 79