Creation of huge archive logs for CS Batches in EDQ (Doc ID 2872630.1)

Last updated on JUNE 01, 2022

Applies to:

Goal

Need help to avoid the generation of huge logging.

The size of archive logs generated everyday on the database server is around 90gb to 100gb which is very huge.
Due to this, the archives don't get synced in-time to the DR site as a result of which the DR database has to be up for more time than anticipated
incurring additional billing to the client since the OCI usage for DR site is more

CS Matches seems to be causing the issue during which the archives shoot up (reaches up to 200G to 300G) 

We are running CS Matches batch against World Check (which has 7-8 million records).

The link suggests to purge the project results on a regular basis, which we have already tried. Even a single day's CS Matches batch causes the archives to go full due to which the database goes down.

Solution

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