What is the difference between oracle 11g and 12c

The differences between Oracle's 11g and 12c: 1. Architecture and functions; 2. Backup and recovery; 3. Data compression; 4. Database performance; 5. Security, etc. Detailed introduction: 1. 11g adopts a traditional architecture, also known as a singleton architecture, while 12c introduces a multi-tenant architecture, also known as a container database architecture; 2. In terms of backup and recovery, 12c has some improvements and improvements compared to 11g. New features, 12c introduces new backup, recovery tools, etc.; 3. Data compression, 12c introduces new efficient compression features, etc.

The operating environment of this tutorial: Windows 10 system, Oracle version 19c, DELL G3 computer.

Oracle is a world-leading database management system supplier. They have developed multiple versions of database products, the most well-known of which are the 11g and 12c versions. The following will introduce the differences between Oracle 11g and 12c in detail from many aspects.

Architecture and functions: Oracle 11g adopts a traditional architecture, also called a singleton architecture. It uses a shared SGA (System Global Area) to manage memory and cache, and a PGA (Program Global Area) to manage process memory. Oracle 12c introduces a multi-tenant architecture, also known as a container database architecture. It can accommodate multiple independent database instances, each instance is called a container (container), and each container can contain multiple users (pluggable). This architecture can better support multi-tenant and cloud computing environments.

Backup and recovery: In terms of backup and recovery, Oracle 12c has some improvements and new features compared to 11g. 12c introduces a new backup and recovery tool called RMAN (Recovery Manager), which enables faster and more reliable backup and recovery operations. In addition, 12c also introduces a new recovery method called Global Data Recovery (GDR), which can recover the database from a failure more quickly.

data compression: Oracle 12c introduces a new feature called Advanced Compression. By using this feature, users can significantly reduce database storage space without significantly affecting performance. This is particularly useful for organizations with large amounts of data.

Database performance: In terms of performance, Oracle 12c has some improvements compared to 11g. 12c introduces a new feature called Adaptive Query Optimization, which automatically adjusts query plans based on query execution to improve query performance. In addition, 12c also introduces a new memory management method called Automatic Shared Memory Management, which can better manage memory resources and improve database performance.

safety: In terms of security, Oracle 12c has some improvements compared to 11g. 12c introduces a new feature called Unified Identity Management, which can integrate different authentication and authorization mechanisms to provide more powerful identity management and access control capabilities. In addition, 12c also introduces a new encryption method called Transparent Data Encryption, which can encrypt sensitive data at the database level to protect data privacy and security.

To summarize, the main differences between Oracle 11g and 12c include architecture and functionality, backup and recovery, data compression, database performance, and security. Compared with 11g, 12c has some improvements and new features in these aspects. These improvements and new features make 12c more suitable for multi-tenant and cloud computing environments, while also providing better performance and security. Therefore, it is very important for programmers to understand these differences to help them better choose and use the Oracle database version that suits their needs.

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!