O'Reilly logo

Oracle SOA Suite Performance Tuning Cookbook by Matt Brasier, Nicholas Wright

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

Ensuring automatic database statistics gathering is enabled

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.

Getting ready

You will need database administration access to the database being used for your Oracle SOA Suite 11g applications.

How to do it...

Follow these steps to ensure the database statistics generation task is enabled:

  1. Log in to the database, and open an SQL prompt.
  2. Execute the following SQL query:
    exec dbms_auto_task_admin.enable;

How it works...

The database optimizer uses the most recent database statistics to determine its plan (index ...

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