My Oracle Support Banner

Demantra Scalability - Increasing the Throughput and Capacity (Doc ID 1232333.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Purpose

After reviewing this document the reader should be able envision a road map to scaling Oracle Demantra.   There are several key areas that require review and planning.

Questions and Answers

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
Purpose
Questions and Answers
 Scalability in Demantra involves hardware, disk, RDBMS data store, forecasting engine.
 EP_LOAD_SALES Latest Performance Improvements
 Forecasting Engine
 Performance and Scalability: Usage of Database (SQL) Hints, Parallelism and Other Methods
     Parameter: Ep_Load_ItemsUseParallelDML
     Parameter: Ep_Load_ItemsUseParallel
     Parameter: Ep_Load_ItemsUseOneCommit
 Scalability in the Work Sheet
 How many cells are in the crosstab?   Sample config:
 RDBMS Data Store Index Adviser Overview
 Extending Batch Load Process
 Extend Proport to Run In Parallel mode
 Load Programs Performance
 Oracle Partitions
 Application Server
 Oracle RDBMS
References

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