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
