Oracle SOA 11g Dehydration Store – Reclaiming Table Memory

ReclaimingTableMemory-F

When you work with Oracle’s out-of-the-box purge scripts, you’ll eventually realize that one of the things it does not perform is reclaiming table space after you execute a purge. This is a key factor when you’re trying to increase the overall performance with a SOA Dehydration Store. Thankfully, the hard part is realizing it is needed; it is easy to perform. You’ll want to generate a series of queries that reclaim the unused space within each table you are working with. Those queries are molded after the following:

png;base64f2b977552c45b9e8

One of the main focuses when reclaiming memory is tables relating to the Oracle BPEL Process Manager, which contains tables like CUBE_INSTANCE and XML_DOCUMENT.

Here are the before and after results when I tried these queries for the first time:

Before

png;base6428eba1cde8058509

After

png;base646f872c9cdab8bbc3

Leave a Reply

Your email address will not be published. Required fields are marked *