Disaggregation Batches are Having Continued Performance Issue - Taking Unexpectedly Long Time to Process a Batch Run

(Doc ID 2229888.1)

Last updated on FEBRUARY 03, 2017

Applies to:

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

Symptoms

Problem Description
---------------------------------------------------
Disaggregation batches are having continued performance issue.
The fix PD provided with Patch 24578552 was giving very good results on partial disaggregation runs (partial means for few accounts). But there is not much difference in performance when it is run for full disaggregation (all accounts).
These are taking too long time to process.

Actual Results:
No of. records attempted for Disagg = 6,357,713

Batch Parameters:
Threads = 32
Chunk Size = 5000
Disaggregate Transactions From Date = 2015-08-01
Batch Business Date = 08-31-2015

Time taken for Batch Completion = 18:14:10 Hrs
No records in error in the Batch Run Tree

Expected Results:
Transaction should be restored with UPLD status in expected time.
PD is expected of tuning batch with new design and it should give better performance for account based disaggregation runs.
Dis-aggregation is account based - so these tunings should bring performance improvement.

Steps & Settings:
* A detailed list of settings and steps that lead to the reported issue (see Doc ID#1233173.1).

* Information on the configuration of the box where the application is configured, this would include memory allocation and installation considerations.

--51. Advanced Environment Memory Configuration
  Web Application Java Initial Heap Size: 3072
  Web Application Java Max Heap Size: 5120
  Web Application Java Max Perm Size: 1228
  Web Application Additional Options:
  Global JVM Arguments:
-XX:+HeapDumpOnOutOfMemoryError -XX:HeapDumpPath=/scratch/or...
  Ant Min Heap Size: 200
  Ant Max Heap Size: 800
  Ant Additional Options:
  Thread Pool Worker Java Min Heap Size: 1024
  Thread Pool Worker Java Max Heap Size: 4096
  Thread Pool Worker Java Max Perm Size: 1228
  Thread Pool Worker Additional Options:
  Additional Runtime Classpath:

* db_cahce_size parameter to 15GB
 
* Database resides on same server as the application with 64GB size
* Affected environment is only active environments running on Server

Business Impact:
* The performance is at an unacceptable level for the customer, they cannot process the batches in a timely manner.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms