Oracle Database: Difference between revisions

Revision as of 15:26, 18 February 2025

Revision as of 21:30, 29 March 2025

Line 53:

! Marquee <br /> Features

|-

|{{Version |c |Oracle Database 23ai (LTR)}}

|23.4.0

|On May 2, 2024, Oracle Database 23ai<ref>{{cite web|title=Announcing Oracle Database 23ai: General Availability|url=https://blogs.oracle.com/database/post/oracle-23ai-now-generally-available|access-date=2024-05-02|website=Oracle Corporation|language=en}}</ref> was released on Oracle Cloud Infrastructure (OCI) as cloud services, including OCI Exadata Database Service, OCI Exadata Database Cloud@Customer, and OCI Base Database Service. It is also available in Always Free Autonomous Database. Oracle Database 23c (previously released in 2023) was renamed to Oracle Database 23ai (23.4) due to the significant additional engineering effort to add features that bring AI capabilities to the data in Oracle Database.

Line 63:

|AI Vector Search<ref>{{cite web|title=Oracle Announces General Availability of AI Vector Search in Oracle Database 23ai|url=https://blogs.oracle.com/database/post/oracle-announces-general-availability-of-ai-vector-search-in-oracle-database-23ai|access-date=2024-05-02|website=Oracle Corporation|language=en}}</ref> (includes new Vector data type, Vector indexes, and Vector SQL operators/functions), JSON Relational Duality,<ref>{{cite web|title=Oracle Announces General Availability of JSON Relational Duality in Oracle Database 23ai|url=https://blogs.oracle.com/database/post/oracle-announces-general-availability-of-json-relational-duality-in-oracle-database-23ai|access-date=2024-05-02|website=Oracle Corporation|language=en}}</ref> JSON Schema Validation, Transactional Microservices Support, OKafka, Operational Property Graphs, Support for [[SQL/PGQ]], Schema Privileges, Developer Role, In-database SQL Firewall, TLS 1.3 Support, Integration with Azure Active Directory OAuth2, True Cache for mid-tier caching, Readable Per-PDB Standby, Globally Distributed Database with active-active RAFT-based replication, Real-time SQL Plan Management, Priority Transactions, SQL Syntax Simplification, Schema Annotations, Data Use Case Domains, Column Value Lock-free Reservations

|-

|{{Version |co |Oracle Database 21c (IR)}}

|21.1.0

|December 2020 (cloud)<ref>{{cite web|title=Oracle Database 21c|url=https://docs.oracle.com/en/database/oracle/oracle-database/21/index.html|access-date=2020-12-09|website=Oracle Help Center|language=en}}</ref>

Line 70:

|Blockchain Tables, Multilingual Engine - JavaScript Execution in the Database, Binary JSON Data Type, Per-PDB Data Guard Physical Standby (aka Multitenant Data Guard), Per-PDB GoldenGate Change Capture, Self-Managing In-Memory, In-Memory Hybrid Columnar Scan, In-Memory Vector Joins with SIMD, Sharding Advisor Tool, Property Graph Visualization Studio, Automatic Materialized Views, Automatic Zone Maps, SQL Macros, Gradual Password Rollover

|-

| {{Version |co |Oracle Database 19c (LTR)}}

| 19.1.0 // 12.2.0.3

| February 2019 (Exadata)<ref>{{cite web|url=https://blogs.oracle.com/database/oracle-database-19c-now-available-on-oracle-exadata |access-date=2021-04-27 |title=Oracle Database 19c Now Available on Oracle Exadata|date=2019-02-13|first1=Dominic|last1=Giles|website=Oracle Database Insider }}</ref>

Line 78:

| Active Data Guard DML Redirection, Automatic Index Creation, Real-Time Statistics Maintenance, SQL Queries on Object Stores, In-Memory for IoT Data Streams, Hybrid Partitioned Tables, Automatic SQL Plan Management, SQL Quarantine, Zero-Downtime Grid Infrastructure Patching, Finer-Granularity Supplemental Logging, Automated PDB Relocation

|-

| {{Version |o |Oracle Database 18c (IR)}}

| 18.1.0 // 12.2.0.2

| February 2018 (cloud, Exadata)<ref>{{cite web|url=https://blogs.oracle.com/database/oracle-database-18c-:-now-available-on-the-oracle-cloud-and-oracle-engineered-systems |access-date=2021-04-28 |date=2018-02-16 |title=Oracle Database 18c : Now available on the Oracle Cloud and Oracle Engineered Systems |website=Oracle Database Insider }}</ref>