Everything You Need to Know About Oracle 23c

Oracle 23c New Features & Oracle 19c Updates

At Oracle CloudWorld in late 2023, it was announced that Oracle 23c is live. Here’s what we think you’d want to know.

Oracle Database 23c delivers the most complete and simple converged database for developers looking to build new microservices, graphs, documents, and relational applications.

Key Verison takeaways:

Oracle 23c:

• Available currently in OCI Base Database Service and will become available on other platforms sometime during 1^st Half 2024.
• A free version with limited features “Oracle Database 23c free“ is also available here to provide native support for all modern data types, analytics, and development paradigms, this version is a great place to get started for anyone involved with databases.
• This new version has a big focus on developers with a long-term release scheduled from 2023 until 2029 with Premier support, with extended support needed until to 2032.

Oracle 19c

• Continuing long term release since 2019 with current Premier support until April 30 2026. After this date paid Extended support will be required.

New features of Oracle 23c

Over 300 new features in 23c plus new features added for Oracle 21c which was an Innovation Release. And we’ve complied a list of some of the new features to look forward to using in 23c:

1. Application Development enhancements such as:

• JSON enhancements
• Direct joins from update and delete statements
• If (NOT) exists syntax support
• New Database role for application developers
• Increased maximum size of inline lobs of 8000 bytes
• Operational Property graphs
• Developer role
• Tables can have up to 4096 columns

2. Improved Machine Learning Algorithms
3. Azure Integration
4. Real-Time SQL Monitoring enhancements
5. Database Security: SQL Firewall to Prevent SQL injection attacks
6. Oracle True Cache
7. Read-Only Per-PDB Standby

In addition to this, we’ve also put together a resource of handy links for you below. For more information, please contact us. 

• Oracle Live Labs – 23c workshops
• Oracle 23 New Features
• More information on Oracle Database 23c: The Next Long Term Support Release

Understanding Oracle Support Tiers

Software support contracts are an integral part of the modern IT landscape. They ensure that your customized, paid-for software continues to function smoothly and securely. However, over time, the value of these contracts can diminish as vendors cut back on support services while increasing fees.

Oracle offers three levels of support, each with its own set of features. Learn more about Oracle’s support tiers.

Written by Brad Smith, Client Delivery Lead for Oracle at Blue Crystal Solutions