High CPU Usage In Database When Running The "Issue Audit Messages Task" Scheduled Task
(Doc ID 1116858.1)
Last updated on OCTOBER 03, 2018
Applies to:Identity Manager - Version 188.8.131.52 and later
Information in this document applies to any platform.
**Checked For Relevance 25-Jul-2013**
There is a high CPU usage in the Database when the "Issue Audit Messages Task" scheduled task is run.
Query samplel that is causing issue:
from UPA_UD_FORMS a, UPA_RESOURCE b
where a.SDK_KEY = 24 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)
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