Pin_bill_accts is Taking Longer Time to Execute
(Doc ID 2157974.1)
Last updated on DECEMBER 10, 2022
Applies to:Oracle Communications Billing and Revenue Management - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
One of the queries as part of pin_bill_accts is taking longer time to execute approximately around 60 seconds in 7.4 PS22. 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
Here is the recommendation from DBA:
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