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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.