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

0

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 "asktom.oracle.com" 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
  • DBMS_OBFUSCATION_TOOLKIT
  • DBMS_CRYPTO
  • Column Level Encryption
  • Tablespace Level Encryption 

Indexing

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

"Reorgs"

The main sections of this presentation are:

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

Enjoy the presentations and demo scripts.

 

Marco

 

Share.

About Author

Marco Gralike, working for AMIS Services BV as a Principal Oracle Database Consultant in the Netherlands, has experience as a DBA since 1994 (Oracle 6). Marco is also eager and skillful in other fields, like Operating System Administration and Application Servers, mainly to find working, performing solutions. Marco has been specializing in Oracle XMLDB, since 2003, focusing on his old love, database administration and performance. He is an Oracle XMLDB enthusiast ever since. He is also a dedicated contributor of the Oracle User Group community, helping people with their steep XMLDB learning curve. To this purpose, Marco also devoted his personal blog site to XMLDB and other Oracle issues. Marco is a member of the OakTable network and an Oracle ACE Director (specialization Oracle XMLDB).

Comments are closed.