As Published In
Oracle Magazine
November/December 2009

From the Editor

Do the Math

By Tom Haunert

It’s easy to measure the benefits of Oracle Database 11g Release 2 and Oracle Exadata V2.

September 2009 was a big month for Oracle announcements. On September 1, Oracle announced the general availability of Oracle Database 11g Release 2, and on September 15, Oracle and Sun Microsystems unveiled Oracle Exadata V2 and the Sun Oracle Database Machine. Both announcements came with some noteworthy numbers.

Oracle Database 11g Release 2

The mission of Oracle Database 11g Release 2 is to lower IT costs and deliver a higher quality of service by consolidating business applications onto low-cost database grids, maximizing availability and eliminating idle data center redundancy, compressing data onto low-cost storage partitions for faster performance, and increasing DBA productivity. See “Consolidate. Compress. Control.” for information on how Oracle customers and partners are using Oracle Database 11g Release 2 to do more and cut costs.

I sat down with Andy Mendelsohn, senior vice president of Database Server Technologies at Oracle, to discuss the challenges that Oracle customers are facing today and how Oracle Database 11g Release 2 can help. In that interview, “Better for Business” (, Mendelsohn talks about new features in the release, including Edition-Based Redefinition, Oracle Real Application Clusters One Node, and Deferred Segment Creation, but he also measures the benefits of the release. According to Mendelsohn, Oracle Database 11g Release 2 can help


  • double DBA productivity

  • reduce server costs by up to a factor of 5

  • reduce storage costs by up to a factor of 10

In this issue’s AskTom column, “Looking at the New Edition,” Tom Kyte touches on a handful of interesting features in Oracle Database 11g Release 2, including Oracle Data Guard block-level recovery and standby query offloading, Edition-Based Redefinition, enhancements to parallel execution, analytics, EXECUTE privilege for directory objects, recursive subquery factoring, flashback support for DDL, Oracle Scheduler enhancements, and Oracle Data Pump legacy mode. (Kyte will also be covering key features in depth in upcoming issues.)

Oracle Exadata V2 and the Sun Oracle Database Machine

Announcing Oracle Exadata V2” introduces Oracle Exadata V2 and the Sun Oracle Database Machine. (We’re also planning a customer feature story on how customers are using and benefiting from this technology for an upcoming issue.)

The Sun Oracle Database Machine is the world’s fastest for any type of database workload, and it is a complete package of software, servers, storage, and networking. Oracle Database 11g Release 2 and Oracle Real Application Clusters run in the database servers, and Oracle Exadata Storage Server Software runs in the storage servers.

With Oracle Exadata V2, new software and hardware work together to deliver extreme performance. Oracle Exadata Smart Flash Cache leverages Sun’s FlashFire technology for faster query and scan performance, and the new hybrid columnar compression capability, part of the Oracle Exadata Storage Server Software, enables organizations to store more data and search it faster.

Next Steps

LEARN more about
 Oracle Database 11g Release 2
 Oracle Exadata V2
 Sun Oracle Database Machine

At the unveiling of Oracle Exadata V2 and the Sun Oracle Database Machine, Oracle CEO Larry Ellison introduced the first database machine that does online transaction processing (in addition to data warehousing) and provided information on the performance of Oracle Exadata V2:


  • Oracle Exadata V2 is twice as fast as Oracle Exadata V1 for data warehousing.

  • Oracle Exadata V2 can execute more than 1 million random I/Os per second.

Remarking on the random I/Os per second at the unveiling, John Fowler, executive vice president at Sun, offered that 1 million random read I/Os per second had never been achieved in a single machine before Oracle Exadata V2 and the Sun Oracle Database Machine.

The Business of Oracle OpenWorld 2009

From October 11 through 15, Oracle OpenWorld 2009 in San Francisco is serving up more than 1,800 sessions, 400 partner exhibits, keynotes, hands-on labs, and several special networking events—all to help you get the maximum business benefit from your technology.

Tom Haunert, Editor in Chief

Send us your comments