Pin_bill_accts is Taking Longer Time to Execute
(Doc ID 2157974.1)
Last updated on AUGUST 16, 2018
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On Oracle Communications Billing and Revenue Management(BRM), 220.127.116.11.0 version, Core Billing,
One of the queries as part of pin_bill_accts is taking longer time to execute approximately around 60 seconds. This query is going for full table scan on "event_billing_incentive_t" table and is impacting the billing performance in production. Details are as below.
WHERE obj_id0 = :1
The DBA's Recommendation:
Introduce index on the “obj_id0” column of the table “event_billing_incentive_t” which will improve efficiency by 99.99%.
Currently there is no index on any of the columns of the table.
Kindly suggest what can be done to improve the performance.
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