Difference between Oracle 12C and 19C

In this article, we will learn why it is important to upgrade databases from 12C to 19C and what is the difference between Oracle 12C and 19C.

Version 12C

In 2014, Oracle officially released Version 12C, the first in the C-Series, this high-performance RDBMS is denoted with a C instead of a G. Because it is the first version of Oracle designed for the cloud. This version of Oracle makes it very easy for companies to move their existing Oracle database information to the cloud. Version 12C introduced 500 new features in the Oracle database. The most notable features are the pluggable databases and the multi-tenant architecture.

Version 19C

Oracle Database 19C was released on Oracle Live SQL in January 2019 and is the final version of the Oracle Database 12C family of products. Oracle Database 19C comes with four years of premium support and at least three extended supports. It also forms the basis for the next phase of Oracle standalone database optimization.

Oracle Database 19C: What’s Changed

As mentioned earlier, Oracle Database 19C is the last long-term release of the Oracle 12C product family. Oracle 19C will be supported through 2023, with extended support through 2026.
Here are some highlights from Oracle Database 19c:

  • 19C can provide as a bare metal, virtual machine, or Exadata database, or as a stand-alone database.
  • In order to benefit from the functionality of the standalone database, it must be specifically select when creating the DBS.
  • If you are currently running 12C you will need to upgrade to the terminal version of the product you are running and then proceed with the upgrade process by upgrading to the 19C database.

Oracle Database 12C Features

  • Easier, better, faster, and stronger JSON
  • JSON to PL / SQL
  • Long names
  • Robust code with constants for lengths of data types
  • Improved overflow listing
  • Lightning-fast SQL with real-time materialized views
  • Fast estimates with rough improvements in queries
  • Check data type conversions
  • Handling of casting conversion errors
  • Table partitioning with a single statement
  • Automatic partitioning of lists
  • Mark the old code as “Do not use”
  • PL / SQL code coverage

Oracle Database 19C New Features

Oracle Database 19C builds on innovations from previous releases such as multitenant, in-memory, JSON support, sharding, and many other features that enable Oracle’s stand-alone database cloud services.
This latest release introduces new features and provides customers with an enterprise-class database with multiple models for all of their typical use cases, including:

  • Operational database use cases are traditional transactions, real-time analytics, JSON document storage, and Internet of Things (IoT) applications
  • Analytical databases like traditional and real-time data warehouses and data stores, large data lakes, and graphical analysis.
  • Additional functions to better support the GDPR

Here are some of the main new features:

Automatic indexing

This feature uses machine learning (ML) algorithms to create indexes and continuously adjust them to improve performance and cost savings. This means you can start the database with no or very few indexes and over a short period of time the database will check the nature of the data query and create indexes to provide access plans effective for this dataset.

DML Active Data Guard Redirection

Oracle has reintroduced Oracle Active Data Guard in Oracle Database 11g to help customers make better use of this standby database by running reports and backups. In Oracle Database 19c, Oracle adds an important twist to this functionality that allows you to perform transactions for the standby database.

Hybrid partitioned tables

This feature allows database administrators to maintain a table between partitions within the database and partitions stored in inexpensive read-only datastores outside of the database. These data stores can be located locally or in the cloud.

Support for JSON

Support for JSON is improving. Oracle has improved and simplified the syntax of our JSON functions and introduced the ability to perform a partial JSON update. Additionally, Oracle Database 19c includes new Simple Oracle Document Access (SODA) APIs for Java, Python, C, and Node.js.

Interrogate quarantine

The overall performance of a datamart or warehouse can suffer if a user runs a query that consumes an excessive amount of I / O and computes resources. Oracle Database 19C can automatically quarantine these queries and ensure they are not rerun, resulting in consistent performance for all database users.

Reasons to Upgrade to the Oracle 19C Database

Very often database administrators (DBAs) push back upgrading the Oracle database in addition to the processors on the pretext that if everything is going well, why touch it? However, there are several reasons why you should upgrade to Oracle Database 19c in addition to the new features

Lifetime Assistance Policy: The support waiver will end soon. All Oracle E-Business Suite clients running on 12.1 databases and must upgrade to 19C to remain fully supported.

Sustainability: Older versions of Oracle Database do not support or certified on newer operating systems. If you want to keep pace with platform changes planned by your server team, you need to keep pace with Oracle upgrades. Another important point is the certification of your operating system and the stable version.

Security: By upgrading to the latest version of the Oracle database, you get the software with built-in security at all levels.

If you have any question, Feel free to ask in the comments section below.

Please share this post:
Posts created 42

Ask a Question

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts

Begin typing your search term above and press enter to search. Press ESC to cancel.

%d bloggers like this: