How To Reclaim Space For Overgrown/Huge Footprint Of LOB Columns In OIM Database
Last updated on APRIL 30, 2018
Applies to:Identity Manager - Version 22.214.171.124.0 to 126.96.36.199.0 [Release 11g]
Information in this document applies to any platform.
One can come often across scenarios where the snapshots(LOB) related data are either already very big in size or or is growing at very rapid rate in OIM. For example: the DB size is only 18GB but the Snapshot is 288GB and one would like to delete selective old snapshots from UPA table in order to get rid of snapshots that are not needed.
In these type of scenarios one can often see another issue of "once we delete these rows the lob space being used is not turned into free space" and often ask "Please advise what is this best way to clear out this space once we delete rows in UPA etc tables"
This article will advise on how to do the shrink operation to claim the free LOB space.
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