Billing Performance Is Very Poor
(Doc ID 1520460.1)
Last updated on AUGUST 20, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 7.4.0]
Information in this document applies to any platform.
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).
WHERE NAME = :b1 AND poid_type = '/data/sequence_lock'
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!