Database
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 ...
Get Oracle SOA BPEL Process Manager 11gR1 – A Hands-on Tutorial now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
