AnsweredAssumed Answered

Application Collectors taking too long to complete

Question asked by Maninder Bhamrah on Sep 17, 2019
Latest reply on Oct 8, 2019 by Maninder Bhamrah

Application collector is taking too long to complete. The indirect Relationship Processing is running from 14 hours now.

As diagnosed, it is stuck executing the below merge query 

 

MERGE /*+ Leading (r) Index (xue IXN_XUE_CE_EXPLODED_PATH) */ INTO T_AV_EXPLODEDUSERENTITLEMENTS XUE
USING (
SELECT CE_EXPLODED_PATH
FROM GTT_CE_AFFECTED_PARENTS
) R
ON (XUE.CE_EXPLODED_PATH LIKE ' ' || R.CE_EXPLODED_PATH || '%')
WHEN MATCHED
THEN
UPDATE
SET XUE.DELETION_DATE = SYSDATE
WHERE XUE.DELETION_DATE IS NULL
AND XUE.ENTITLED_TYPE = :B1

 

Kindly let me if there is an fix for this and the cause. Any leads would be appreciated.

Outcomes