Database Reference
In-Depth Information
Configuration
Level
Property
Description
Domain and
Component
This property sets the audit trail
logging level. This process is
applicable to both durable and
transient processes.
auditLevel
For all asynchronous processes,
inMemoryOptimization
should be set to
False
. If left as
True
you will need to set
completionPersistPolicy
to
Off
in order to avoid any
dangling and orphaned references in the database tables.
ing Oracle SOA Suite 11g for Optimum Performance
for examples on how to set
these in the
composite.xml
of the SOA project.
Database
objects
of
the
SOA
Dehydration
Store
The next important area to understand is the structure of the underlying Dehyd-
ration Store database. It is somewhat difficult to comprehend the data model and
objects maintained by Oracle SOA Suite 11g Dehydration Store as the tables
maintained in them have no foreign key constraints to police referential integ-
rity and are intentionally designed as such for performance reasons. Without
these constraints, the relationship between master and detail tables needs to be
protected to avoid dangling references in the detail tables. Hence, utmost care