Introduction to Oracle 12c

ArticleDirectory

•  
• New Features
• Database architecture

On July 6, June 26, 2013, Oracle Database 12C was officially released. The first version was 12.1.0.1.0. The first download platforms were Linux and Solaris:

Oracle official:

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

 

Like the previous 10g, 11g Represents grid, while C in 12C is cloud, which means cloud computing.

New Features

The data type, partition table, statistical information, and data optimization have all changed. We can see an article detailing the new features.

Http://www.searchdatabase.com.cn/showcontent_66349.htm

 

Database architecture

I think the biggest difference in 12C is that the entire database architecture is very different from the previous one. in the past, an instance corresponds to a database, and there are different schemas under the database, and the schema also corresponds to the user one by one.

In 12 C, there are multiple independent databases under one instance.

It looks like it is similar to SQL Server. SQL Server is an instance that corresponds to many databases. however, the user creation process is different. the login user created by SQL Server is login, and then login is mapped to the users under different databases. The users under different databases have different operation permissions on their databases.

The user created in Oracle is similar to the previous one. the databases in the table can be completely independent from those in SQL Server. different databases in Oracle must access each other through dB link. therefore, the general operations for common users are the same as before. There is only one database, but it is very different from the DBA perspective. It is necessary to maintain multiple databases.

Let's take a look at the architecture of Oracle 12 (from the figure copied by Comrade eygle, link: http://www.eygle.com/archives/2012/10/12c_pluggable_database.html)