How to Tune Oracle 12c SQL with Histograms

Histograms are essential ingredient of Tuning SQL in the Oracle Database.  In Oracle 12c there are new features related to Histogram.  In this histogram tutorial, Oracle Certified Master John Watson describes the importance of histograms, the new features in Oracle 12c and demonstrates how to use histograms.

Primer: Histograms collect essential statistics such as data skew and thus accurately predict how many rows a predicate will select.  This impacts critical decisions such as join order, join method and access method.

This free training is segmented into several separate lessons:

  1. Part 1 – The Importance of Histograms (1:28) (click on video below)
  2. Part 2 – Oracle 11g and 12c Histograms (12c New Features) (1:54)
  3. Part 3 – The Histogram Demonstration! (6:01)
  4. Part 4 – Wrap-Up, Conclusions and Advice! (1:13)

Date: Jan 8, 2016


NOTE: Some corporate firewalls will not allow videos hosted by YouTube.

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!

 

×