My Oracle Support Banner

Purge Script Has Performance Issues (Doc ID 551244.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle B2B 10g (Business to Business) - Version 10.1.2.0.2 and later
Information in this document applies to 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.