Advanced Partitioning with Martin Jensen (HR) September 13, 2010

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.

For more details on the event please check out the event's webpage: http://bit.ly/Martin_Jensen_HR_fe_October2010