OIM 11gR1 PS1: Heavy Data Growth Seen During Target Recon In Recon_Account_Oldstate Table (Doc ID 1512702.1)

Last updated on OCTOBER 25, 2015

Applies to:

Identity Manager - Version 11.1.1.5.0 and later
Information in this document applies to any platform.
**Checked for Currency on 25-July-2014**

Symptoms

OIM11gPS1 has a new design target reconciliation based on DB XML approach because of which one may see heavy growth in RECON_ACCOUNT_OLDSTATE table for target reconciliation. Target recon may consume huge disk space which causes shortage of tablespace space in the environment.

This may impact DB machine badly not only in terms of space consumption but also badly affect performance while running target recon especially when DB is in archive log mode which results in big archive logs.

Affected Release:

This issues has an impact on all the OIM 11gPS1 environment i.e. 11.1.1.5.X

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