合 Oracle版本发布历史
👉 本文共约3618个字，系统预计阅读时间或需14分钟。
发布历史
| Oracle Database release numbering has used the following codes: | Oracle Database Version | Initial Release Version | Initial Release Date | Terminal Version | Marquee Features |
|---|---|---|---|---|---|
| Oracle Database 23c | 23.2.0 | April 2023 (Linux) Oracle Database Free - Developer Release[10] September 2023 Oracle Database on Base Database Service[11] | JSON Relational Duality, JSON Schema Validation, Transactional Microservices Support, OKafka, Operational Property Graphs, Support for SQL/PGQ, Schema Privileges, Developer Role, SQL Firewall, TLS 1.3 Support, Integration with Azure Active Directory OAuth2, True Cache, Readable Per-PDB Standby, Sharding with active-active Raft-based replication, Automatic SQL Plan Management, Priority Transactions, SQL Syntax Simplification, Annotations, Data Usage Domains, Column Value Lock-free Reservations | ||
| Oracle Database 21c | 21.1.0 | December 2020 (cloud)[12] August 2021 (Linux)[13] | 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 | ||
| Oracle Database 19c | 19.1.0 // 12.2.0.3 | February 2019 (Exadata)[14] April 2019 (Linux)[15] June 2019 (cloud) | 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 | ||
| Oracle Database 18c | 18.1.0 // 12.2.0.2 | February 2018 (cloud, Exadata)[16] July 2018 (other)[17] | 18.17.0 January 2022 | Polymorphic Table Functions, Active Directory Integration, Transparent Application Continuity, Approximate Top-N Query Processing, PDB Snapshot Carousel, Online Merging of Partitions and Subpartitions | |
| Oracle Database 12c Release 2 | 12.2.0.1 March 2017 | August 2016 (cloud) March 2017 (on-prem) | 12.2.0.1 March 2017 | Native Sharding, Zero Data Loss Recovery Appliance, Exadata Cloud Service, Cloud at Customer | |
| Oracle Database 12c Release 1 | 12.1.0.1 | July 2013[18] | 12.1.0.2 July 2014 | Multitenant architecture, In-Memory Column Store, Native JSON, SQL Pattern Matching, Database Cloud Service | |
| Oracle Database 11g Release 2 | 11.2.0.1 | September 2009[19] | 11.2.0.4 August 2013 | Edition-Based Redefinition, Data Redaction, Hybrid Columnar Compression, Cluster File System, Golden Gate Replication, Database Appliance | |
| Oracle Database 11g Release 1 | 11.1.0.6 | September 2007 | 11.1.0.7 September 2008 | Active Data Guard, Secure Files, Exadata | |
| Oracle Database 10g Release 2 | 10.2.0.1 | July 2005[20] | 10.2.0.5 April 2010 | Real Application Testing, Database Vault, Online Indexing, Advanced Compression, Data Guard Fast-Start Failover, Transparent Data Encryption | |
| Oracle Database 10g Release 1 | 10.1.0.2 | 2003 | 10.1.0.5 February 2006 | Automated Database Management, Automatic Database Diagnostic Monitor, Grid infrastructure, Oracle ASM, Flashback Database | |
| Oracle9i Database Release 2 | 9.2.0.1 | 2002 | 9.2.0.8 April 2007 | Advanced Queuing, Data Mining, Streams, Logical Standby | |
| Oracle9i Database | 9.0.1.0 | 2001 | 9.0.1.5 December 2003 | Oracle Real Application Clusters (RAC), Oracle XML DB | |
| Oracle8i Database | 8.1.5.0 | 1998 | 8.1.7.4 August 2000 | Native internet protocols and Java, Virtual Private Database | |
| Oracle8 Database | 8.0.3 | June 1997 | 8.0.6 | Recovery Manager, Partitioning. First version available for Linux.[21] | |
| Oracle 7.3 | 7.3.0 | February 1996 | 7.3.4 | Object-relational database | |
| Oracle 7.2 | 7.2.0 | May 1995 | Shared Server, XA Transactions, Transparent Application Failover | ||
| Oracle 7.1 | 7.1.0 | May 1994 | Parallel SQL Execution. First version available for Windows NT.[22] | ||
| Oracle7 | 7.0.12 | June 1992 | PL/SQL stored procedures, Triggers, Distributed 2-phase commit, Shared Cursors, Cost-Based Optimizer | ||
| Oracle 6.2 | 6.2.0 | Oracle Parallel Server | |||
| Oracle v6 | 6.0.17 | 1988 | 6.0.37 | Row-level locking, scalability / performance, online backup and recovery, B*Tree indexes, PL/SQL executed from compiled programs (C etc). First version available for Novell Netware 386.[23] | |
| Oracle v5 | 5.0.22 (5.1.17) | 1985 | 5.1.22 | Support for client/server computing and distributed database systems. First version available for OS/2. Correlated sub-queries[24] | |
| Oracle v4 | 4.1.4.0 | 1984 | 4.1.4.4 | Multiversion read consistency. First version available for MS-DOS.[25][26] | |
| Oracle v3 | 3.1.3 | 1983 | Concurrency control, data distribution, and scalability. Re-written in C for portability to other operating systems, including UNIX.[27] | ||
| Oracle v2 | 2.3 | 1979 | First commercially available SQL RDBMS. Basic SQL queries, simple joins[28] and CONNECT BY joins. Written in assembly language for the PDP-11 to run in 128KB of RAM.[29] Ran on PDP-11 and VAX/VMS in PDP-11 compatibility mode. |
参考
https://en.wikipedia.org/wiki/Oracle_Database
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
