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
ON (XUE.CE_EXPLODED_PATH LIKE ' ' || R.CE_EXPLODED_PATH || '%')
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.