My Oracle Support Banner

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

Last updated on SEPTEMBER 09, 2021

Applies to:

Siebel Loyalty Engine - Version 8.1.1.11.17 [IP2013] and later
Information in this document applies to any platform.

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

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
Goal
Solution
References


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