HSTPRG Performance Issue
(Doc ID 1670625.1)
Last updated on MARCH 01, 2019
Applies to:Oracle Retail Merchandising System - Version 13.2.5 to 13.2.9 [Release 13.2]
Oracle Retail Merchandising System - Version 16.0 and later
Information in this document applies to any platform.
Pro*C program Purge Aged Sales History runs slow with large volumes.
Steps To Recreate:
- Create about 300,000 rows per week on SUBCLASS_SALES_HIST table.
- Save off the oldest week's worth of data.
- Run HSTPRG.PC.
- Note the runtime.
- Restore the data that was just purged.
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