325: Managing Partitioned Objects can be a Nightmare
Michael Abbey , Ntirety LLC    Biography

Objectives: Familiarity with how Oracle stores partition metadata
How to avoid invalidating global indexes while doing partition maintenance
An approach to partitioning existing objects with minimal downtime
Abstract: This presentation will look at a nifty way to partition existing objects then discuss partition maintenance issues and the smart ways to manage partitioned objects. Naming conventions, once adopted, can reduce the time dedicated to managing these pesky objects. What with a plethora of more automated management techniques in 11g, the DBA still needs to be fluent in management opportunities and roadblocks.

Savvy DBAs take the time to investigate and map out partition management as part of the setup phase. This way they do no get blind-sided by syntactical and logical roadblocks as the data volumes in the partitioned objects grow and grow and grow and grow and ...

Audiernce Focus: DBA
Expertise: Intermediate
Track: Database
Date: Tuesday, April 15, 2008
Time: 9:45 AM - 12:00 PM