High CPU Usage In Database When Running The "Issue Audit Messages Task" Scheduled Task
(Doc ID 1511351.1)
Last updated on OCTOBER 03, 2018
Applies to:Identity Manager - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
**Checked for Relevance on 25-Jul-2014**
Following query from OIM is consuming high CPU :
FROM upa_ud_forms a, upa_resource b
WHERE a.sdk_key = 12
AND b.oiu_key = :1
AND a.upa_resource_key = b.upa_resource_key
AND upa_ud_forms_key = (SELECT min(upa_ud_forms_key)
FROM upa_ud_forms c
WHERE c.upa_resource_key = b.upa_resource_key
AND c.sdk_key = a.sdk_key)
As instructed by <Document 1116858.1> , an index on OUI_KEY columns was already created, but it did not solved the issue.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document