Top 10 Oracle 11gR2 New Features
September 9th, 2009
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.
- Analytic Functions 2.0
- Recursive WITH Clause
- Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
- In-Memory Parallel Execution
- Auto Degree of Parallelism (Auto DOP) and Parallel Statement Queuing
- Significant Performance Improvement of MV On-Commit Fast Refresh
- Database Resource Manager Instance Caging
- ASM Intelligent Data Placement
- Database File System (DBFS)
- 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.
Trackbacks
Comments
thanks for pointing these out – the syntax stuff is really cool. I like the recursive WITH, FIRSTAGG, and NTH_VALUE…
What about editions?
http://www.oracle.com/technology/deploy/availability/pdf/edition_based_redefinition.pdf
Regards Erik
@Erik
I think Edition-Based Redefinition looks like a extremely useful feature for OLTP databases, however, I spend my days working on DW databases so I am slightly biased in that direction.
@Erik
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.
@jason arneil
Have you looked at Online Data Reorganization & Redefinition? Seems to me the two features could be used together to address this challenge.