OIM Administrators : Is your OIM database Growing ? Do you purge enough ?

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)

 

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Oracle Gold Partner specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

2 comments
Prasad says April 2, 2014

Atul,

This is true in our case.. Can you please let me know how you have dealt with
“More on how to purge OIM Orchestration Events whose status is not COMPLETE in next post”

waiting for you next post. Can you let me know

Thanks gain for your post.

Regards
Prasad

Reply
Isha says July 17, 2015

Hi Atul,
Can you explain “how to purge OIM Orchestration Events whose status is not COMPLETE”? You mentioned about explaining that in next post.

Thanks,
Isha

Reply
Add Your Reply