
Oracle SOA Suite 11g Performance Tuning Cookbook

Audit records are normally written to the database synchronously, which imposes a significant performance overhead on the application. By switching to writing audit information asynchronously, we can get a large performance improvement.
You will need to install SOA Suite with the Enterprise Manager Fusion Middleware Control component to use this recipe.
Follow these steps to set the Audit storage policy:
Follow steps from 1 through 3 in the Tuning SOA engine dispatcher invoke threads recipe to get to the BPEL Service Engine properties page.
This will open the BPEL properties page; click on the More BPEL Configuration Properties link to see the advanced properties:
Locate the Audit Store Policy property, and set its value to async
, as shown.
Save the changes.
The audit store policy determines how audit messages are persisted to the database. The default is for audit messages to be persisted to the database in the same transaction...