Pages

Monday, March 25, 2024

Oracle 23C New Features and Release Dates



Oracle Database 23c introduces several new features and enhancements across various areas. Here are some of the key new features in Oracle Database 23c:

Oracle Database 23C Release Dates:

Oracle typically releases new versions of its database software in a staggered manner, with the cloud (Oracle Cloud Infrastructure) releases preceding the on-premises releases. Here are the expected release dates for Oracle Database 23c:

Cloud Release:

Oracle Autonomous Database 23c: This version was released and made generally available on the Oracle Cloud Infrastructure (OCI) on May 16, 2023.

On-Premises Release:

Oracle Database 23c: The on-premises version of Oracle Database 23c is expected to be released in H1-2024. However, Oracle has not yet announced the specific release date.

Initially available on OCI Base Database Service. Will become available on other platforms (cloud and on-premises) starting 1H CY2024

It's important to note that these dates are subject to change, and Oracle may adjust the release timelines based on various factors, such as development progress, testing, and customer feedback.

Once the on-premises version of Oracle Database 23c is released, customers with active support subscriptions will be able to download and install it on their on-premises infrastructure or private clouds. Oracle typically provides support for new database releases for several years, including critical patch updates, security fixes, and performance enhancements.

It is advised to consult Oracle's official documentation, release notes, and support channels for the most up-to-date information on the Oracle Database 23c release dates, system requirements, and any specific considerations for their environments.

Oracle 23C New Features:

Autonomous JSON:

Native storage and processing of JSON data within the database.

Faster ingestion, querying, and analysis of semi-structured data.

Support for JSON data types, functions, and SQL/JSON path expressions.

Blockchain Tables:

Tamper-resistant and immutable storage of data using blockchain technology.

Ensures data integrity, transparency, and non-repudiation.

Suitable for applications requiring auditing, regulatory compliance, or secure transaction records.

Autoindex:

Automatic creation and management of indexes based on workload patterns and queries.

Leverages machine learning algorithms to identify optimal indexes.

Improves query performance without manual index management.

Converged Database:

Combines the capabilities of Autonomous Data Warehouse (ADW) and Autonomous Transaction Processing (ATP).

Allows running mixed workloads (analytical and transactional) within a single database instance.

Simplifies data management and reduces operational overhead.

Enhanced Machine Learning:

Improved machine learning capabilities with support for more algorithms.

Better model explanations and integration with Oracle Analytics Cloud.

Enables advanced data analysis and predictive modeling within the database.

Query Performance Optimizations:

Enhanced parallelism and in-memory processing.

Optimizations for specific workloads like Star Queries and Hash Joins.

Improved query execution times for analytical and reporting workloads.

Increased Storage Capacity:

Support for larger database instances to handle growing data volumes.

Ability to provision more storage capacity as needed.

Security and Compliance Enhancements:

Support for Oracle Database Vault for improved data security and access control.

Enhanced auditing capabilities and data masking options.

Compliance with industry standards and regulations.

Database Memory Management Improvements:

Automatic Memory Management enhancements for better memory utilization.

Improved performance for memory-intensive workloads.

SQL Enhancements:

New SQL functions and syntax improvements.

Support for additional data types and improved compatibility with other database systems.

These new features in Oracle Database 23c aim to enhance performance, security, data processing capabilities, and workload consolidation. Additionally, Oracle continues to optimize the database for cloud deployments, with a focus on automation, scalability, and self-management capabilities.