Tuning the dehydration store database schema
The performance of the Oracle SOA Suite 11g platform is directly dependent on the performance of the underlying dehydration store database and, hence, it becomes vitally important to tune this database for optimal performance.
Most importantly, you need to ensure that the underlying database is configured to handle adequate processes and sessions to support the infrastructure. The database must also be tuned so that it has enough memory for caching, Program Global Area (PGA), and System Global Area (SGA), and has an adequate number of open and shared cursors and processes.
The following table provides a few generic changes that you should consider making to your Oracle database to improve the response time and throughput of your SOA infrastructure. Ultimately, Oracle database tuning is a vast topic and tuning parameters are not universal, so engage your Oracle DBA during your load and performance tests to assist in providing optimal settings...