High CPU Usage In Database When Running The "Issue Audit Messages Task" Scheduled Task (Doc ID 1116858.1)

Last updated on SEPTEMBER 29, 2017

Applies to:

Identity Manager - Version 9.1.0.2 and later
Information in this document applies to any platform.
**Checked For Relevance 25-Jul-2013**

Symptoms

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:
select a.*
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)

Cause

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