Purging Strategies in Oracle SOA Suite 11gR1 PS3
By Demed L'Her on May 27, 2011
UPDATE: the detailed whitepaper on "SOA 11g Database Growth Management Strategy" is now available.
Just a quick post before taking off for the long Memorial Day weekend in the US (we are off on Monday).
Since shipping Oracle SOA Suite 11g we’ve seen an explosion of the amount of data being processed by the product across the world. The net result of this is a corresponding growth in audit data and increasingly more complex needs on the purging side: often times purges need to happen on running system and that means with the least possible impact on operations. We have added several improvements in PS3 to the purge scripts. Here is a set of slides describing the various purging strategies now available in Oracle SOA Suite: from the graphical tools in Enterprise Manager, to PL/SQL scripts (looped purge and parallel purge) and database partitioning.
This slide deck is a work in progress so please leave your questions on purging in comments and I will try to address them in the next version (and if I don’t, Deepak will in the more substantial whitepaper that he is preparing on this very topic).