If you manage Oracle Identity Manager (OIM – is Identity Management and Account Provisioning Software and is part of Oracle Identity Manageemnt Suite) and if you see OIM database growing then this post is for you. This post covers, type of data in OIM database  (OIM purge in detail to follow soon).

In Oracle Identity Manager (OIM) there is mainly four type of data

a) Reconciliation Data (Reconciliation Events): During reconciliation, reconciliation manager reconciles data in reconciliation tables (RECON_%, RA_%) . This data is not cleared from reconciliation tables automatically and you must purge/archive these tables periodically.

b) Task Data : Task data refers to activities that make Provisioning Process (OSI, OSH, SCH). This data is not cleared from reconciliation tables automatically and you must purge/archive these tables periodically.

c) Platform Data : Data for Orchestration Events or Context Data is referred as Platform Data and is stored in table ORCHPROCESS, ORCHEVENTS, CONTEXTCONTEXTVALUE. There is schedule task “Orchestration Process Cleanup Task scheduled task” to delete completed Orchestration Process . However, this task does not delete Orchestration Process that are not yet complete . More on how to purge OIM Orchestration Events whose status is not COMPLETE in next post.

d) Request Data : Requests in OIM are stored in database in tables REQUEST%, WF_INSTANCE. The data in these tables must be purged regularly for better performance.

This information is covered in OIM documentation here

You must also look at Oracle Support Note # 1331331.1 Using the Audit Archival and Purge Utility for OIM(Oracle Identity Manager)