Article Content
Article Number | 000031009 |
Applies To | RSA Product Set: RSA Identity Governance & Lifecycle RSA Version/Condition: 7.0.0 |
Issue | When running an Active Directory Account Collector for the first time on RSA Identity Governance & Lifecycle 7.0.0 (Collectors > Account Collectors > {Collector name} > Collect Accounts button), the collector takes significantly longer to run than expected. Oracle Enterprise Manager (OEM) for the top query at the time the collector is running shows the following query consuming resources:
|
Cause | This is a known issue reported in engineering ticket ACM-56128. There is a nightly job that gathers statistics on certain tables to assist the Oracle optimizer in choosing the optimal execution path when executing SQL queries. A change in the way RSA Identity Governance & Lifecycle 7.0.0 gathers statistics causes the Oracle optimizer to choose the incorrect execution path. |
Resolution | This issue is resolved in RSA Identity Governance & Lifecycle 7.0.1. The fix is to remove the existing statistics on collection tables prior to a collection run so that Oracle will dynamically gather statistics at collection run time and determine the best path for query execution. |