My Oracle Support Banner

Sapurge - INSERT INTO Sa_tran_item_temp Slow As Not Using Partitioning (Doc ID 2819763.1)

Last updated on NOVEMBER 05, 2021

Applies to:

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

Symptoms

sapurge - INSERT INTO sa_tran_item_temp slow as not using partitioning

In the sapurge program, the INSERT INTO sa_tran_item_temp statement in the delete_cust_ord_tran_detail function does not use store and day in the JOINs of SA_TRAN_HEAD and SA_TRAN ITEM. 

Steps To Recreate:

1) Run sapurge batch in volume environment.
2) Notice that the batch is not using partitioning..

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.