RMSMFM_ITEMS.GETNXT Performance Issue
(Doc ID 2509792.1)
Last updated on JANUARY 06, 2020
Applies to:Oracle Retail Merchandising System - Version 16.0.1 to 16.0.2 [Release 16.0]
Information in this document applies to any platform.
During execution of an Retail Merchandising System ( RMS ) batch process, RMSMFM_ITEMS.GETNXT is processed during a longer time as the ITEM_MFQUEUE table is growing. The issue still persist only for large data provided as input.
The issue can be reproduced at will with the following steps:
- Prepare at least 300000 records to publish in ITEM_MFQUEUE table
- Run related RMS batch process
- Monitor sessions and notice the SQL in question comes up as top SQL while Retail Integration Bus is getting the messages from ITEM_MFQUEUE table.
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