New density calculation (Oracle Database 10g to 11g Change)

posted Sep 24, 2010, 9:21 AM by Sachchida Ojha

There is a new algorithm to calculate density in Oracle Database 11g when histograms are present on the columns. This shows up in the 10053 traces as NewDensity.  This will affect cardinality ESTIMATE calculations. The NewDensity is not stored in the data dictionary.  The old density values are stored in data dictionary.  NewDensity is calculated at run time.