Oracle Database Versions – Difference between 11g, 12c and 18c..!!

ByJoel Pérez ( Oracle ACE Director )

Oracle Database Versions – Difference between 11g, 12c and 18c..!!

Oracle Database Versions – Difference between 11g, 12c and 18c

Oracle Database is still one of the world’s most popular, trusted database systems providing services for some of the largest companies. All the different versions provide a variety of new features and innovative capabilities in all areas including security, development, management, and performance. All providing the database administrator and developer with additional tools to assist creating innovative application on top of a secure and efficient database infrastructure. Oracle is highly recognized for its development and constant transformation, therefore it’s important to continually study the history of older versions, while embracing the new features and functionality of the newer versions.

Today, we’ll briefly analyse the difference between 2 of the latest versions 11g & 12c see what oracle have planned for the next version 18c and why it’s been classed as the game changer.

The first database to support Web technologies such as Java and HTTP originally began with Oracle 8 & 8i. The ‘i’ standing for “Internet”. Oracle included the “i” to the name to reflect support for the Internet with its built-in Java Virtual Machine (JVM). The updated version, Oracle 9i added more support for XML in 2001. Released in 2003, versions 10g and 11g was introduced with emphasis on the “g” signifying “Grid Computing”, enabling groups of low-cost industry standard servers to be treated as a single unit. This meant Data centers could now share hardware resources, thus reducing the cost of computing infrastructure.

With the latest generation of the world’s most popular database, Oracle Database 12c is by far the most important Oracle release in the last 10 years. With the “c” standing for “Cloud”, 12c provides companies of all sizes with access to the world’s fastest, most scalable and reliable database technology in a cost-effective, hybrid Cloud environment. 12c includes a series of innovations that supports customers to easily convert to the Cloud while preserving their investments in Oracle Database technologies, skills and resources. Its newer, more innovative capabilities encourage better performance, increased scalability, and easier data management. Further translating into significant cost savings, reduced risk, and increased flexibility. Oracle Database 12C implements a multitenant architecture, supporting the creation of pluggable databases (PDBs) in a multitenant container database (CDB). This enables easier unification of multiple databases and clouding of databases into IaaS, PaaS, and DBaaS deployments.

Not all versions differ drastically with Oracle offering dedicated database instances with Oracle Databases 11g, 12.1 and 12.2, with a personal choice of Standard, Enterprise, High Performance, or Extreme Performance packaging. Every version sees enhancements in areas the ones prior may have lacked. 11g features built in testing for changes, the capability of viewing tables back in time, superior compression of all types of data and enhanced disaster recovery functions. Full database caching is not implemented in 11g as caching in memory parallel query could not work well with scans contented for cache memory. This was developed further in 12c as Oracle introduces a new concept known as Automatic Big Table caching, improving significant performance benefits for workloads that was previously limited. 11g supports the feature of Oracle in memory tables used to improve full table scans, needed for access to fast data, however doesn’t support the In-Memory Aggregation (IMA) concept which Oracle 12c supports. IMA is designed to provide improved query performance while utilizing fewer CPU resources. In-Memory Aggregation provides fast query performance with fully dynamic aggregation of data without the need for indexes, summary tables or materialized views.

12c also introduces a simpler system to migrate table partition and sub partition using 2 methods, one with online keywords and secondly an offline method. A few enhancements in form of invisible indexes and virtual columns were introduced in 11g but invisible columns weren’t introduced until the release of 12g. This enables the user to define invisible columns in the table. Once defined it is explicitly referred to SQL statement or condition in SQL statement.

to continue reading the article, click the link down below:

Subscribe to get the notifications of our daily articles in your email..!

We hope the content could be useful for your Oracle DBA Tasks!

This article is brought by Yunhe Enmo (Beijing) Technology Co.,LTD


About the author

Joel Pérez ( Oracle ACE Director ) administrator