My Oracle Support Banner

Billing Performance Is Very Poor (Doc ID 1520460.1)

Last updated on AUGUST 20, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
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).

SELECT POID_IDS2.NEXTVAL FROM SYS.DUAL

“SELECT poid_rev
  FROM data_t
  WHERE NAME = :b1 AND poid_type = '/data/sequence_lock'
FOR UPDATE”

 
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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.