How to Reduce Performance Impact of some AUD_JMS Queries (Doc ID 1182803.1)

Last updated on DECEMBER 01, 2014

Applies to:

Identity Manager - Version 9.1.0.0.0 to 9.1.0.2
Information in this document applies to any platform.
**Checked for Relevance on 07-Sep-2013**

Goal

To improve the performance of OIM by speeding up the most common select statement against the AUD_JMS table.

Refer to:

select min(aud_jms_key) as min_audjms
from aud_jms
where identifier=:1 and aud_class=:2


or the more general version:

select min(aud_jms_key) as min_audjms
from aud_jms
where identifier=? and aud_class=?

Solution

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