Oracle Version & Features

Oracle Version 1, 1978

 Written in Assembly Language
 Ran under PDP-11 under RSX in 128K of Memory
 Implementation separates oracle code and user code.

Oracle Version 2, 1979

 The first SQL Relational Database Management system that was commercially released.
 Written in PDP-11 Assembly Language
 Ran on VAX/VMS in Compatibility mode

Oracle Version 3.1980

 Written in C, Portable Source Code
 Retained Split Architecture
 Introduced the concept of Atomic SQL Execution and transactions (Commit & Rollback)

Oracle Version 4, 1984

 Introduced Read Consistency.
 Portable to many platforms
 Interoperability between PC and Server

Oracle Version 5, 1986

 True Client Server –Distributed Processing
 VAX –Cluster Support
 Version 5.1- Distributed Queries

Oracle Version 6, 1989

 Major Kernel Rewritten
 OLTP Performance enhancements (save points)
 Online Backup and Recovery
 Row level Locking
 PL\SQL in the database
 Parallel Servers (VAX Clusters, nCube)

Oracle Version 7, 1993

 Stored Procedures and Triggers
 Shared SQL, Parallel Execution
 Declarative Referential Integrity
 Advanced Replication 

Oracle Version 8, 1997

 Object Relation Extensions in the Database
 From Client Server to Three tier Architecture
 Partitioning Option

Oracle Version 8i, 1999

 Java in the database (JVM and SQLJ)
 Partitioning Enhancements
 Data Warehousing Enhancements
 XML Support
 Summary Management
 Oracle Internet Directory (LDAP)
 Ported to Linux

Oracle Version 9i, 2001

 Real Application Clusters, with cache fusion– Scalability on inexpensive clustered hardware
 Automatic segment-space management
 Internet security enhancements
 Integrated business intelligence functionality
 Data Guard (standby databases)
 Oracle managed files
 Globalization support (Unicode, time zones, locales)

Oracle Version 10g, 2003

 Primary goal: Build a self-managing database that requires minimal human intervention.
 Reduction in administration cost without
 Compromising high availability, scalability, and security.
 Minimal performance impact
 Effective for all configurations and workloads

Oracle Version 11g, 2007

 Flashback data Archive
 Advanced Compression
 Real Application Testing
 Automatic Storage Management