We often get questions about how to manage purging old data (finished processes instances, task histories, etc.) from SOA and BPM 11g when those data are no longer wanted.
There are some scripts provided to do this in 11.1.1.2, 11.1.1.3 and new, improved ones in 11.1.1.4. Now, the scripts from 11.1.1.4 (which are better) have been backported to 11.1.1.2 and 11.1.1.3 so that customers who have not upgraded yet can also take advantage of the updated scripts. For more information on this, please log on to My Oracle Support and take a look at Note 1297250.1, and patch 10297850.
In addition to this, Demed L’Her from our product management team has posted some more detailed information about the various options available here.
RedStack 