Managing the dehydration store

Until now, you have been learning about common administrative tasks involving the MDS repository. The MDS repository maintains a small database footprint as it is simply used to store application metadata and runtime configurations changes. Another important schema that would require more frequent monitoring and close administration is the [PREFIX]_SOAINFRA database schema, which stores instance and transactional data that is executed in the infrastructure. This database schema is also referred to as the dehydration store. Oracle SOA Suite 12c leverages the dehydration store to maintain long-running processes and their current state information while these processes are executing over a period of time. Storing the process in a database preserves it and prevents any loss of state or reliability in case of a system shutdown or a network problem.

Configurations affecting the dehydration store

It is important to understand how the nature of deployed composites affects...