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 High Availability for Business Services, for details.
Disable database connections verifications, testing, and profiling.
Enable statement caching. This improves SOA Suite performance by caching executable statements that are used repeatedly in...
