What to do when ODI Purge Job Is Not Purging The Processed Records (Doc ID 2191043.1)

Last updated on SEPTEMBER 26, 2017

Applies to:

Oracle Knowledge - Version 8.5.1 and later
Information in this document applies to any platform.

Goal

How do we purge data when the table has gotten too big and the purge is taking too long to run or does not appear to be running after a long period of time?

When the staging data gets too large the delete of the data can take a long time and require a lot of resource.  In this case the DBA can delete some of the data in smaller batches.

Some other helpful information to control the size of the staging data is to eliminate data that is not used in the reports.  There is no need to capture this data.

Why Is The Oracle Knowledge Analytics DW_STG_DATA Table Populated With Many Unused Events? (Doc ID 1667341.1)
 

Solution

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