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.
- 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.
[...] Here are some of the funnest bells and whistles to tweak, courtesy of the Structured Data blog:Top 10 Oracle 11gR2 New Features11gR2 OWBOver at the Rittman Mead Consulting blog there is a series about OWB 11gR2 and BI EE. 11gR2 [...]
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.
[...] 11th Sept: I see that Greg Rahn has listed his top 10 – the parallel stuff looks as if it might be interesting, and “instance caging” [...]
[...] Greg Rahn: Top 10 Oracle 11gR2 New Features [...]
@jason arneil
Have you looked at Online Data Reorganization & Redefinition? Seems to me the two features could be used together to address this challenge.