11gR2 – My Top Ten List of Interesting New Features

Well it’s been a few weeks since Oracle made 11gR2 available for general use. After looking through the new features document, I made a short list of new features that I thought would be worthy of further investigation. As I spent a little time looking at them though, there turned out to be very little that was all that exciting. There were a couple of exceptions, but for the most part it seems that Oracle concentrated on stability rather than drastically new features. That’s not necessarily a bad thing and is probably an indication of the product (and the development process at Oracle) maturing. Nevertheless, here are a few things that I think are interesting:

  1. Edition Based Redefinition – Rolling out new code that requires schema changes has always been a challenge. Keeping up with the changes, providing a mechanism to roll them back if things don’t go well, and allowing some code to continue to work as is, instead of having to change every single piece of code that accesses a changed object – these are a few of the challenges that come along with making schema changes. It’s a bit a chicken and egg thing. One way to mitigate the risk of these types of changes has been to use views to provide an abstraction layer that allows the code to be changed over time as opposed to the big bang approach of all code that accesses an object being forced to change at the same time. Edition Based Redefinition is designed to allow Oracle to manage that complexity via a new thing called an Edition. It’s pretty cool and in my opinion is hands down the best new feature of 11gR2.
  2. File Watcher – The job scheduler has been enhanced to be able to monitor a directory and kick off a job when a file shows up. No more writing the same shell script over and over.
  3. Stored Outline Migration – There is now a utility to migrate Outlines into 11g’s SQL Plan Management framework. This feature may actually be useful for migrating from older versions of Oracle directly to 11g. It basically converts Outlines to Baselines.

And here’s the list of things I initially thought might be interesting but that I have really not warmed up to (yet anyway).

  1. Instance Caging – Putting multiple instances on a single machine is attractive from a licensing standpoint but can cause problems from a performance perspective. Instance caging is a new feature for controlling the amount of resources (CPU) that an instance can use. It is a good idea; however, there are already numerous options available from most of the major hardware vendors that can accomplish the same thing (think AIX LPARs, Solaris Zones/Containers, HPUX vPars, etc…).
  2. ACFS – A true clustered file system? This one may be more interesting after I get a chance to play with it more, but come on, file systems just aren’t that exciting.
  3. ASM FS Snapshot – Snapshoting capabilities have been added to ASM. Looks like an attempt to compete with the SAN guys. There are lots of people that use Snapshot technology for backup and disaster recovery scenarios, so maybe this will grow on me as well.
  4. OCR Enhancements – OCR files may be stored in ASM, ho hum. At least we don’t need a separate Lun.
  5. Cluster Time Service – There have been problems with RAC nodes getting evicted because of clock drift. But there are other ways to deal with this (NTP for example). But this is a nice addition, just not that interesting.
  6. Segment Creation on Demand – No need to pre-build segments. Maybe useful by saving some storage for a while. But presumably you’ll be needing the space eventually or you wouldn’t have built the objects in the first place. Delaying the allocation of space just seems to me like an opportunity for a user to get an error when dynamic allocation of space occurs “automatically”. I think I’d prefer to do it ahead of time in most cases.
  7. Hybrid Columnar Compression – This feature is actually very interesting. It has been hyped a little as Column Oriented Storage, but is in fact simply a compression technique (see Kevin Clossan’s post: Oracle Switches To Columnar Store Technology ). It may be highly effective though as the compression possibilities provided by column oriented storage models are a big part their advantage. Unfortunately, the fact that it’s only available as part of the Exadata storage hardware, means it is not going to be very widely applicable unless the Exadata product really takes off.

Anyway, that’s my thoughts on 11gR2 so far. I really don’t mean to be negative. I like getting my hands on new toys as much as the next guy, but I do believe that concentrating on improving stability and incremental performance gains is absolutely the right approach. It looks to me like Oracle has made a change to a more mature and disciplined development / release model. And I think that’s a good thing.

Let me know if you have another favorite new feature that I may have overlooked.


  1. Yas says:

    Hi Kerry,

    I think 11GR2 brings many exciting new features. Especially for RAC there are lots of interesting stuff that I think this release might be named 12g. Have a look at Rac OneNode, GNS and SCAN. These are very promising.

  2. Nice list Kerry,

    It’s probably just me being an antsy dba type, but I do have trouble with the Edition thing -just like I have trouble with the whole multiple versions of the same library in application/os development.

    I can on the other hand see great potential for the don’t preallocate storage feature since I see soooo many tables in COTS apps with large numbers (many thousands) of tables that are there for features of the app that won’t be used.


  3. Noons says:

    “presumably you’ll be needing the space eventually or you wouldn’t have built the objects in the first place”

    Can you please explain that to the Peoplesoft, JDE and SAP developers, pretty please?
    Because their 25000 empty tables and 32000 empty indexes sure don’t know about it…

  4. osborne says:

    OK, OK, I’ll concede that deferred segment creation is probably going to be useful in the COTS world. I hadn’t actually thought about that. Noons, who should I tell at SAP to not create tables unless they are actually going to use them? 😉

    I do think the Editions thing holds great promise, but also great potential for misuse. It reminds of when Role based privileges were rolled out. For a couple of years I kept seeing these horribly complex security models using several layers of Roles granted to Roles granted to Roles. But hopefully we’ll see Editions used with a little common sense. The ability to easily isolate a particular release and non-destructively roll back the changes with a single command, all in a standardized way sounds like a God send to shops that are doing active development.


  5. osborne says:


    You are right, cluster-ware has changed significantly. One Node is interesting. Sounds like they (Oracle) are trying to take a bite out of Veritas’ pie. Clusterware has had the ability to automatically fail-over a stand alone instance for a while (albeit a manual scripting exercise). We actually had a client evaluating using it instead of re-upping Veritas support (which was a very hefty bill). It will be interesting to see if this “productization” takes off.

    Although I’ve worked on a lot of RAC systems, configuring the clustering components are really not my strong suite (i.e. I’ve never actually done it). So I am probably not as appreciative of the advances in that area as I should be. Thanks for your comments.


  6. Michael Fontana says:

    Very interesting perspective. I just did a recent install, and even that process seems more refined.

    Here are my favorite esoteric but useful new features so far: Oracle Universal Installer Support for Removing Oracle RAC Installations Improved Deinstallation Support With Oracle Universal Installer

    These can be huge time-savers for RAC and GRID installations. It is sometimes impossible to know of an issue until an install is attempted. It is often quite
    difficult to clean up. Many Oracle internal articles have been written to cover problems with failed installs. This should hopefully address most of them.

  7. Martin says:

    Seems like nobody likes or notices the Oracle Restart feature 🙂 I found that along with the CRS (“Grid Infrastructure”) changes amongst the most interesting new features for 11.2.

    Managed service providers can finally roll out one simple method for starting single instance Oracle across all customers, rather than having to worry about the init scripts for HP-UX, Linux, Solaris (10)…

    I’m not believing in the RAC One Node thing, there seem to be other (more cost effect) solutions to do similar things-to a degree. Steve Shaw gave an interesting presentation about Oracle VM & OCFS2 at the last UKOUG RAC & HA SIG and so did I some time ago.

Leave a Reply