Tuesday, September 1, 2009

Oracle 11g R2 - What is new?

Today Oracle 11g R2 was released. It is interesting to note that Linux version is the first to be out as usual, even though Oracle is on verge of owning Solaris OS. Sun and Windows version are expected later this year. The timing is good, it's about 1 1/2 months to Oracle Openworld. I am sure the 11g R2 related session will be a good draw.

So what's new in this release:

1) Enhancements to Real Application Cluster, Oracle RAC One Node option is now available for relatively less critical systems. The ASM get's a face lift with intelligent data placement leading to better retrieval rate for data.

2) Advanced data partitioning to allow more online application upgrades.

3) One of the Exadata related feature is called “Warehouse” Compression and is based upon Exadata Hybrid Columnar Compression. This technique delivers a typical compression ratio of up to 10:1 for data warehouses, with virtually no negative impact on query performance, per Oracle. The "archive" compression can get 40:1 compression factor.

The 11gR2 documentation is here.


Shyam Varan Nath said...

More on 11G R2 features by Robert Stackowiak:

steven said...

Awesome project, Mel! Wow! I love your idea with new use of digi-images! Thank you for sharing tutorial, templates and your wonderful inspiration! more templates easy to download