The most complete overview of oracle11g

This is GMG's first blog in the blog Park, recently, GMG in the study oracle11g, this blog, I put myself these days to oracle11g overview in the form of a blog to show.

In November 2007, Oracle 11g was officially released and features were greatly enhanced. 11G is the most important database version that Oracle has released in 30 years. This is the top 20 database in June 2016, and Oracle is still ahead of the highest score in the first place.

ORACLE11G adds many new features, the main features of which are as follows:

1. Enhance information lifecycle management and storage management capabilities

The Oracel 11g is a powerful data partitioning and compression feature that enables more economical information lifecycle management and storage management.

2. Comprehensive recall of data changes

Oracle 11g has a comprehensive recall component that helps administrators to query data in a given table at some point in the past.

3. Maximize the availability of information

Oracle flashback transaction, which can easily undo erroneous trades and any related transactions; Parallel backup and restore capabilities improve backup and storage performance for very large databases; "Hot fix" function, the database can not be hung wall database shyness, improve system availability.

4. Oracle Quick File

Oracle 11g has next-generation features that store large objects in a database, including images, large text, or some advanced data types. such as XML, medical imaging data, and three-dimensional objects.

5. Faster XML

In Oracle 11g, the performance of XML DB has been greatly improved, and XML db is a component of the Oracle database that helps customers store and manipulate XML data natively.

6. Transparent encryption

Oracle 11g further enhances the unparalleled security of Oracle databases,

7, embedded OLAP ranks

Oracle 11g has also been innovative in data warehousing, and OLAP row and column downloads can be used in databases like materialized diagrams.

8, Connection convergence and query results cache

Oracle 11g further enhances Oracle's industry-leading position in performance and scalability, enhancing performance with query results caching.

9, enhance the application development performance

Oracle 11g offers a broad selection of developer tools that provide a streamlined application development process.

The following is a small series of the public number, you can scan the code attention Oh!

The most complete overview of oracle11g