HOTSOS 2K8 – A Training Day with Mr. Thomas Kyte

Reality is hard. While being back in Holland, work caught up with me. Instead of a full blown overview, I will present here a small one. No one posted about it yet and that would be a shame. Powerpoint presentations and demo scripts are really worthwhile so have a look.

The last day of the Hotsos symposium is the annual returning training day. This is an extra day, with also an extra fee involved, but if it fits your main interest, career path or else, is an fine add on to the main symposium. This year the training day was all about database essentials, "DBA content", demonstrated by Mr. Thomas Kyte. I would argue, though that this content is also very important for developers. Although general in its content, these are the building blocks every Oracle database user (DBA / Developer), should understand and/or know off. 

The presentations and SQL demonstrations can be found via the "" website, via the submenu "Files" and downloaded there. A short path is provided [here]. As Mr. Thomas Kyte said, the scripts and presentation can be freely distributed (because it is was in his intend that everyone should know this information). The presentation will lead you through the essentials of database functionality and more.

The Hotsos Training Day with Mr. Thomas Kyte involved:

  • Storage Techniques
  • Encryption
  • Indexing
  • Materialized Views and Caching
  • Reorganization

and in more general sense the "Mythology" around it (and incorrect "facts").

All topics were explained via an general outline of the feature, some demonstrations, and then the "do and don’ts" / restrictions.

Storage Techniques (Physical Schema Design)

The main sections of this presentation are:

  • Fundamental Schema Design Principles
  • B*Tree Clusters
  • Hash Clusters
  • Sorted Hash Clusters
  • Index Organized Tables
  • When to use what?
  • Partitioning
  • Compression
  • Compression (elsewhere in the database): SecureFiles, Data Pump, Backup and Network

My main interest here was Partitioning with its demonstrations of the new 11g "Interval" and "Reference" partitioning techniques, or more precise Equi-Partitioning by Reference. This will be available for XMLTypes as well in the next patch release of Oracle 11g and is an extra functionality to improve selectivity on XML data.

All About Encryption

The main sections of this presentation are:

  • Overview
  • Column Level Encryption
  • Tablespace Level Encryption 


The main sections of this presentation are:

  • Overview
  • B*Tree Indexes
  • — Structure
  • — Index Key Compression
  • — Reverse Key
  • — When should you use them…
  • Bitmap Indexes
  • — Structure
  • — Bitmap Join
  • — When should you use them…
  • Function Based Indexes
  • — About
  • — Use cases and caveats
  • Mythology and other interesting anti-facts and facts…

Materialized Views and Caching

The main sections of this presentation are:

  • Materialized Views
  • Materialized Logs
  • How to create
  • Query Re-write
  • Why constraints matter
  • Dimensions
  • Debugging
  • Interesting use case
  • Caching
  • — Client cache
  • — Server Result Cache (JIT-VW)
  • — PLSQL Function Cache


The main sections of this presentation are:

  • Goal
  • Mythology and other interesting anti-facts and facts
  • Reorganizing Tables
  • — ONLINE
  • — Entire Table
  • — Shrinking Space
  • — Purging
  • Reorganizing Indexes
  • — ONLINE
  • — Entire rebuild
  • — Coalesce

Enjoy the presentations and demo scripts.