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.
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.
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
- SQL 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:
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.
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.