Striving for Optimal Performance
  • Blog
    • Archive
    • Categories
    • Search
  • Troubleshooting Oracle Performance
    • Description
    • Structure
    • Table of Contents
    • Forewords
    • Reviews
    • Downloadable Files
    • Addenda and Errata
    • First Edition
  • Public Appearances
    • Past Public Appearances
  • Contact
  • About

Edition-Based Redefinition (update)

4 December 2010 4 Comments Written by Christian Antognini

Last January I wrote a post with the following content:

Upgrading critical applications can be very difficult. One of the main problems is that for reasons of availability, long downtimes cannot be periodically scheduled. Therefore, for such applications, it is desirable to implement online upgrades. This requires that the application in question, as well as any software used by the application (e.g. the database engine) all support online upgrades. Oracle has recognized this problem for years. Unfortunately, up to and including Database 11g Release 1, only a limited number of features have been implemented for that purpose. As of Oracle Database 11g Release 2, this situation has changed greatly. With edition-based redefinition, Oracle Database offers real support for implementing online upgrades. The aim of the paper Edition-Based Redefinition, that I just put online here, is to provide an overview of this new feature.

I updated the aforementioned paper to provide information about the capability, as of 11.2.0.2, to specify a default edition at the service level. At the same time I added a note about the SHOW EDITION command.

11gR2
Oracle 11g Streams Implementer’s Guide
IS NULL Conditions and B-tree Indexes

4 Comments

3 Pings/Trackbacks

  1. Log Buffer #209, A Carnival of the Vanities for DBAs | The Pythian Blog Log Buffer #209, A Carnival of the Vanities for DBAs | The Pythian Blog
    13 December 2010    

    […] Antognini, recently updated his Edition-Based Redefinition paper about new feature of 11.2.0.2 to specify a default edition at the service […]

  2. Edition-Based Redefinition: My wish comes true once again « Neeraj Bhatia's Blog Edition-Based Redefinition: My wish comes true once again « Neeraj Bhatia's Blog
    14 January 2011    

    […] Edition-based Redefinition […]

  3. Neeraj Bhatia Neeraj Bhatia
    14 January 2011    

    Thanks Christian for the paper. Its nicely written and explained.

    I just posted on my blog about this.

    Cheers,
    Neeraj Bhatia (http://neerajbhatia.wordpress.com)

    Reply
  4. Log Buffer #209, A Carnival of the Vanities for DBAs Log Buffer #209, A Carnival of the Vanities for DBAs
    27 February 2013    

    […] Antognini, recently updated his Edition-Based Redefinition paper about new feature of 11.2.0.2 to specify a default edition at the service […]

  1. Log Buffer #209, A Carnival of the Vanities for DBAs | The Pythian Blog on 13 December 2010 at 05:33
  2. Edition-Based Redefinition: My wish comes true once again « Neeraj Bhatia's Blog on 14 January 2011 at 11:49
  3. Log Buffer #209, A Carnival of the Vanities for DBAs on 27 February 2013 at 15:09

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.