My Oracle Support Banner

Billing Performance Is Very Poor (Doc ID 1520460.1)

Last updated on JULY 08, 2022

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Goal

On one customer production system, the billing performance was very poor.

From AWR report, the following queries are creating dead lock when there are too many applications trying to generate POIDs (using POID_IDS2).

 
The performance issue would happen especially when Payment processing is happening along with Billing. This issue gets resolved, if Payments process is stopped. Payment processing and Billling happens on two separate DM_Oracle chains.

Solution

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