BEA WebLogic Integration (WLI) enables developers to rapidly create complex enterprise business integration applications. Performance and scalability of these applications is closely tied to the performance and efficiency of the database used for managing persistence.
The default Oracle database installation provides average performance to a wide variety of typical database applications. This default configuration can be modified to meet the specific needs of an application such as WLI to achieve better performance and efficiency. This guide provides best practices and guidelines for configuring and tuning the Oracle9i database for optimized performance with WLI.
This guide is organized into two sections:
A brief introduction to identifying database performance issues with Oracle Statspack is also provided in Oracle Statspack.
The target audience of this guide includes:
Some of the suggestions made in this guide are advanced and should only be implemented by knowledgeable professionals who can accurately gauge the effect(s) such changes would have on the overall system.
Oracle9i Database Reference: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/toc.htm
Oracle9i Database Concepts: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/toc.htm
Oracle9i Database Performance Tuning Guide and Reference: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/toc.htm
ORACLE-BASE - Oracle9i Recovery Enhancements: http://www.oracle-base.com/articles/9i/RecoveryEnhancements9i.php
Partitioning in Oracle. What Why When Who Where How: http://www.devarticles.com/c/a/Oracle/Partitioning-in-Oracle/1/