How to reclaim disk space after purging the SOA infrastructure or BPEL Database
Last updated on OCTOBER 13, 2017
Applies to:Oracle SOA Suite - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
In a typical production SOA installation, there is a very high throughput of data in the infrastructure database, also known as the dehydration store database. These data can accumulate and take up huge amounts of space in the database, if not managed at regular intervals. Various mechanisms of dealing with this data growth, such as purging and partitioning, are shipped with the SOA suite product. These mechanisms are described in detail in the following notes:
Oracle Fusion Middleware Administrator's Guide for Oracle SOA Suite and Oracle Business Process Management Suite
11g Release 1 (18.104.22.168.0)
Part Number E10226-07
9 Managing Database Growth
However, after deleting old and unused data in the dehydration store, administrators are sometimes surprised that the freed space is not visible on disk. This note explains why this is the case and provides some pointers on how to reclaim space freed by purging.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms