Poor Performance Of Pipeline After Cancellation Of Subscriptions (Doc ID 1303530.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Dec-2012***

Symptoms

Performance of the pipeline is very poor in case database access is needed.

Scenario:

Recently in production system were terminated 130,000 discounts. After rating of CDRs on the next day, performance of the pipeline was significantly degraded.

Based on initial investigation, about 5% of CDRs for rating were 3 days old with start date before termination of the discounts. These 5% of CDRs cause degradation of the performance from 900 EDRs/s to 50 EDRs/s.

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