My Oracle Support Banner

Demantra Forecasting Engine Hanging Creating Millions Of Rows In Table SALES_DATA (Doc ID 454920.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.1.1 and later
Information in this document applies to any platform.

Symptoms

Users are running the Demantra Batch Forecasting Engine.  However it is encountering a severe performance problem and is not completing as tablespaces and logs are filling up rapidly.  There are 19 million rows in Sales_data table when they were expecting only 250,000.  On a separate laptop install, the engine runs in 17 minutes and completes successfully with similar data.  When checking the data in the sales_data table in the laptop install there are only about 250,000 rows. Users state they only have 2 years of historical demand.


STEPS
1. Launch the batch forecast analytical engine
2. It hangs while inserting into the sales_data table
3. Review log file sizes and table sizes

Cause

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
Symptoms
Cause
Solution

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