Purge Script Has Performance Issues (Doc ID 551244.1)

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.

Symptoms

On 10.1.2.0.2 in Production:
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.

For example:

java -ms1024M -mx1024M oracle.tip.repos.purge.PurgeManager purgeRuntime -start 01-AUG-2007 -end 21-AUG-2007 Complete


EXPECTED BEHAVIOR
Need to be able to purge reports with several hundreds of thousands of messages daily in a timely manner.


Cause

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