Pin_bill_accts is Taking Longer Time to Execute

(Doc ID 2157974.1)

Last updated on JUNE 19, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 and later
Information in this document applies to any platform.

Goal

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

SQL_ID: 3k8n5ba3thphj

SQL Query:

 SELECT bill_obj_DB,
  bill_obj_ID0,
  bill_obj_TYPE,
  bill_obj_REV,
  channel_id,
  current_total,
  customer_segment,
  pay_type,
  previous_total,
  trans_id
  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.

Solution

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