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