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 18.104.22.168.0 and later
Information in this document applies to any platform.
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”.
Will it improve the performance, if one creates the indexes on these event tables?
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