oracle 10g 和ORACLE 11G的区别是什么

cyf_1983

11G比10G添加了什么功能,比817好在哪里,多谢指点

Maclean Liu(刘相兵

2007年发售的11g号称是Oracle 20年来最具影响力的产品

11g 的新特性列表包括：
Feature List:

    Adaptive Cursor Sharing
    ADDM Enhancements (for RAC)
    Automated Maintenance Tasks
    Automatic Memory Management
    Automatic SQL Tuning
    Automatic Storage Manager (ASM) Enhancements
    AWR Baseline Enhancements
    Case Sensitive Passwords
    Data Recovery Advisor
    Database Resident Connection Pool
    Database Replay
    DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
    Diagnostics Repository
    Direct NFS

                 

    Fine-Grained Access to Network Services
    Finer Grained Dependency Management
    Flashback Data Archive
    Flashback Transaction
    Function Result Cache
    Health Monitor
    Install Oracle Database 11g
    Invisible Indexes
    Logminer
    Online Table Redefinition
    Partitioning
    Query Result Cache
    Read-Only Tables
    Resource Manager Enhancements

                 

    RMAN
    Scheduler Enhancements
    SecureFiles
    SQL Access Advisor
    SQL Performance Analyzer
    SQL Plan Management
    Statistics Collection Enhancements
    Table Compression Enhancements
    Temporary Tablespace Enhancements
    Tablespace Encryption
    Upgrading to Oracle Database 11g


完整的 11g的新特性列表可以参考官方新特性 文档
Oracle® Database New Features Guide
11g Release 1 (11.1)
http://docs.oracle.com/cd/B28359 ... b28279/chapter1.htm

Oracle® Database New Features Guide
11g Release 2 (11.2)
Part Number E22487-04
http://docs.oracle.com/cd/E11882_01/server.112/e22487/toc.htm