Chetu – Custom Software Development CompanySearch blackphone blackcross black

Oracle Databases: A Comprehensive Guide to 19c, 21c, and 23c

Rick ReicksenBy: Rick Reicksen


One of the most popular database systems worldwide, Oracle, is trusted by some of the biggest businesses in operation. With many different Oracle database versions released, Oracle provides innovative capabilities in many areas, including management, performance, security, and development.

Both database administrators and developers can easily use this database system to create innovative applications for their business operations. The Oracle brand is well-known for its continued dedication to paving the future development of upgraded features to better assist businesses, small and large, with their data management needs. Currently, the latest Oracle versions include Oracle Database 19c (Long Term Release), 21c (Innovation Release), and the newly released, 23c (Long Term Release).

A Breakdown of Oracle Versions

Oracle Database 19c (Long-Term Release):

Released in January 2019 as part of the long-term release for the 12.2 product family, Oracle Database 19c brings stability and extended support until April 30, 2027. Premier support is available until April 30, 2026. Notable features include Query Quarantine for managing system resources, enhanced JSON support with simplified syntax and SODA APIs, and automatic indexing using Machine Learning algorithms for improved performance. The introduction of hybrid partitioned tables allows for efficient management both inside and outside the database.

Oracle Database 21c (Innovation Release):

Oracle Database 21c, released as an innovation release, provides early insights into enhancements and new capabilities. Premier support is available until April 30, 2024, with no extended support. While not eligible for extended support, 21c includes limited quarterly release updates (RUs). The innovation release model allows users to experience cutting-edge technologies for developing or deploying new applications.

Oracle Database 23c (Long-Term Release):

Oracle Database 23c, known by its codename "App Simple," marks the next significant leap in Oracle's commitment to simplifying the development and operation of data-driven applications. Released on September 19, 2023, this long-term release (LTR) builds upon the foundation of Oracle Database 21c's innovation release, incorporating over 300 new features and enhancements. Key focus areas encompass JSON, graph, microservices, and developer productivity.

A Breakdown of Oracle Versions

Oracle Version 19C

The latest Oracle version, the 19C, was released in early January 2019. It's been noted as the long term release for the 12.2 product family of Oracle databases. This particular version will be supported through 2026, with extended support available until 2027.

Some of the features in the 19C release include:

Unlike with previous Oracle versions, 19C solves the problem of overloading system resources with query requests. This version provides automatic query quarantine to ensure that specific queries aren't running over and over.

This version has simplified the syntax for JSON functions and allows users the capability to do partial updates of JSON. In addition, it provides SODA APIs for Node.js, C, Python, and Java.

19C offers a machine learning algorithm feature that provides constant index adjustment. This algorithm leads to enhanced system performance and more cost savings. After just a short amount of use, this database version will build indexes that allow for more efficient plans for each dataset.

This 19C feature permits database administrators to manage tables both inside and outside the database with ease. The partitions inside the database can easily be managed alongside partitions that are in read-only data stores outside of the database on the premises or on the Cloud.

This new feature works to prevent downtime and data loss during database repairs and upgrades. It allows for incidental updates to be run while a synchronized physical replica or standby is maintained.

Why Upgrade to the Latest Oracle Version

Upgrading to the latest Oracle version is crucial for ongoing support, compatibility with modern systems, and enhanced security. Oracle's lifetime support policy follows the latest version, ensuring assistance for issues faced by your business. Newer operating systems may not support older database versions, necessitating upgrades for seamless operations. The latest version undergoes rigorous security evaluations, addressing past issues and ensuring a more secure environment.

In Summary

Throughout this article, we've taken a look at what the Oracle database is and why it's the most widely used RDBMS around the globe. We've discovered the various features offered in the latest Oracle versions 19c, 21c, and 23c. It's no short leap to understand why having the latest Oracle database version is essential to your business operations.

This comprehensive guide details Oracle's evolving database releases, providing insights into the stability of 19c, the innovation of 21c, and the latest information about the newest 23c long term release. Considerations for upgrading include unique features, ease of use, and the longevity of support. Oracle consulting services, such as those provided by Chetu, can facilitate a smooth transition to the latest Oracle Database, ensuring optimal business processes and cost-effectiveness. As an Oracle Gold Partner, Chetu has extensive knowledge about Oracle database versions and how to best utilize them to enhance your business processes and lower operational costs.

Chetu offers cloud migration, integration services, remote DBA service, and implementation consulting. We will work with your business to evaluate your specific needs and deliver the most beneficial Oracle cloud solution. Chetu world-class software solutions take the guessing game out of integrating and upgrading the Oracle database, so your business can start benefiting from it today.


Chetu, Inc. does not affect the opinion of this article. Any mention of specific names for software, companies or individuals does not constitute an endorsement from either party unless otherwise specified. All case studies and blogs are written with the full cooperation, knowledge and participation of the individuals mentioned. This blog should not be construed as legal advice.

Chetu was incorporated in 2000 and is headquartered in Florida. We deliver World-Class Software Development Solutions serving entrepreneurs to Fortune 500 clients. Our services include process and systems design, package implementation, custom development, business intelligence and reporting, systems integration, as well as testing, maintenance and support. Chetu's expertise spans across the entire IT spectrum.

- See more at:

Privacy Policy | Legal Policy | Careers | Sitemap | Referral | Contact Us

Copyright © 2000-2024 Chetu Inc. All Rights Reserved.

Button to scroll to top

By continuing to use this website, you agree to our cookie policy. GOT IT