My Oracle Support Banner

Post Upgrade RPM_FUTURE_RETAIL_PURGE_JOB Job Running Long (Doc ID 2941685.1)

Last updated on APRIL 12, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Goal

Post upgrade to 19.3.012 there is a huge lag in GG replication.

The below delete in RPM_FUTURE_RETAIL_PURGE_JOB is being executed at the target side 21 million times deleting 1 record in each execution.

DELETE FROM "PLSTOCKRMSDAS"."RPM_FUTURE_RETAIL" WHERE "FUTURE_RETAIL_ID" = :b0
 

Solution

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