My Oracle Support Banner

How To Calculate Newitemlocbatch.Sh Chunk Count? (Doc ID 437750.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Retail Price Management - Version 11.0.8 and later
Information in this document applies to any platform.
 


Goal

We wish for some greater clarity on the chunking algorithm used by the newitemlocationbatch.sh. 

Specifically, how were ~129,000 item/loc records in RPM_STAGE_ITEM_LOC and RPM_STAGE_ITEM_LOC_CLEAN tables processed in a single chunk?  The THREAD_LUW_COUNT is set at 1000 and NUM_THREADS=24.  The number of chunks calculated is 1, which does not seem to be correct.

Number of records in RPM_STAGE_ITEM_LOC: ~129,000
Number of records in RPM_STAGE_ITEM_LOC_CLEAN: ~129,000
THREAD_LUW_COUNT: 1000
NUM_THREADS: 24


Scenario 1: RPM_BATCH_CONTROL:

THREAD_LUW_COUNT = 1000
NUM_THREADS = 24

  Number of chunks calculated by the program is 1


Scenario 2: RPM_BATCH_CONTROL:

THREAD_LUW_COUNT = 10
NUM_THREADS = 24

  Number of chunks calculated by the program is 28

Calculating rank:

In the RPM_NEW_ITEM_LOC.STAGE_ITEM_LOCS_TO_PROCESS() function, the following SQL is used to calculate the rank:


The chunk_size is then calculated using the ceil(rank/THREAD_LUW_COUNT).

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!


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