My Oracle Support Banner

Rebuild_Schema procedure - One of the Keys to Improved Demantra performance (Doc ID 860576.1)

Last updated on JULY 08, 2020

Applies to:

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

Goal

Since the Demantra back end sits on a Relational Database (most times Oracle, but some clients do run SQL Server), keeping that Database healthy will help to ensure the optimal performance when it comes to elements such as Data Loading, Caching of Worksheets, Workflows, running the Demantra Forecast Engine, etc.

Clients should ensure that tables and indexes in the Database suffer from as minimun Fragmentation (Chaining) of rows as possible and that the latest Stats have been generated on these objects.

When submitting a performance related Service Request (ex. My Worksheet is slow, my Engine run is slow, etc.) to the Oracle Demantra support team, the first piece of information we will request is for you to run the following sql on the Demantra schema:

  

This sql will allow us to assess the fragmentation, chain_cnt column as a percentage of the num_rows column and Statistics freshness which is a product of the last_analyzed column as well as the sample_size column versus total row count in the num_rows column.

Solution

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
Goal
Solution
 Why is this procedure important?
 What does this procedure do?
 What is the TABLE_REORG Procedure?
 How do I execute this Rebuild_Schema procedure? 
 What privileges and grants does my Demantra Schema user need to run this procedure?
 What if after I run this procedure I still have Fragmented / Chained Rows?
 How often should I run this procedure? 
 WARNING
 How long does it take to run?
 Which Clients should Not run this procedure?
 My DBA doesn't approve of this procedure
 Does Rebuild_Schema support Partitioned Tables?
 What if I run Demantra on SQL Server?
References

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