Re: Diff between Oracle 6 & 7& 8

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Tue, 02 Mar 1999 09:20:50 -0800
Message-ID: <36DC1DF1.33827561@us.oracle.com>

FOr those with a history bent:

Oracle version 1 • Ran on PDP-11 under RSX • Used 128K of memory • Written in assembly language • Separated Oracle code and user application code
Oracle version 2 • Written in PDP-11 assembly language • Ran on VAX/VMS in compatibility mode
Oracle version 3 • Written in C - source portable • Retained split architecture • Introduced transactions
Oracle version 4 • Introduced read consistency • Ported to many platforms • First inter-operability between PC and server
Oracle version 5 • True client-server • VAX-cluster support • Distributed queries
Oracle version 6 • OLTP performance features • Online backup and recovery • Row level locking • PL/SQL procedures • Parallel Server
Oracle7 • Referential integrity • Stored procedures and functions • Role based security • Two-phase commit • Shared SQL • Data warehousing • Parallel everything • Advanced replication

HTH Pete

Sybrand Bakker wrote:

> Hi Sankar,
>
> This is a rather broad topic, the first version I ever saw, was Oracle
> 5.1.22 for Vax/VMS, after that almost every version of Oracle 6 and Oracle
> 7. Recently I went to the Oracle 8 New Features course. I will give this
> thread a start, maybe others (Thomas Kyte? Peter Sharman?) can add.
>
> Differences between Oracle 6 and Oracle7:
> rule based optimizer replaced by cost based optimizer. The rule based
> optimizer is still there, but any development has stopped.
> pl/sql version 2 instead of pl/sql version 1.
> Full enforcement by the database of constraints.
> Char means fixed length, varchar2 means varying length, maximum length
> increased from 255 to 2000.
> Shared pool, caching of parsed sql statements introduced.
> sqlnet v2 introduced, multiprotocol transparent network product
> Parallel query added
> Many administration enhancements, or should we say: lifting the
> restrictions of Oracle 6
> Introduced sysdba and sysoper roles, and passwords file.
>
> Differences between Oracle7 and Oracle 8
> - Some people call Oracle 8 Oracle 7.4. Oracle 8i probably is going to be
> far more of a revolution than Oracle 8.
> - Rowid format changed, necessary because of
> - partitioning features, both of tables and indexes, added
> - new backup and recovery product added
> - OOP features added (NB: Oracle 8 definitely is not an ODBMS!)
> - added support for binary datatypes, basically any binary file can be
> stored.
> - changed security management, added password and account expiration.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> eswar_oracle_at_hotmail.com wrote:
>
> > Can any one brief the diff between Oracle 6 & 7 & 8
> >
> > Regards
> >
> > Sankar
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Mar 02 1999 - 11:20:50 CST