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:

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

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