Will Setting RPM_FUTURE_RETAIL_SEQ from ORDER to NOORDER, to Avoid Massive Blocking on RPM_FUTURE_RETAIL_GTT Table, Impact RPM Functionality?
(Doc ID 2564240.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Retail Price Management - Version 16.0.1 and later
Information in this document applies to any platform.
RPM frequently experiences massive blocking on RPM_FUTURE_RETAIL_GTT table which should not be the case. It looks like the wait event is on the sequence RPM_FUTURE_RETAIL_SEQ.
As per the Database (RAC) SR 3-20324122651, it has been recommended to set the RPM_FUTURE_RETAIL_SEQ from ORDER to NOORDER. Will this impact RPM functionality?
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