Reducing audit trail size threshold
The bodies of messages are normally saved to the AUDIT_TRAIL table in the database, with larger messages being stored in AUDIT_DETAILS. By decreasing the threshold for messages to be saved in AUDIT_DETAILS, we can prevent a large amount of payload data from being loaded in the AUDIT_TRAIL table, which can improve performance.
Getting ready
You will need to install SOA Suite with the Enterprise Manager Fusion Middleware Control component to use this recipe.
How to do it...
Follow these steps to set the Audit trail size threshold:
Follow steps from 1 through 2 of the Setting the audit store policy recipe to navigate to the Advanced BPEL Configuration page.
Locate the AuditDetailThreshold property, and decrease its value.
Save your changes.
How it works...
The audit trail size threshold determines how large audit messages have to be before their content is stored in the AUDIT_DETAILS table rather than in the AUDIT_TRAIL table. By decreasing this value, we can make...
