My Oracle Support Banner

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:

  1. Create about 300,000 rows per week on SUBCLASS_SALES_HIST table. 
  2. Save off the oldest week's worth of data.
  3. Run HSTPRG.PC.
  4. Note the runtime. 
  5. 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

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