General Recommendations For Loyalty Batch Engine Slow Performance (Optimization Hints) (Doc ID 2772718.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

The following questions were asked around performance:

Q1. Recommendations for optimization were asked as a general question and were not specific
Q2. How LOYEngineSleepTime works? (on each objectType or all types)
Q3. Is it possible to make the Queue Manger load objects in parallel without waiting for the completion of the SQL query for another type of object?
For example, for Tier to be processed regardless of whether the Queue Manger has finished requesting Accrual.
Q4. How to improve performance on the DB side with large amounts of data?
 

Solution

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