oracle的各版本发行时间及特点

今天在图书馆整理笔记，突然想到oracle的历史也不算短了，就猜想oracle的前身是什么？他的各个版本主要提供了哪些便利？于是便在网上搜了下，特整理如下：


Oracle数据库自发布至今，也经历了一个从不稳定到稳定，从功能简单至强大的过程。从第二版开始，Oracle的每一次版本变迁，都具有里程碑意义。


1979年的夏季，RSI（Oracle公司的前身，Relational Software，Inc）发布了Oracle第二版。


1983年3月，RSI发布了Oracle第三版。从现在起Oracle产品有了一个关键的特性--可移植性。


1984年10月，Oracle（RSI更名为Oracle）发布了第4版产品。这一版增加了读一致性这个重要特性。


1985年，Oracle发布了5.0版。这个版本是Oracle数据库较为稳定的版本。并实现了C/S模式工作。


1986年，Oracle发布了5.1版。该版本开始支持分布式查询。


1988年，Oracle发布了第6版。该版本中引入了行级锁特性，同时还引入了联机热备份功能。


1992年6月，Oracle发布了第7版。该版本增加了包括分布式事务处理功能、用于应用程序开发的新工具及安全性方法等功能。


1997年6月，Oracle第8版发布。Oracle8支持面向对象的开发及新的多媒体应用。


1998年9月，Oracle公司正式发布Oracle 8i。正是因为该版本对Internet的支持，所以，在版本号之后，添加了标识i。


2001年6月，Oracle发布了Oracle 9i。


2003年9月，Oracle发布了Oracle 10g。这一版的最大特性就是加入了网格计算的功能，因此版本号之后的标识使用了字母g，代表Grid--网格。


2007年7月11日，Oracle发布了Oracle 11g。Oracle 11g实现了信息生命周期管（Information Lifecycle Management）等多项创新。


Oracle的最新版本为Oracle 11g，但是，目前应用最广泛的版本为Oracle 9i和Oracle 10g。本书选取使用的版本为Oracle 10g。


Oracle具有强大的功能，因此，对于硬件要求也较高。Oracle 10g安装的硬件要求如下：


1024MB以上的物理内存。


1.5～3.5 GB磁盘空间，具体大小由安装类型决定。
Oracle数据库11g有多个版本可供选择： 标准版1、标准版和企业版。所有这些版本都使用相同的通用代码库构建，这意味着企业的数据库管理软件可以轻松地从规模较小的单一处理器服务器扩展到多处理器服务器集群，而无需更改一行代码。Oracle数据库11g企业版还有许多其他增强了性能、可伸缩性、可用性、安全性和可管理性的功能选项。 


软件环境如下：Windows XP、Windows 2003或者Linux Red Hat 5.0以上版本。需要注意的是，Windows Vista与Oracle 10g的兼容性较差，不推荐使用。


英文介绍


Oracle 2 - 1979
    First public release
    Basic SQL functionality, queries and joins
    CONNECT BY queries
    Written in pdp-11 assembly language, ran on vax/vms in compatibility mode


Oracle 3 - 1981
    Atomic execution of SQL statements and transactions (COMMIT and ROLLBACK of transactions)
    Nonblocking queries (no more read locks)
    Re-written in the C-programming language


Oracle 4 - 1984
    Read consistency
    First interoperability between PC and database server
    Database ported to several platforms


Oracle 5.1 - 1986
    Distributed queries


Oracle 5.0 - 1985
    Supporting for the Client-Server model - PC's can access the DB on remote host


Oracle 6.2
    Oracle Parallel Server Option (later renamed to Real Application Clusters)


Oracle 6.1
    There was never an Oracle 6.1 production release. However, a 6.1 version was made available to selected beta customers running on clustered hardware. Apparently the database was so busy checking block status's between the machines that it killed the systems it ran on.


Oracle 6 - July 1988
    OLTP performance enhancements
    Row-level locking
    On-line database backups (alter tablespace begin/end backup)
    New Procedural Option (TPO) - PL/SQL in the database (*)
    B*Tree indexes implemented
    Rollback Segments introduced
    Concept of tablespaces introduced
    (*) Functions, Procedures, Packages and Triggers were not available until Oracle 7.


Oracle 7.3 - February 1996
    Partitioned Views
    Bitmapped Indexes
    Asynchronous read ahead for table scans
    Standby Database
    Deferred transaction recovery on instance startup
    Updatable Join Views (with restrictions)
    SQL*DBA no longer shipped.
    Index rebuilds
    db_verify utility introduced
    Context Option
    Spatial Data Option
    Tablespaces changes - Coalesce, Temporary/ Permanent,
    Trigger compilation, debug
    Unlimited extents on STORAGE clause.
    Some init.ora parameters modifiable - TIMED_STATISTICS
    Hash Joins, Antijoins
    Histograms
    Dependencies
    Oracle Trace
    Advanced Replication Object Groups
    PL/SQL - UTL_FILE


Oracle 7.2 - May 1995
    Resizable, autoextend data files
    Shrink Rollback Segments manually
    Create table, index UNRECOVERABLE
    Subquery in FROM clause (Inline view)
    PL/SQL wrapper
    PL/SQL Cursor variables
    Checksums - DB_BLOCK_CHECKSUM, LOG_BLOCK_CHECKSUM
    Parallel Create Table As (CTAS)
    Job Queues - DBMS_JOB
    DBMS_SPACE and DBMS_APPLICATION_INFO packages
    Sorting Improvements - SORT_DIRECT_WRITES


Oracle 7.1 - May 1994
    ANSI/ISO SQL92 Entry Level
    Oracle Advanced Replication - Symmetric Data replication
    Snapshot Refresh Groups
    Parallel Recovery
    Dynamic SQL - DBMS_SQL
    Parallel Query Options - query, index creation, data loading
    Server Manager introduced
    Read Only tablespaces


Oracle 7.0 - June 1992
    Database Integrity Constraints (primary keys, foreign keys, check constraints, default values)
    Stored procedures and functions, procedure packages
    Database Triggers
    View compilation
    User defined SQL functions
    Role based security
    Multiple Redo members - mirrored online redo log files
    Resource Limits - Profiles
    Much enhanced Auditing
    Enhanced Distributed database functionality: INSERTS, UPDATES, DELETES, 2PC
    Incomplete database recovery (e.g. SCN based recovery)
    Cost Based Optimizer
    TRUNCATE tables
    Datatype changes (i.e VARCHAR2, CHAR, VARCHAR)
    SQL*Net v2, MTS
    Checkpoint process (CKPT)
    Data replication - Snapshots


Oracle 8 - 1997
    Object Relational database (ORDBMS) features
    Object types (not just date, character, number as in v7)
    SQL3 standard
    Call external procedures
    LOB >1 per table
    Partitioned Tables and Indexes (new partitioning option)
    partitions in multiple tablespaces
    export/import individual partitions
    Online/offline, backup/recover individual partitions
    merge/balance partitions
    Advanced Queuing for message handling
    Many performance improvements to SQL/PLSQL/OCI making more efficient use of CPU/Memory. V7 limits extended (e.g. 1000 columns/table, 4000 bytes VARCHAR2)
    Parallel DML statements (UPDATE and DELETE)
    Connection Pooling (uses the physical connection for idle users and transparently re-establishes the connection when needed) to support more concurrent users.
    Improved "STAR" Query optimizer
    Integrated Distributed Lock Manager in Oracle PS (as opposed to Operating system DLM in v7).
    Performance improvements in OPS - global V$ views introduced across all instances, transparent failover to a new node
    Data Cartridges introduced on database (e.g. image, video, context, time, spatial)
    Backup/Recovery improvements - Tablespace point in time recovery, incremental backups, parallel backup/recovery. Recovery manager introduced (see RMAN)
    Security Server introduced for central user administration. User password expiry, password profiles, allow custom password scheme. Privileged database links (no need for password to be stored)
    Fast Refresh for complex snapshots, parallel replication, PL/SQL replication code moved in to Oracle kernel. Replication manager introduced.
    Index Organized tables (IOTs)
    Deferred integrity constraint checking (deferred until end of transaction instead of end of statement).
    SQL*Net replaced by Net8
    Reverse Key indexes
    Any VIEW updateable (INSTEAD OF triggers on views)
    New ROWID format




Oracle 8i (8.1.7) - August 2000
    Static HTTP server included (Apache)
    JVM Accelerator to improve performance of Java code
    Java Server Pages (JSP) engine
    MemStat - A new utility for analyzing Java Memory footprints
    OIS - Oracle Integration Server introduced.
    PLSQL Gateway introduced for deploying PL/SQL based solutions on the Web
    Enterprise Manager Enhancements - including new HTML based reporting and Advanced Replication functionality included.
    New Database Character Set Migration utility included.


Oracle 8i (8.1.6) - November 1999
    PL/SQL Server Pages (PSP's)
    DBA Studio Introduced
    Statspack - used for performance monitoring (much better that UTLBSTAT/UTLESTAT)
    Many new SQL analytical functions like lag, lead and rank
    ALTER FREELISTS command (previously done by DROP/CREATE TABLE)
    Checksums always ON for SYSTEM tablespace allowing many possible corruptions to be fixed before writing to disk (DB_BLOCK_CHECKING).
    XML Parser for Java
    New PL/SQL encrypt/decrypt package introduced
    JServer Accelerator (Native Java compiler for each platform), Java programs can run as machine code, not interpreted as with 8.1.5
    Native support for Java2
    New CASE statement in SQL similar to the Decode() function
    New SQL*Plus command line options: sqlplus -MARKUP [HTML...] and -RESTRICT
    User and Schemas separated
    CURSOR_SHARING parameter - optimize SHARED POOL for applications that do not use bind variables
    Numerous Performance Enhancements


Oracle 8i (8.1.5) - February 1999
    Fast Start recovery - Checkpoint rate auto-adjusted to meet roll forward criteria
    Reorganize indexes/index only tables which users accessing data - Online index rebuilds
    Log Miner introduced - Allows on-line or archived redo logs to be viewed via SQL
    OPS Cache Fusion introduced avoiding disk I/O during cross-node communication
    Advanced Queueing improvements (security, performance, OO4O support
    User Security Improvements - more centralisation, single enterprise user, users/roles across multiple databases.
    Virtual Private Database (VPD)
    Integrated JavaVM (called Aurora) in the database kernel allowing one to execute Java stored procedures
    Integrated support for EJB (Enterprise JavaBeans)
    JSQL: a specification for Java-based SQL database statements
    Integrated Object Request Broker for standard CORBA communications between applications and the database
    Oracle iFS (Internet File System)
    Resource Management using priorities - resource classes
    Hash partitioning and Composite partitioning
    New partitioning features: merge partitions into one, updatable partition keys (allow movement of rows between partitions), can use LOBS in partitioned tables
    Single table hash clusters
    SQL*Loader direct load API
    Copy optimizer statistics across databases to ensure same access paths across different environments.
    Standby Database - Auto shipping and application of redo logs. Read Only queries on standby database allowed.
    Enterprise Manager v2 delivered - completely rewritten in Java
    NLS - Euro Symbol supported
    Analyze tables in parallel.
    Temporary tables supported (Tables that will be truncated at the end of a transaction or session).
    Net8 support for SSL, HTTP, HOP protocols
    Transportable tablespaces, copy tablespaces with datafiles between databases
    Locally managed tablespaces - automatic sizing of extents, elimination of tablespace fragmentation, tablespace information managed in tablespace (i.e moved from data dictionary) improving tablespace reliability
    Drop column on table (finally!!!!!)
    DBMS_DEBUG PL/SQL package, DBMS_SQL replaced by new EXECUTE IMMEDIATE statement
    Progress Monitor to track long running DML, DDL
    Function based indexes - NLS, case insensitive, descending, based on user defined function, etc.
    Index key compression: duplicate keys are combined to save space


Oracle 9i Release 2 (9.2.0) - May 2002
    Locally Managed SYSTEM tablespaces
    Oracle Streams - new data sharing/replication feature (can potentially replace Oracle Advance Replication and Standby Databases)
    XML DB (Oracle is now a standards compliant XML database)
    Data segment compression (compress keys in tables - only when loading data)
    Cluster file system for Windows and Linux (raw devices are no longer required).
    Create logical standby databases with Data Guard
    Java JDK 1.3 used inside the database (JVM)
    Oracle Data Guard Enhancements (SQL Apply mode - logical copy of primary database, automatic failover
    Security Improvements - Default Install Accounts locked, VPD on synonyms, AES, Migrate Users to Directory


Oracle 9i Release 1 (9.0.1) - June 2001
    Traditional Rollback Segments (RBS) are still available, but can be replaced with automated System Managed Undo (SMU). Using SMU, Oracle will create it's own "Rollback Segments" and size them automatically without any DBA involvement.
    Flashback query (dbms_flashback.enable) - one can query data as it looked at some point in the past. This feature will allow users to correct wrongly committed transactions without contacting the DBA to do a database restore.
    Use Oracle Ultra Search for searching databases, file systems, etc. The UltraSearch crawler fetch data and hand it to Oracle Text to be indexed.
    Oracle Nameserver is still available, but deprecate in favour of LDAP Naming (using the Oracle Internet Directory Server). A nameserver proxy is provided for backwards compatibility as pre-8i client cannot resolve names from an LDAP server.
    Oracle Parallel Server's (OPS) scalability was improved - now called Real Application Clusters (RAC). Full Cache Fusion implemented. Any application can scale in a database cluster. Applications doesn't need to be cluster aware anymore.
    The Oracle Standby DB feature renamed to Oracle Data Guard. New Logical Standby databases replay SQL on standby site allowing the database to be used for normal read write operations. The Data Guard Broker allows single step fail-over when disaster strikes.
    Scrolling cursor support. Oracle9i allows fetching backwards in a result set.
    Dynamic Memory Management - Buffer Pools and shared pool can be resized on-the-fly. This eliminates the need to restart the database each time parameter changes were made.
    On-line table and index reorganization.
    VI (Virtual Interface) protocol support, an alternative to TCP/IP, available for use with Oracle Net (SQL*Net). VI provides fast communications between components in a cluster.
    Build in XML Developers Kit (XDK). New data types for XML (XMLType), URI's, etc. XML integrated with AQ.
    Cost Based Optimizer now also consider memory and CPU, not only disk access cost as before.
    PL/SQL programs can be natively compiled to binaries.
    Deep data protection - fine grained security and auditing. Put security on DB level. SQL access do not mean unrestricted access.
    Resumable backups and statements - suspend statement instead of rolling back immediately.
    List partitioning - partitioning on a list of values.
    ETL (eXtract, transformation, load) Operations - with external tables and pipelining.
    Oracle OLAP - Express functionality included in the DB.
    Data Mining - Oracle Darwin's features included in the DB.




Oracle 10g Release 1 (10.1.0) - January 2004
    Grid computing - an extension of the clustering feature (Real Application Clusters)
    Manageability improvements (self-tuning features)
    Performance and scalability improvements
    Automated Storage Management (ASM)
    Automatic Workload Repository (AWR)
    Automatic Database Diagnostic Monitor (ADDM)
    Flashback operations available on row, transaction, table or database level
    Ability to UNDROP a table using a recycle bin
    Ability to rename tablespaces
    Ability to transport tablespaces across machine types (E.g Windows to Unix)
    New 'drop database' statement
    New database scheduler - DBMS_SCHEDULER
    DBMS_FILE_TRANSFER Package
    Support for bigfile tablespaces that are up to 8 Exabytes in size
    Datapump - faster data movement with expdp and impdp
    SYSAUX tablespace has been introduced
    NID utility has been introduced to change the database name and/or id.


Oracle 10g Release 2 (10.2.0) - September 2005
    Transparent Data Encryption
    Async COMMITs
    The CONNECT ROLE can now only connect (CREATE privs removed)
    Passwords for DB Links are encrypted
    New asmcmd utility for managing ASM storage
    Support for regular expressions in SQL and PL/SQL


Oracle 11g - September 2009
    New options: Oracle RAC One Node, solution for consolidating less mission critical databases on the grid with most of the redundancy and availability provided by RAC. An Omotion utility is provided to migrate One Node instances to other nodes in the cluster without any downtime to the application.
    New features: 
    Some of the new features include:
    Improved data compression ratios (up to 20x).
    Ability to upgrade database applications while users remain online.
    New ease-of-use features that make Grid computing more accessible.
    Automation of key systems management activities.