Slow response time on Activities page in RSA Identity Governance & Lifecycle
Article Number
Applies To
RSA Version/Condition: 7.x
Issue
The following query shows in the Oracle AWR report as being executed for a very large number of times:
| 4ksjup0yzz7px | select state, count(*) from (select * from (SELECT /*+ complete-pend-count-by-workitem */ WI.CR_ID, (CASE WHEN WI.WORK_STATE_ID IN (:"SYS_B_00", :"SYS_B_01", :"SYS_B_02") AND WI.JOB_STATE_ID = :"SYS_B_03" THEN :"SYS_B_04" ELSE :"SYS_B_05" END) as state FROM V_AV_WFWORKITEMS WI left join t_av_change_requests PCR on PCR.ID = WI.CR_ID WHERE WI.WORK_TYPE = :"SYS_B_06" AND WI.WORK_STATE_ID IN (:"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10", :"SYS_B_11")) ) group by state |
Cause
Resolution
- RSA Identity Governance & Lifecycle 7.5.0 P09
- SecurID Governance & Lifecycle 7.5.2 P05
Related Articles
Data Purging does not complete in the configured time limit in RSA Identity Governance & Lifecycle Number of Views Patch or upgrade running long in step ACM-105090.sql in RSA Identity Governance & Lifecycle Number of Views Error while exporting Request Monitoring Policies in RSA Identity Governance & Lifecycle Number of Views How to identify the source of a workflow email in RSA Identity Governance and Lifecycle Number of Views RSA Via Lifecycle and Governance/Aveksa server will not start after environment customization Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Release Notes for RSA Authentication Manager 8.8 RSA-2026-04: RSA Governance and Lifecycle Security Update for SUSE Linux Enterprise Server Vulnerabilities RSA Governance & Lifecycle 7.5.2 Administrator's Guide
Don't see what you're looking for?
