Performance Tuning Guide

General Performance Tuning Guidelines

Application performance is affected by many factors. This chapter discusses a few of the initial aspects that can affect performance and provides links to documentation resources that can assist you.

WebLogic Server Tuning

Because WebLogic Portal runs on WebLogic Server, it is expected that factors impacting the performance of WebLogic Server will also impact the performance of WebLogic Portal.

For more information about tuning your WebLogic Server, see http://download.oracle.com/docs/cd/E13222_01/wls/docs81/perform/index.html

Database Tuning

WebLogic Portal provides an optimization script that runs the respective vendor database script that computes database statistics needed for the database optimizer. Typically, this script is called statistics.sql and is stored in the respective BEA install for each supported database in the respective directory.

The statistics.sql script should be run periodically, as well as after the database content significantly changes (e.g., a large number of users are added). Keeping database statistics up to date can dramatically improve query execution time. See

http://download.oracle.com/docs/cd/E13218_01/wlp/docs81/db/index.html for more information.

Upgrade to Latest Service Packs

Service packs almost always include improvements to some area of performance. Service packs are available individually for download to Contract Support Customers. Go to the http://support.bea.com to log in to eSupport. Navigate to Product Download and Service packs in the left navigation bar. Choose the product of interest and follow links to the version and service pack you are interested in.