Tuning of the Oracle database is out of the scope for this book; however, some of the relevant steps for tuning that can be performed as part of SOA Suite tuning are listed in this section. Since SOA Suite is an application running on a J2EE container such as WebLogic, it requires a database for storing meta data. Monitoring and tuning the database associated with SOA Suite provides optimum performance for SOA Suite container and your BPEL composite application.
- Ensure that the initial connection pool and max connection pool are the same. Use a large number for connection pools to avoid running out of database connections.
- Use GridLink database source for Oracle RAC connectivity instead of multi pools. Please refer to Chapter 10, Architecting ...