Performance Slow Down With Missing Indexes While Running PCM_OP_CUST_DELETE_ACCT
(Doc ID 2621380.1)
Last updated on FEBRUARY 11, 2020
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.5.0.21.0 and laterInformation in this document applies to any platform.
Goal
The user is observing Performance slow down with missing indexes while deleting accounts using OOB Opcode PCM_OP_CUST_DELETE_ACCT.
As per Business Requirement, Opcode “PCM_OP_CUST_DELETE_ACCT” is being used to delete the data for specific accounts. The delete is having performance issue and taking a longer time. It is found that issue is with below out of the box tables with missing index on the field “obj_id0”.
EVENT_AUDIT_COLL_GDTLS_T – Index required on the field “obj_id0”.
EVENT_CUSTOMER_PHONES_T - Index required on the field “obj_id0”.
INVOICE_T.ACCOUNT_OBJ_ID0
Will it improve the performance, if one creates the indexes on these event tables?
Solution
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
Goal |
Solution |
References |