BEA WebLogic Server Tuning Guide

TABLE OF CONTENTS
1.0 Introduction.........................................................................................................................................3
2.0 Background Information.......................................................................................................................3
2.1 Connection Management.................................................................................................................4
2.2 The Need for Connection Pooling.....................................................................................................5
2.3 Connection Pooling as Described in the JDBC Specification ...............................................................5
2.4 WebLogic Server Connection Pooling...............................................................................................7
2.5 JDBC Statement Pooling ...................................................................................................................9
2.6 WebLogic Server Execute Queues....................................................................................................9
2.7 WebLogic Server Socket Handling..................................................................................................10
3.0 Configuration Guidelines...................................................................................................................10
3.1 Configuring WebLogic Server on HP NonStop Server for Accessing SQL/MX...................................10
3.2 Configuring a Connection Pool with the non-XA Driver.....................................................................11
3.3 Configuring a Connection Pool with the XA Driver...........................................................................12
3.4 Configuring a Non-Transactional Datasource ..................................................................................12
3.5 Configuring a Transactional Datasource..........................................................................................12
3.6 Disabling the WebLogic Server Prepared Statement Cache..............................................................13
3.7 Configuring the Number of Connections in a Connection Pool .........................................................14
3.9 Configuring WebLogic Server Execute Threads ...............................................................................15
3.10 Configuring Socket Reader Parameters.........................................................................................16
3.11 Configuring TCP/IPV6-related Parameters.....................................................................................17
3.12 Setting the TCP/IP Process Name..................................................................................................17
3.13 Configuring the Listen Address for WebLogic Server......................................................................18
3.14 Memory Considerations: Moving QIO to KSEG2...........................................................................18
3.15 Restricting the List of Ports that Can Be Filtered ..............................................................................20
3.16 Ephemeral Ports Configuration .....................................................................................................20
3.17 Reducing the Minimum Listen Queue Size and Acknowledgement Delay Interval.............................22
3.18 Logical Network Partitioning.........................................................................................................23
4.0 Fault Tolerance Considerations...........................................................................................................23
5.0 Performance Considerations...............................................................................................................23
5.1 Number of WebLogic Server Instances per CPU..............................................................................23
5.2 SQL/MX Nowait Considerations....................................................................................................24
5.3 Load Balancing..............................................................................................................................24
5.4 Disabling the Application Poller......................................................................................................24
5.5 Java Heap Setting..........................................................................................................................24
5.6 Using the WebLogic Server Console to Monitor the Performance of an Application...........................26
5.7 Tuning the Java Heap ....................................................................................................................26
5.8 JMX-Based Custom Monitoring........................................................................................................27
6.0 Additional Tuning Considerations.......................................................................................................27
6.1 Improving Instance Startup Time .....................................................................................................27
6.2 JMS Considerations .......................................................................................................................28
6.3 Configuring TMF and DP2 for Use with WLS...................................................................................28
6.4 Tuning the SQL/MX Database and the OSS File System...................................................................28
6.5 Tuning TLOG Files..........................................................................................................................28
6.6 Tuning the Data Cache ..................................................................................................................28