HSTPRG Performance Issue (Doc ID 1670625.1)

Last updated on JULY 11, 2017

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.

Symptoms

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.

 



Cause

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