Pin_bill_accts is Taking Longer Time to Execute
Last updated on JUNE 19, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
On Oracle Communications Billing and Revenue Management(BRM), 126.96.36.199.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.
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