An Oracle White Paper February 2011 Lowering Your IT Costs with Oracle Database 11g Release 2

Lowering Your IT Costs with Oracle Database 11g Release 2 INTRODUCTION As business operations become more complex, the demand for change in IT increases accordingly, as do the associated risks that must be mitigated. Today’s IT professionals are asked to manage more information and deliver it to their users, with ever-increasing quality of service, in a timely manner. And in today’s economic climate, IT must also reduce budgets and derive greater value out of existing investments. Oracle Database 11g Release 2, the latest release of the award-winning Oracle Database 11g, enables IT professionals...

Lowering Your IT Costs with Oracle Database 11g Release 2 REDUCE HARDWARE COSTS “We’ve been able to save over US$5 million dollars a year by re-platforming from our mainframe to Oracle Real Application Clusters.” Eugene Park, Senior Director of Platform Services PG&E Reduce Hardware Costs Through Consolidation Most datacenters today are a mishmash of hardware and software that have evolved over time to meet individual business requirements. Datacenters typically consist of a variety of server and storage silos, plus a complex software portfolio to integrate everything together. Mixed datacenter...

Lowering Your IT Costs with Oracle Database 11g Release 2 expensive scale-up SMP servers, customers can simply scale-out their database cluster at a low incremental cost by adding more commodity servers. Consolidate All Data Processing onto Low-Cost Private Clouds Oracle Real Application Clusters (Oracle RAC) enables a cluster of low-cost commodity servers to work together as a single shared database grid or private cloud. Applications can then be deployed without modification to provide the benefits of consolidation, higher availability, faster performance, and scalability on demand. Because...

Lowering Your IT Costs with Oracle Database 11g Release 2 Reduce Time to Market with Oracle Exadata Database Machine Many Oracle customers build their own grids or private clouds piecemeal, purchasing hardware servers, storage, and switches and then architecting a solution from the ground up. But this bespoke approach to hardware deployment can be costly and introduce unnecessary complexity. It can also be difficult to build these systems into a balanced configuration that is optimized for maximum performance of the processors and storage devices used. Oracle provides Oracle Exadata Database...

Lowering Your IT Costs with Oracle Database 11g Release 2 IMPROVE PERFORMANCE BY A FACTOR OF 10X “Existing queries are running about 16 to 17 times faster on Oracle Exadata on average.” Jim Duffy, Senior Data Warehouse Architect BNP Paribas Business users are always looking for greater performance from their day-to-day systems. Oracle Database 11g Release 2 enables performance improvements to be realized from the hardware resources that are already in place. For example, using Oracle Automatic Storage Management to fully utilize the I/O bandwidth of storage arrays offers increased performance...

Lowering Your IT Costs with Oracle Database 11g Release 2 processing to the data in memory on the individual nodes. This dramatically improves query performance, and is especially useful when large tables can be entirely compressed into the available memory. Extreme Performance with Oracle Exadata Storage Servers Oracle Exadata Database Machine delivers a platform optimized to get extreme performance from databases—10 to 100 times faster than what customers are achieving today on their current infrastructure. The unique technology driving this performance advantage is the Oracle Exadata Storage...

Lowering Your IT Costs with Oracle Database 11g Release 2 REDUCE STORAGE COSTS BY A FACTOR OF 10 “The Hybrid Columnar Compression query mode option is giving us 10 to 15 times more compression, and the speed, the response, and performance improvement is outstanding.” Douglas Millar, Director of Database Operations R L Polk Every organization is facing an information explosion. Business users today demand ready access to information about consumers, products, services, and competitors. And with increased regulation and governance, all business information has to be kept online longer. The result...

Lowering Your IT Costs with Oracle Database 11g Release 2 Partition for Performance and Storage Cost Reduction As databases become larger, they become more complicated to manage. What works well with a few gigabytes rarely works for terabytes of information. To this end, Oracle has been enhancing partitioning capabilities for over ten years. Oracle Partitioning allows very large tables (and their associated indexes) to be partitioned into smaller, more-manageable units, providing a “divide and conquer” approach to very large database management. Partitioning also improves performance, because...

Lowering Your IT Costs with Oracle Database 11g Release 2 Reduce Storage Usage with Advanced Compression Techniques Oracle Database 11g also provides advanced compression techniques to further reduce storage requirements. Oracle Advanced Compression uses a continuous table compression capability that achieves a two to four times compression ratio with little performance impact on OLTP or data warehousing workloads. This compression technology replaces duplicate values in a table with a single value, and continuously adapts to data changes over time, so compression ratios are always maintained....

Lowering Your IT Costs with Oracle Database 11g Release 2 MAXIMIZE AVAILABILITY “[Oracle] Active Data Guard will enable us to reduce system costs by up to US$100,000 on our larger mission-critical systems.” Aris Prassinos, Distinguished Member of Technical Staff MorphoTrak One of the primary reasons IT organizations consolidate their environments is to make it easier to manage the availability of their business applications. Providing 24/7 access to business applications requires protection from unplanned downtime and mitigation of planned maintenance operations. Plus, organizations need to be...