Roadmap of Oracle Database releases

September 12, 2014 by 3 Comments 

[Updated in October 2017]

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 11.2 and beyond, 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-2017)

Oracle database roadmap

Oracle database roadmap [updated in October 2017]

Patching end dates for the latest release/patch levels

Release Patching Ends Notes and Exceptions*
12.1.0.2 31-Jul-2021 Extended Support fees waived through July 31, 2019
12.1.0.1 31-Aug-2016 Patching has ended for this release.
11.2.0.4 31-Dec-2020
Extended Support fees waived until Dec 31, 2018.

Oracle Major releases – Designated by the 2nd place in the version number (e.g. 11.2.0.x) and shown as the wider red bar in the Roadmap.

—> 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).

Oracle historical release road map

2018: Oracle 18c expected to be released (based on OOW 2017 announcement)
– First fully autonomous database

2017: Oracle 12cR2 (12.2) 

2014 – 12.1.0.2

– Oracle Database In-Memory– Oracle Big Data SQL
– Oracle JSON Document Store
– Oracle REST Data Services
– Improvements to Oracle Multitenant
– Advanced Index Compression
– Zone Maps
– Approximate Count Distinct
– Attribute Clustering
– Full Database Caching
– Rapid Home Provisioning

I’ll also try to place below my first draft of the history of Oracle database innovations and version releases.

2013 – Oracle Database 12c R1
New Multitenant and Pluggable database concept
– Adaptive Query Optimization
– Online Stats Gathering
– Temporary UNDO
– In Database Archiving
– Invisible Columns
– PGA Aggregate Limit setting
– DDL Logging
– Flash ASM

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

3 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

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