Oracle SOA Suite 11g Administrator's Handbook

Managing the Dehydration Store

Until now you have been learning about common administration tasks involving the MDS repository. The MDS maintains a small database footprint as it is simply used to store application metadata, common reusable artifacts, and runtime configuration changes. Another important schema that would require more frequent monitoring and close administration is the [PREFIX]_SOAINFRA, which is used to store instance and transactional data of all the composites being executed in the infrastructure. This database schema is also referred to as the Dehydration Store. Oracle SOA Suite 11g leverages the Dehydration Store database to maintain long-running processes and their current state information while they are executing over a ...