Overview of new features in Oracle 11g R2

BKJIA exclusive release] Oracle 11g R2 has been released. This update has many new features. Integration reduces costs and eliminates unused redundancy.

Let's take a look at the attractive new features added in Oracle 11g R2.

Server cost reduced by 5 times through grid integration

In this version, Oracle Real Application cluster RAC provides plug-and-play grid and new server pool functions. By streamlining configuration and Database Grid Management, this allows organizations to reduce server costs.

A single-node Oracle RAC is a new database option. With this new solution, Oracle users can merge non-critical database environments in the grid, and Oracle RAC provides redundancy and availability.

Reduce storage costs

Combined with Oracle 11g R2 advanced compression and partition support, it reduces storage costs by providing a compression ratio of up to 2-4 times and simplifies the use of low-cost storage layers.

In this version, Oracle Advanced storage management has been expanded and now supports general cluster file systems, helping customers reduce storage management costs.

Eliminate unused Redundancy

Oracle 11g R2 Automatic Storage Management ASM), Oracle Real Application cluster and activity data guard Allow Storage and server resources to be used for fault tolerance and production at the same time, to prevent servers and storage devices from waiting for time and space failures.

In this version, version-based redefinition is introduced to allow online upgrades of user database applications, eliminating the need for an independent upgrade environment.

Improves data warehouse performance

Oracle 11g R2 works with Oracle database machines and HP to provide query performance up to 10 times.

This version also provides enhanced query performance and the ability to perform transparent queries on data stored in memory on multiple databases in the grid.

Increase DBA productivity by 2 times

The automated self-management capability can help database administrators increase productivity. Compared with the earlier version of Oracle, it can increase productivity by at least twice, and reduce the time required to upgrade from the earlier version.

Reference supported

Andy Mendelsohn, senior vice president of Oracle database server technology, said: "Our users want better performance and availability, lower IT costs, and provide better information for their business users, oracle 11g R2 solves the current business and IT challenges. Our strategy is to help customers provide high-quality and low-cost services ".

Carl Olofson, vice president of IDC Research, said, "As organizations face exponential growth in information throughout their data centers and become increasingly complex, they are trying to reduce IT costs and improve management efficiency, the features of Oracle 11g R2 enhance grid computing, storage management, and management capabilities, help users achieve greater utilization of information system resources, and make the infrastructure and storage of relevant systems easier to manage.

1. Oracle 11g R2 may arrive in December September
2. Step 8: Be proficient in accessing the Sybase Database from Oracle
3. Oracle 11g R2 highlights the RAC technology as scheduled
4. MySQL encroaches on the Oracle market to use open-source IT facilities
5. How to send an Email through Oracle