Performance Slow Down With Missing Indexes While Running PCM_OP_CUST_DELETE_ACCT
(Doc ID 2621380.1)
Last updated on FEBRUARY 08, 2024
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 out of box 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 |