|Applies To||RSA Product Set: RSA Identity Governance & Lifecycle|
RSA Version/Condition: 7.2.0, 7.2.1
Platform (Other): Oracle Database
All Account Collectors fail in the step "Indirect Relationship Processing".
When Oracle PARALLEL_DEGREE_POLICY is set to AUTO or ADAPTIVE certain MERGE queries that are used by RSA Identity Governance & Lifecycle to generate unique sequences may result duplicates. This may occur on any type of Oracle installation but may occur more frequently with Oracle RAC.
Setting PARALLEL_DEGREE_POLICY to AUTO or ADAPTIVE has the potential to decrease the query time for specific queries but may also increase the time for other queries. RSA recommends setting this to MANUAL for overall performance.
RSA recommends Oracle PARALLEL_DEGREE_POLICY be set to MANUAL.