Sun Java System Web Server 6.1 SP6 Performance Tuning, Sizing, and Scaling Guide

JDBC Connection Pooling with OCI Driver

This test tested the scalability and performance of the JDBC connection pooling module. In this test a simple servlet requests a row from a large database and prints its content. An Oracle database and the Oracle OCI driver were used for the test. JDBC connection pool resource configuration is shown below (server.xml).

<RESOURCES>
       <JDBCRESOURCE jndiname="jdbc/tpcwDB" poolname="TpcwPool" 
enabled="true">
       <JDBCCONNECTIONPOOL name="TpcwPool" 
datasourceclassname="oracle.jdbc.pool.OracleDataSource"
steadypoolsize="1000" maxpoolsize="1000" poolresizequantity="2"
idletimeout="0" maxwaittime="0" 
connectionvalidationrequired="false"
connectionvalidationmethod="auto-commit" 
validationtablename="string" failallconnections="false" >
    <PROPERTY name="URL" 
value="jdbc:oracle:oci8:@(description=(address=(host=mach-3)
(protocol=tcp)(port=1521))(connect_data=(sid=10K)))">
 <PROPERTY name="user" value="tpcw">
 <PROPERTY name="password" value="tpcw">
              </JDBCCONNECTIONPOOL>
 </RESOURCES>

Number of clients: 3600

Figure 7–10 JDBC Connection Pool

JDBC Connection Pool

Table 7–18 JDBC Connection Pooling Test

CPUs  

Response Time (msec)  

Op/Sec  

4223.66 

529.14 

1508.53 

966.74 

153.19 

1634.94