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://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D70365_1076223&p_org_id=34&lang=D
Attendance cost: € 737
Event Organizer: Oracle University