Back To Schedule
Wednesday, April 17 • 10:00am - 10:45am
When Smart Scan Plays Dumb, Teach Exadata Some New Tricks (P65)

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Exadata Database Machine offers incredible query performance improvement opportunities via its suite of Smart Scan features … except when it doesn’t seem very “smart” at all! Join Oracle DBA and Oracle University instructor Jim Czuprynski as he demonstrates why Smart Scan sometimes decides to “play dumb” and how to make it respond properly to your commands to “play smart” instead.


This session will:

- Demonstrate how Smart Scan typically reduces query execution time

- Identify why Smart Scan sometimes has no choice but to “play dumb” and use normal retrieval methods instead of using storage indexes, full table scans, or fast full index scans

- Explore how to resolve these issues by helping Smart Scan to raise its “query IQ” whenever possible


1. Smart Scan: Exadata’s “Secret Sauce”

    a. Smart Flash Cache

    b. Storage Indexes

    c. EHCC

2. Did Smart Scan really happen?

3. Why doesn’t Smart Scan get used all the time?

    a. Banned Objects

    b. “Small” Tables and Serial Direct Reads

    c. Indexes and Histograms

    d. Contending Workload Profiles

4. Helping Smart Scan To “See Better”

5. Conclusions


avatar for Jim Czuprynski

Jim Czuprynski

Zero Defect Computing, Inc.
Jim Czuprynski has accumulated over 30 years of experience during his information technology career. He has filled diverse roles at several Fortune 1000 companies in those three decades - mainframe programmer, applications developer, business analyst, and project manager - before... Read More →

Wednesday April 17, 2013 10:00am - 10:45am CEST
5. Lofoten SAS Hotellet