
Oracle SOA Suite 11g Performance Tuning Cookbook

As with many SOA Suite components, the BPEL and BPMN engines make a lot of use of the database. Ensuring that the database statistics are updated regularly, will ensure that the optimizer picks the correct plan for accessing the underlying database tables.
You will need database administration access to the database being used for your Oracle SOA Suite 11g applications.
Follow these steps to ensure the database statistics generation task is enabled:
Log in to the database, and open an SQL prompt.
Execute the following SQL query:
exec dbms_auto_task_admin.enable;
The database optimizer uses the most recent database statistics to determine its plan (index lookup, table scan, and so on) for each SQL statement that is executed. Having up-to-date statistics is therefore vital to ensure that the correct plan is selected, and that the database operates as fast as possible. Oracle recommends that automatic...