What is the difference between oracle 11g and 12c

The difference between oracle11g and 12c: 1. The instance and database in oracle11g have a one-to-many relationship, while the instance and database in oracle12c have a one-to-one or many-to-one relationship; 2. oracle11g is more advanced in DBA management Perfect, while oracle12c is imperfect; 3. Oracle12c can support cloud databases and provide cloud platform management, but Oracle11g cannot; 4. Oracle12c can maintain multiple partitions at the same time, but Oracle11g cannot.

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

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.

In oracle12c, the instance and the database have a one-to-one or many-to-one relationship (RAC): that is, an instance can only be associated with one database, and the database can be loaded by multiple instances. When entering oracle11g, 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, the upgrade of oracle11g 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, such as MERGE of 12 partitions in one year into a new partition, such as SPLIT of one partition into multiple partitions, multiple partitions Simultaneous operations are automatically completed in parallel, and oracle11g cannot implement 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.

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