RSA Identity Governance & Lifecycle collector slow in Indirect Relationship Processing.The following query may be identified in AWR reports as running long.
f8sj8nc35b82w UPDATE T_AV_EXPLODEDUSERENTITLEMENTS old_ SET DELETION_DATE = SYSDATE WHERE DELETION_DATE IS NULL AND RUN_ID = -:"SYS_B_00
This issue is caused by poor execution plans for some SQL queries related to Roles.
This is a known issue in the following versions which have additional steps in Indirect Relationship Processing:
This issue has been resolved in the following versions/patches which introduce code changes and new indexes which increase performance: