Poor Performance Querying And Processing From Staging Table
(Doc ID 1311247.1)
Last updated on DECEMBER 23, 2016
Applies to:Oracle Retail Store Inventory Management - Version 13.1 and later
Information in this document applies to any platform.
In Store Inventory Management (SIM) system, find that average processing rate of messages from 'INTEGRATION_STAGING' table, summing up all the polling timers, rarely exceeds 1000 messages per minute.
Steps to Reproduce:
1. Send messages to Store Inventory Management (SIM) through Retail Integration Bus (RIB) (e.g. 10K messages of the same family).
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!