My Oracle Support Banner

Performance Issue with C1-IDENT Batch (Doc ID 2834311.1)

Last updated on JANUARY 26, 2022

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.9.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On RMB v2.9.0.0.0, Performance issue on C1-IDENT batch run.

As part of Parallel Cycle, we are facing performance issue.

Observations:
1. Batch is running with 70 threads, with a chunk size of 1000 and max batch count as 1000.
2. 69 out of 70 threads completed, only thread number 41 is still running with 15 records processed. Whereas remaining 69 threads processed 87 records specific to each thread and marked to completed         status.
3. From Parallel Cycle the job processed 6014 records and took only 8 minutes to complete. But now the job is still running even after 16+ hours.

Execution stats from the current run:
Job Name                         Start Time                End Time                  Elapsed Time(hh:mm:ss)     Thread counts   Chunk Size    Batch Nbr Comments
14xxx_RMB_C1IDENT    12/15/2021 18:30    12/16/2021 11:24      16:54:11 70                          1000                   5                   Job Is still running
    
AWR reports shared for your reference.

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.