My Oracle Support Banner

Uneven Distribution of Records Across the Threads for C1-BLGEN batch. (Doc ID 2743154.1)

Last updated on JANUARY 12, 2021

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.9.0.0.0 to 2.9.0.0.0 [Release 2]
Information in this document applies to any platform.

Symptoms

On : 2.9.0.0.0 version, BT - Batch

ACTUAL BEHAVIOR
---------------
Few threads are processing more records, few threads are with less records and few are with 0 records.
The jobs are getting completed on time without performance issues.

Below are some settings defined for test run:
1) Cache size defined for sequence RMB_CIBILLTMPSEQ: 5000.
2) Thread Count used for C1-PNDBL batch: thread Count=64.
3) Min(seq_timestamp) and Max(seq_timestamp) from ci_billtemp table for billable charges data for C1-PNDBL batch.

MAX(SEQ_TIMESTAMP) - 10000000000000135997587
MIN(SEQ_TIMESTAMP) - 10000000000000135244541

4) Volume of billable charges for test run - 254779.

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!


In this Document
Symptoms
Cause
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.