Advanced Partitioning with Martin Jensen May 11, 2009

At first sight table-partitioning seems very simple, but when an actual table need 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 how to change existing database tables to be partitioned, how read-consistency work 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/eY9zJM