Purge Script Has Performance Issues
Last updated on NOVEMBER 19, 2016
Applies to:Oracle Application Server Integration B2B - Version: 10.1.2.0.2
This problem can occur on any platform.
B2B instance has over 100,000 messages in the business and wire reports.
When executing the java class oracle.tip.repos.purge.PurgeManager to purge
the reports, it takes several hours to clear up a couple of thousands of
records in tip_<XX>message_rt tables. This is causing performance issues.
java -ms1024M -mx1024M oracle.tip.repos.purge.PurgeManager purgeRuntime -start 01-AUG-2007 -end 21-AUG-2007 Complete
Need to be able to purge reports with several hundreds of thousands of messages daily in a timely manner.
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