Advanced Partitioning with Martin Jensen (DE)
Dusseldorf, Germany
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. Read more »
RMAN is now undoubtedly the best backup method for Oracle databases right now. This session starts with the basics of RMAN but quickly moves on to the intermediate to advanced topics.
RMAN is now undoubtedly the best backup method for Oracle databases right now. This session starts with the basics of RMAN but quickly moves on to the intermediate to advanced topics.
In this session the speaker, a DBA of 14 years explains when you decide partitioning for tables and indexes, which partitioning options to choose depending on the problem you are trying to solve – purge, performance, archival, backup or whatever else; potential issues to watch out for and so on.