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