My Oracle Support Banner

Slow Performance of Install Base Instance Relationships Transaction History purge CSIRELARCH (Doc ID 1354887.1)

Last updated on AUGUST 05, 2022

Applies to:

Oracle Installed Base - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR
---------------
Install Base Instance Relationships Transaction History purge program (CSIRELARCH module) has extremly slow performance took 13 hours to complete and Number of Instance Relationships history records archived is 0.


EXPECTED BEHAVIOR
-----------------------
The program should have better performance and and there are no records to be purged and in a such a case it should not be more than a few seconds.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Login to Oracle Applications -> Oracle Install Base Admin -> Requests -> Select Install Base Transaction History purge program and enter parameters (for 3 montths worth of data).

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.