Top 10 Oracle 11gR2 New Features

In catching up on blog posts I see that Jonathan Lewis, Christian Antognini and Nuno Souto picked up on the deferred segment creation new feature in Oracle 11gR2. In keeping with the theme, I thought I’d put together the top 10 new features in Oracle Database 11g Release 2 (11.2) that I consider significant.

  1. Analytic Functions 2.0
  2. Recursive WITH Clause
  3. Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
  4. In-Memory Parallel Execution
  5. Auto Degree of Parallelism (Auto DOP) and Parallel Statement Queuing
  6. Significant Performance Improvement of MV On-Commit Fast Refresh
  7. Database Resource Manager Instance Caging
  8. ASM Intelligent Data Placement
  9. Database File System (DBFS)
  10. Hybrid Columnar Compression

In future posts I’ll dive into some of these in more technical detail but for now I thought I’d throw my list out there to raise awareness of the things I am looking at as a database performance engineer.


  1. Pingback: Oracle Infogram: 11gR2 RDBMS and OWB, Hyperion, EBS, Security, RDBMS Internals, Cloud Storage
  2. jason arneil

    Big flaw in editions is that tables are not editionable, which is a real shame as my developers have a nasty habit of refactoring tables during their monthly release – and of course ensuring my downtime pain will continue.

  3. Pingback: 11gR2 « Oracle Scratchpad
  4. Pingback: Entradas de Oracle semanas 35-37 « Gruñidos sobre Oracle y SAP
  5. Nilesh Bari

    Top 10 (significant) new features in Oracle Database 11g Release 2 (11.2).. are these NEW in 11gR2 on top of 11gR1?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s