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.
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.
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.
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