My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On Oracle Communications Billing and Revenue Management(BRM), 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.

SQL_ID: 3k8n5ba3thphj

SQL Query:

 SELECT bill_obj_DB,
  FROM event_billing_incentive_t
  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

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