My Oracle Support Banner

ECE - Cdrformatter Select & Delete Threads Not Sufficient - Bad Performance (Doc ID 2910925.1)

Last updated on NOVEMBER 23, 2022

Applies to:

Oracle Communications BRM - Elastic Charging Engine - Version 12.0.0.4.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
In Elastic Charging Engine (ECE) - cdrformatter there are 6 select threads each pulling 1 row.
It was observed that 1 delete thread pulling 1 row is not sufficient and generates performance issues.

Current rate of 250cdrs/sec leaves 500k rows in the cdrstore. After several hours it grows down to 70k rows.


Requirement
-----------------------
Need a set of overrides for number of threads and the size of the array fetch.
The select to create cdrs and the delete to purge the cdrstore entries need to be configured for very high performance
 



Changes

 

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
Changes
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.