O'Reilly logo

Oracle SOA Suite 11g Administrator's Handbook by Arun Pareek, Ahmed Aboulnaga

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required