Roadmap of Oracle Database releases

September 12, 2014 by 6 Comments 

[Updated in October 2020]

Oracle was, is and will be probably the first in most of RDBMS innovations. Over the last 35 years Oracle went through successful database release schedule. To help planning the company IT projects I give the below road-map of the latest Oracle Database major releases , showing planned release dates and the duration of their support lives. The release and timing of any platforms are subject to change at any time and at Oracle’s sole discretion. (see the latest status in MOS Doc ID 742060.1 or below as last updated on Oct-2020)

Patching end dates for the latest release/patch levels 

Release Patching Ends Notes and Exceptions
19c April 30, 2024 with no ES/ULA

April 30, 2027 with ES/ULA

Long Term Release

18c
Jun 08, 2021 Innovation Release
not eligible for Extended Support (ES)
12.2.0.1 March 31, 2022 (Limited Error Correction) – Error Correction / Patching until Nov 30, 2020
– Limited Error Correction (Sev 1 and Security Updates only)    See Note 161818.1 for details

12.1.0.2
Jul 31, 2022 with paid ES, ULA Terminal Release
11.2.0.4 Dec 31, 2020 (with paid ES/ULA)
Dec 31, 2021 (with paid Market Driven Support for OCI)
Dec 31, 2022 (with paid Market Driven Support for on-Premises)
Terminal Release

Oracle Major releases – Designated by the 2nd place in the version number (e.g. 11.2.0.x)

* Starting from Oracle 12.2 Oracle uses a new patching concept based on RUs RURs patches.

* Before Oracle release 12.2 following patching concept applies:

– Oracle Patch sets – Designated by the 4th place in the version number (e.g. 11.2.0.2), and shown by the narrower green bars below their associated major release. Patchsets are released on different platforms over time started usually from Linux.
– Patch Set Updates (PSU) and Critical Patch Updates (CPU) – (not listed separately on the Roadmap) they are released every quarter for supported patch sets and designated by the 5th place in the version number (e.g. 11.2.0.2.2).

Below is my first draft of the history of Oracle database innovations and version releases.

Oracle historical release road map

2019: Oracle 19c (Terminal Patch set of Oracle 12cR2 Family – Long Term Release)
– SQL JSON Enhancements
– AutoUpgrade
– Rest API Support
– Automatic Indexing
– Data Guard DML Redirect

2018: Oracle 18c (First Patch set of Oracle 12cR2 Family)
– First fully autonomous database
– PDB Snapshot Carousel
– Multiple PDB Shards
– In-Memory External Tables
– Web SQL Developer

2016: Oracle 12cR2 (12.2)
– Oracle Database Sharding
– PDB: Hot Cloning, Character sets, I/O Rate & Memory Limits
– Snapshot Based Replication
– Multi-Instance Redo Apply
– Active Data Guard: Far Sync, DML Redirection, …
– Multi-Column List Partitioning

2013 – Oracle 12c R1 (12.1)
New Multitenant and Pluggable database concept
– Oracle Database In-Memory
– Adaptive Query Optimization
– Online Stats Gathering
– Temporary UNDO
– In Database Archiving
– Invisible Columns
– PGA Aggregate Limit setting
– DDL Logging
– Flash ASM
– SQL Pattern Matching
– Oracle Big Data SQL
– Oracle JSON Document Store
– Oracle REST Data Services
– Advanced Index Compression
– Zone Maps
– Approximate Count Distinct
– Attribute Clustering
– Full Database Caching
– Rapid Home Provisioning

2009 – Oracle 11g2
– SQL Performance Analyzer
Deferred segment creation
– Smart Flash Cache
– Automatic block repair from Standby DB
– Edition Based Redefinition
– Oracle RAC One Node
– Oracle Restart
– Instance Caging
ASM Cluster File System (ACFS)

2008 – First Exadata V1

2007 – Oracle 11g
– Real-Time SQL Monitoring
– Query Result Cache
– Advanced Compression Option
– SecureFiles LOBs
– Flashback Data Archive
– Data Recovery Advisor
Automatic Diagnostic Repository (ADR)

2005 – Oracle 10gR2
– Transparent Data Encryption
– Transportable Tablespace Support
– ASM Command-Line (asmcmd) utility
– OPatch the Patching Tool
– Database Replay
– Active Session History (ASH) Report
– Automatic Segment Advisor

2004 – First Free Oracle database
10g Express Edition

2003 – Oracle 10g: first Grid computing database
– Grid computing – an extension of Oracle RAC
– Automated Storage Management (ASM)
– New self-tuning features (AWR, ADDM)
– Recycle bin
– New database job scheduler (DBMS_SCHEDULER)
– Datapump utility
– SYSAUX tablespace

2002 – Oracle 9iR2
– Locally Managed SYSTEM tablespaces
– Data segment compression
– Oracle Streams
– Cluster file system for Windows and Linux
– Logical standby databases with Data Guard
– Default Accounts locked on install

2001 – Oracle 9i
– First database to complete the 3 terabyte TPC-H world record
– First database with built-in web services; with integrated data mining; with Hash, Range, Composite and List partitioning; with dynamic memory management; with built-in workflow
– Oracle RAC introduced
– Automated System Managed Undo
– Flashback query
– Oracle Data Guard (new name)
– Dynamic Memory Management
– On-line table and index reorganization
– Resumable backups and statements

1999 Oracle8i: First internet ready database
– Integrated JavaVM
– Oracle iFS (Internet File System)
– First database with XML support
– First RDBMS ported to Linux
– Statspack utility
– PL/SQL encrypt/decrypt package
CASE statement in SQL
– User schema concept
– CURSOR_SHARING parameter
– Fast Start recovery
– Log Miner functionality
– OPS Cache Fusion
– Virtual Private Database (VPD)
– Temporary tables
– Drop column on table
– Function based indexes

1998
– First database with Java support
– First database on Linux
– Breaks the 100,000 TPC-C barrier

1997 Oracle8: First Web-enabled database
– First Web database
– Object types
– SQL3 standard
– Parallel DML statements
– Index Organized tables (IOTs)
– Reverse Key indexes
– ROWID format
– Advanced Queuing
Recovery manager (RMAN)

1996 – Oracle 7.3
– First to break the 30,000 TPC-C barrier
– Standby Database
– Bitmapped Indexes
– Partitioned Views
– Index rebuilds
– db_verify utility
– Spatial and Context Data Options
– Histograms
– Oracle trace

1995 – First 64-bit RDBMS

1994 – First secure database evaluations

1992 – Version 7
– First a full applications implementation methodology (AIM)
– Partitioning introduced
– Stored procedures and triggers
– Referential integrity with Foreign Keys

1988 – Version 6
– First row – level locking
– First to introduce PL/SQL
– On-line database backups
– B*Tree indexes implemented
– Concept of tablespaces introduced
– Rollback Segments introduced

1987 – First SMP database

1985 – Version 5
– First parallel server database
– First client-server database
– First distributed queries

1984 – Version 4: First database with read consistency
Read consistency concept enabled readers and writers to access the same data without one blocking the other.

1983 – Version 3: First portable Oracle Database
– First 32-bit mode RDBMS
– First portable database offered a choice of what hardware and operating system platform to run on
– First database written entirely in C
– First VAX-mode database

1979 – Version 2: first Oracle Database
First RDBMS version released in 1979 was called Oracle V2. Why not V1? There were two reasons for that: a concern that a version 1 would not awake potential customers’ interest and to show a pseudo- leadership compared to the competitors. First version of RDBMS was created with assembler.

So that was the Roadmap of Oracle Database version releases, current status and the brief history. In case of minor mistakes please correct in comments and I’ll update it. Thanks

Enjoyed this article? Please share it with others using the social site of your choice:

Comments

6 Responses to “Roadmap of Oracle Database releases”
  1. Peter says:

    Nice review of all Oracle database releases. Thank you!

  2. William says:

    The Oracle database releases and roadmap is really really helpful. Please provide an update regularly.

    Thank you so much.

    William

  3. ankit says:

    this is awesome

  4. Greg Clough says:

    Hi,

    I’m doing a presentation on Oracle and PostgreSQL… and I’d love to include your graphic. It’s for a local user group in London, but I may also like to give the presentation internally in my company.

    Can I get your permission?

    Thanks.
    Greg

    London, UK

  5. Gabriela Nesterovsky says:

    Excelente Información, gracias por compartirla!

  6. Kirill Loifman says:

    Sure, it it.

Add a Comment

We welcome thoughtful and constructive comments from readers.
If you want your own picture to show with your comment?
Go get a Globally Recognized Avatar!

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email