My Oracle Support Banner

Demantra 11g Statistics new Features and Best Practices Gather Schema Stats (Doc ID 1458911.1)

Last updated on MAY 22, 2023

Applies to:

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

Purpose

 There are several useful improvements to 11i gather statistics technology.  Which are important and which are suitable to Demantra best database object performance?

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
 Overall 11g Recommendation (See below for details):
 
 
10g Complete gather statistics approach
 Extreme Cases 10g or 11g
 
11g Gather Statistics
 
Now You Can Manage the Largest Tables and Leave the Rest to Default
 Gathering Using Only DBMS_STATS.GATHER_*_STATS
 
Large Partition Tables Such as MDP_MATRIX and SALES_ORDERS

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