About the Offline Data Purge Framework
The Offline Data Purge Framework helps to purge huge volume of data sets in fewer iterations.
Using the Offline Data Purge Framework, you can purge non-purgeable data, for example, data that is in In-Progress status for Oracle Identity Governance entities such as Reconciliation, Provisioning Task, and Orchestration.
Oracle recommends using this framework in the following situations:
-
When you have not executed the default Online Data Purge scheduled task, and accumulated huge volume of purgeable data
-
When you want to purge non-purgeable data for Oracle Identity Governance entities: reconciliation, provisioning task, and orchestration
-
When you want to run the default scheduled task for online data purge, but the volume of purgeable data is exceptionally high
-
When you want to purge all data for Oracle Identity Governance entities, reconciliation, provisioning task, and orchestration, based on retention period
Some of the key features of the Offline Data Purge Framework are:
-
The Offline Data Purge Framework is disabled in Oracle Identity Governance by default.
-
The Create Table As Select (CTAS) approach is used to purge data and also auto-reclaims storage space for the purged data set.
-
The Offline Data Purge Framework supports data purge based on Oracle Identity Governance entity type, purge criteria, and purge retention period.
-
The Table -16 lists the purge criteria (based on purge retention period) that are supported for the Oracle Identity Governance entities.
Table -16 Supported Purge Criteria for Oracle Identity Governance Entities
Entity Purgeable Events Non-Purgeable Events All Data Reconciliation Event Closed, Creation Succeeded, Update Succeeded, and Delete Succeeded
ALL events except the Purgeable Events
Yes (based on retention period)
Provisioning Task Completed and Cancelled
NA
NA
Orchestration Completed, Failed, Cancelled, Compensated, and Cancelled_With_Compensation
ALL events except the Purgeable Events
Yes (based on retention period)
-
You can perform the offline data purge operation by running the Oracle DBMS scheduler job.
-
The Offline Data Purge Framework uses the existing PL/SQL diagnostic logging and debugging framework to track the progress of the offline data purge operation.
-
The summary and detailed information for the offline data purge operation is captured in two separate diagnostic logging tables, DIAG_LOG and DIAG_LOG_DTLS.