Slow response time on Activities page in RSA Identity Governance & Lifecycle
Last Modified: 2023-10-06
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
Slow response time on Requests tab in RSA Governance & Lifecycle Number of Views How to identify the source of a workflow email in RSA Identity Governance and Lifecycle Number of Views How to interpret the RSA Identity Governance & Lifecycle User Access Review User Entitlement Coverage report. Number of Views Slow INSERT statement executing from the SoD_Rule_Pkg in RSA Identity Governance & Lifecycle Number of Views Enable RADIUS on Identity Routers in a Cluster Number of Views
Trending Articles
How to Change the Token Lifetime Extension Window in Authentication Manager Using rsautil RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide Troubleshooting RSA MFA Agent for Microsoft Windows RSA SecurID Software Token for Microsoft Windows shows blank screen when asked to select a device where the token will be …
Don't see what you're looking for?
