RSA Via Lifecycle and Governance Aveksa Data Collector (ADC) becomes stuck for hours on "Inserting account mappings into staging table"
RSA Product Set: RSA Via Lifecycle and Governance (RSA Via L&G) RSA Version/Condition: 6.8.1, 6.9.0
ADC takes a very long time to complete the "Inserting account mappings into staging table" step. There are no errors associated with the collection run in the logs. When reviewing OEM and/or an AWR for the associated timeframe we see the below long running SQL statement: