What is the difference between oracle12c and 11g

Difference: 1. The instance and database in oracle11g have a one-to-one or many-to-one relationship, while the instance and database in oracle12c can have a one-to-many relationship; 2. Multiple partitions cannot be maintained at the same time in oracle11g Operation, and in oracle12c, maintenance operations can be performed on multiple partitions at the same time.

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

What is the difference between oracle12c and 11g

The biggest difference is that 12C introduces the concept of plug-in database and container database instead of the traditional library table structure

1. Correspondence.

Before oracle12c, the instance and the database had a one-to-one or many-to-one relationship (RAC): that is, one instance could only be associated with one database, and the database could be loaded by multiple instances. When entering oracle12C, the instance and database can have a one-to-many relationship.

2. Version completeness.

oracle11g is more complete in DBA management, improves the management and control capabilities of the database, and provides many automatic features. Relatively speaking, oracle11g upgrade is relatively simple, while oracle12c is not as smooth as oracle11g.

3. New features.

The new feature of oracle12c is to support cloud database and provide cloud platform management, which is a function that oracle11g does not have. At the same time, oracle12c adds the concepts of CDB and PDB, and its functions are more complete than oracle11g.

4. Multi-partition support.

oracle12c can perform maintenance operations on multiple partitions at the same time. For example, MERGE 12 partitions of a year into a new partition. For example, SPLIT a partition into multiple partitions. Multiple partitions can be operated automatically at the same time. Completed in parallel, and oracle11g cannot achieve this function.

oracle 12c is another major upgrade compared to the previous version, especially its container; "in memory option" is also a relatively major feature improvement; other details have been enhanced a lot, such as rman can restore tables, these I won’t go into details here; this version is another major upgrade compared to the old version.

Oracle 11g merges and extends Oracle-specific capabilities to realize the benefits of grid computing, transforming data centers from scattered islands of system resources into shared pools of servers and storage;

Oracle 12c is designed for cloud computing.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of What is the difference between oracle12c and 11g. For more information, please follow other related articles on the PHP Chinese website!