My Oracle Support Banner

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.

Symptoms

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).

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!

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