Advanced Partitioning with Martin Jensen November 19, 2009

At first sight table-partitioning seems very simple, but when an actual table needs to be partitioned, a number of alternative strategies may be used, with different consequences on performance, availability, backup and restore. This seminar will discuss and show some of the more difficult aspects of partitioning - hard to locate in the manuals. We will show you how to change existing database tables to be partitioned, how read-consistency works together with exchange-partition, various special cases from new partition possibilities in 11g, block-compression, and how Materialized views may benefit from partitioning.

The seminar will also discuss how ILM (Information Life-cycle Management) may help to implement a cost-effective archival strategy, and include some known availability issues.

Official Website: http://cli.gs/3UBAAU