The job takes too long to complete for around 60,000 resources.
Is there a way to make the job run faster?
Release : 15.8.1
Component : CA PPM INTEGRATIONS & INSTALLATIONS
The job performance depends on the number of resources needed to obfuscate/mask data in the Clarity and DWH database.
What parameters are selected with the job?
The job can run for resources that are inactive.
Obtain the performance report for the duration of the job and have review the tuning recommendations with the DBA team.
In one reported case with the Oracle database, the AWR reported tuning the query related to the CMN_AUDITS table