355: Maximizing Availability with Online OLTP Schema Updates
Kenneth Seewald , Verisign Corp.    Biography

Objectives: How to test and certify DDL commands as ?Online? for a target environment
Provide guidance/recommendations to assist in planning schema changes ?Online?
Review pros and cons in using the Oracle RDBMS_REDEFINITION package
Abstract: A critical aspect of meeting stringent availability requirements for OLTP systems is ensuring that there exists an elegant, low-risk means of deploying database schema changes while the DB remains active (or at least with a minimal amount of planned downtime). These changes include altering existing schema objects and stored procedures as well as creating new objects and procedures.

The presentation will examine several techniques to perform as much of the schema update work as possible online both before and after an outage window. Several real world cases will demonstrate how these techniques have been used to successfully minimize/eliminate outages.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Database
Date: Tuesday, April 15, 2008
Time: 4:45 PM - 5:45 PM