1.Oracle Version & its 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