Performance Issue With RMS Likestore Batch (Doc ID 1905488.1)

Last updated on OCTOBER 27, 2015

Applies to:

Oracle Retail Merchandising System - Version 13.2.5 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Merchandising System (RMS) 13.2.x, when running the likestore batch in multiple threads (threaded by DEPT), some of the threads will wait for the locks to be released from other threads.

Steps to Reproduce:

  1. Create a new store using the RMS front end.
  2. Run the storeadd batch.
  3. Run the likestore batch in 16 threads.
  4. Ensure that no other batch is being executed while likestore is running.
  5. Notice that some threads do not finish and keep waiting for other threads to finish.

Cause

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 hundreds of Community platforms