Last updated on OCTOBER 07, 2016
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms