337: Understanding Oracle’s Histogram
Tony Jambu , Wizard Consulting Pty Ltd Biography
Objectives: | • Understanding of what a histogram is and is not • How to gather appropriate histogram data • Tuning with proper appropriate histogram data |
Abstract: | Oracle’s histogram is one of the most misunderstood and least used feature. On top of that, there are a number of myths regarding its use. This presentation will look under the cover of Oracle’s histogram. It will cover the basics e.g. from data distribution, density and cardinality to how to generate accurate histogram and tuning using histograms. For the experienced DBAs, we will be digging into the Oracle dictionary as well as analysing CBO’s trace files. |
Audiernce Focus: | Developers |
Expertise: | Beginner |
Track: | Database |
Date: | Tuesday, April 15, 2008 |
Time: | 1:45 PM - 2:45 PM |