Five unique features of Oracle 11g

The following articles mainly introduce the five features of Oracle 11g and the actual and practical advantages. The application ratio of Oracle 11g performance in practice is still the majority, if you are curious about this newly developed technology, the following articles will unveil its mysteries.

Compared with data stored in a non-compressed format, the new Oracle Data Compression Technology can save more than three times the disk storage space with a small overhead. This is more advantageous than saving only disk space, because it can save more expenses for enterprises, so that they can have more money to consolidate their position.

Automatic Diagnostic Knowledge Base: Automatic Diagnostic Repository, ADR) is a knowledge base dedicated to severe errors. This knowledge base can basically automatically perform operations that were previously performed manually by the database administrator.

As part of ADR, SQL Performance Analyzer, SPA) is one of the most surprising features. The SQL Performance Analyzer is an overall adjustment tool. The administrator can use this tool to define and repeat a typical workload in the database (replay, then the administrator can adjust the overall parameters to achieve the optimal performance of the database as soon as possible-and this task has also been manually completed by the database administrator for many years.

Given the optimal initial parameters, the Database Administrator does not need to adjust tens of thousands of SQL statements. What the administrator needs to do is to give a typical load. SAP determines the final SQL settings based on the historical records, and does not need the Administrator to check which SQL settings are the most reasonable.

Another new feature that Oracle has been trying to accomplish over the years is "online update" (updating software without going down ). In fact, it is difficult to design a software that can be automatically upgraded at runtime from the perspective of software engineering. Due to the Real Application Clusters (RAC) feature of the Real Application cluster, Oracle once again put more pressure on other database vendors.

In actual use, database product users always want continuous high availability. This does not mean that it is enough to meet the needs of three years before the next patch update.

The automatic memory management feature can be traced back to Oracle 9i, when Oracle released the first automatic storage pool adjustment tool. The AMM tool is actually a detection mechanism. In fact, Oracle 11g has many random access storage pools. When AMM detects that a storage pool is full, it allocates the entire RAM from one region to another.
 

Article by: http://database.csdn.net/page/944a4a2b-5894-4ca6-851e-86b72a374731