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
Replicon - SAML SSO Agent Configuration - SecurID Access Implementation Guide Number of Views Recognize - SAML SSO Agent Configuration - SecurID Access Implementation Guide Number of Views RSA FIM error 'The specified role is not defined in Entity' Number of Views Recognize - SAML Relying Party Configuration - SecurID Access Implementation Guide Number of Views Netskope Security Cloud - SAML Relying Party Configuration - RSA Ready Implementation Guide Number of Views
Trending Articles
Troubleshooting RSA SecurID Access Identity Router to RSA Authentication Manager test connection failures RSA SecurID Software Token 5.0.2 Downloads for Microsoft Windows RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Governance & Lifecycle 8.0.0 Administrators Guide Quick Setup Guide - Passwordless Authentication in Windows MFA Agent for Active Directory
Don't see what you're looking for?
