High CPU Usage In Database When Running The "Issue Audit Messages Task" Scheduled Task
Last updated on SEPTEMBER 29, 2017
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms