Database Reference
In-Depth Information
The Dehydration Store
The BPEL Process Manager is a web application created by Oracle. Oracle BPEL
Process Manager is deployed on top of J2EE containers such as WebLogic, We-
bSphere, and JBoss. Oracle BPEL Process Manager uses a database to store
metadata, runtime instance information, and the state of each conversation. The data-
base is also used as a Dehydration Store to store the state of the BPEL process ser-
vices.TheprocessofupdatingthestateoftheBPELprocessservicesinthedatabase
iscalled Dehydration .Theasynchronousandsynchronousprocessesmainlyusethe
Dehydration Store to save the state of the process while waiting for asynchronous
callbacks. The asynchronous messages also persist in the Dehydration Store.
Over a period of time the Dehydration Store database fills with data unless you purge
the data at regular intervals. It is an industry-leading practice to develop data purging
frequency based on the data retention policies for audit and troubleshooting needs. It
is also a leading practice to trigger the purge of the Dehydration data based on the
database disk utilization. Oracle provides the PL/SQL packages to purge data from
the Dehydration Store. Due to performance reasons, the database schemas do not
have the foreign keys and this complicates the purge of the Dehydration data. There
are multiple tables used for the Dehydration Store.
The database schemas are created during the install process using the RCU utility.
The database schema DDL for Dehydration Store can be found at
%SOA_ORACLE_HOME%\rcu\integration\soainfra\sql\bpel .
Options for purging the Dehydration Store
Different options available to purge large amounts of data instances from the Dehyd-
ration Store database are listed as follows:
• Drop the SOA schemas created by the RCU utility to remove all the SOA
instances and its state information. You can recreate the schemas using
the RCU utility with the same credentials and reconnect with the SOA
Suite middleware instances.
• Use BPEL APIs provided by Oracle to remove the data from the Dehydra-
tion Store.
Search WWH ::




Custom Search