My Oracle Support Banner

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

Last updated on JANUARY 30, 2019

Applies to:

Identity Manager - Version to [Release 11g]
Information in this document applies to any platform.


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.


To view full details, 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 a vibrant support community of peers and Oracle experts.