We have the issue that when committing changes to technical roles, the database CPU gets locked to 100% usage and it takes several minutes, between 5-20min, for it to complete the background task of creating the change request. For example adding entitlements, members or just inserting a description and then committing the role.
The SQL command it gets stuck at starts with:
INSERT ALL
INTO GTT_ROLES_CR_ITEMS
Anyone else encountered this problem?
One thing I've (surprisingly) seen very common recently is either undersized environments or misconfigured database parameters. Both of which manifest themselves in extremely slow performance and high utilization.
I would start first by making sure the environment is at least at the minimum required resources: 8 CPU cores, 8GB Heap size, 18GB SGA, 9GB PGA (note these are minimum requirements, which means depending on your environment size and load, you might need more). Then if you are using your own database (customer-supplied database), make sure all the database parameters are configured as required in the RSA Identity Governance and Lifecycle 7.2 Database Setup and Management Guide (specifically optimizer settings and cursor_sharing).
If the above checks don't help, you should definitely reach out to RSA Support to help troubleshoot and fix any performance issues.
How to contact RSA Support