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 |