My Oracle Support Banner

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

Last updated on MARCH 27, 2019

Applies to:

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


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)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.