My Oracle Support Banner

Sapurge Batch Is Running long (Doc ID 2695955.1)

Last updated on AUGUST 03, 2020

Applies to:

Oracle Retail Sales Audit - Version 16.0.2 and later
Information in this document applies to any platform.

Symptoms

Index needed on SA_GL_REF_DATA for sapurge.

Steps To Recreate:
1) Make sure SA_GL_REF_DATA has upwards of 30 million records.
2) Run sapurge to remove 1 days worth (3000 store/day records) of data
3) Notice SQL to remove data from KEY_MAP_GL and SA_GL_REF_DATA do full table scans on SA_GL_REF_DATA and take time.

Changes

 

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