Oracle Scratchpad

September 1, 2013


Filed under: Histograms,Oracle,Statistics — Jonathan Lewis @ 9:41 am BST Sep 1,2013

A three-part series on histograms up to and including 11g – written for Allthings Oracle. With Chinese transalation:

And a three part series on histograms in 12c on this blog

A short video recorded at RMOUG 2013 about the improvements in Oracle’s histogram mechanisms as you upgrade from 11g to 12c.

Update (Jan 2016):

A pair of articles by Mohamed Houri, published on adding discussing details of the mechanisms and selectivity calculations for 12c histograms:



1 Comment

  1. Part three has just been published on AllThingOracle (Link in the article).

    Comment by Jonathan Lewis — October 16, 2013 @ 5:17 pm BST Oct 16,2013

RSS feed for comments on this post.

Website Powered by

%d bloggers like this: