
Oracle 11G Release 2 available (Linux only though)
September 2, 2009Linux only at the moment
http://www.oracle.com/technology/products/database/oracle11g/index.html
11GR2 documentation
http://www.oracle.com/pls/db112/homepage
11GR2 new features
http://download.oracle.com/docs/cd/E11882_01/server.112/e10881/toc.htm
new features index page shows the following (of which I will be looking at ASM first)
-
- 1.1.1 Oracle Application Express
- 1.1.2 Other General Development Features
- 1.1.2.1 Support WITH HOLD Option for CURSOR DECLARATION in Pro*C
- 1.1.2.2 Pro*C Support for 8-Byte Native Numeric Host Variable for INSERT and FETCH
- 1.1.2.3 Pro*COBOL Support for 8-Byte Native Numeric Host Variable for INSERT and FETCH
- 1.1.2.4 JDBC Support for Time Zone Patching
- 1.1.2.5 JDBC Support for SecureFile Zero-Copy LOB I/O and LOB Prefetching
- 1.1.2.6 OCI Support for 8-Byte Integer Bind/Define
- 1.2 Availability
- 1.2.1 Backup and Recovery
- 1.2.1.1 Automatic Block Repair
- 1.2.1.2 Backup to Amazon Simple Storage Service (S3) Using OSB Cloud Computing
- 1.2.1.3 DUPLICATE Without Connection to Target Database
- 1.2.1.4 Enhanced Tablespace Point-In-Time Recovery (TSPITR)
- 1.2.1.5 New DUPLICATE Options
- 1.2.1.6 New SET NEWNAME Clauses and Format Options
- 1.2.1.7 Tablespace Checks in DUPLICATE
- 1.2.2 Online Application Maintenance and Upgrade
- 1.2.3 Oracle Data Guard
- 1.2.1 Backup and Recovery
- 1.3 Business Intelligence and Data Warehousing
- 1.3.1 Improved Analytics
- 1.3.2 Improved Data Loading
- 1.3.3 Improved Partitioning
- 1.3.4 Improved Performance and Scalability
- 1.3.5 Oracle Warehouse Builder
- 1.3.5.1 Advanced Find Support in Mapping Editor
- 1.3.5.2 Business Intelligence Tool Integration
- 1.3.5.3 Copy and Paste of Operators and Attributes in Mapping Editor
- 1.3.5.4 Current Configuration Dropdown List in Design Center Toolbar
- 1.3.5.5 Enhanced Support for Flat File Imports
- 1.3.5.6 Enhanced Table Function Support
- 1.3.5.7 Experts Available in Editor Menu
- 1.3.5.8 Expression Editing in Operator Edit Dialog
- 1.3.5.9 Grouping and Spotlighting of Objects in Mapping Editor
- 1.3.5.10 Improved Management of Locations Registered in Multiple Control Centers
- 1.3.5.11 Improved User Interface for Managing Locations
- 1.3.5.12 Key Lookup Operator Enhancements
- 1.3.5.13 Mapping Debugger Enhancements
- 1.3.5.14 New JDeveloper-Style User Interface
- 1.3.5.15 Operator References Included in Generated PL/SQL Code
- 1.3.5.16 Quick Mapper
- 1.3.5.17 Repository Browser Changes
- 1.3.5.18 Simplified Oracle Warehouse Builder Repository Upgrades
- 1.3.5.19 Support for Extracting Data From Tables Containing LONG Data Type
- 1.3.5.20 Support for Subqueries in Join Operator
- 1.4 Clustering
- 1.4.1 Oracle Real Application Clusters Ease-of-Use
- 1.4.1.1 Configuration Assistants Support New Oracle RAC Features
- 1.4.1.2 Enhanced Cluster Verification Utility
- 1.4.1.3 Integration of Cluster Verification Utility and Oracle Universal Installer
- 1.4.1.4 Cluster Time Service
- 1.4.1.5 Oracle Cluster Registry (OCR) Enhancements
- 1.4.1.6 Grid Plug and Play (GPnP)
- 1.4.1.7 Oracle Restart
- 1.4.1.8 Policy-Based Cluster and Capacity Management
- 1.4.1.9 Improved Clusterware Resource Modeling
- 1.4.1.10 Role-Separated Management
- 1.4.1.11 Agent Development Framework
- 1.4.1.12 Zero Downtime Patching for Oracle Clusterware and Oracle RAC
- 1.4.1.13 Enterprise Manager-Based Clusterware Resource Management
- 1.4.1.14 Enterprise Manager Provisioning for Oracle Clusterware and Oracle Real Application Clusters
- 1.4.1.15 Enterprise Manager Support for Grid Plug and Play
- 1.4.1.16 Enterprise Manager Support for Oracle Restart
- 1.4.1.17 Configuration Assistant Support for Removing Oracle RAC Installations
- 1.4.1.18 Oracle Universal Installer Support for Removing Oracle RAC Installations
- 1.4.1.19 Improved Deinstallation Support With Oracle Universal Installer
- 1.4.1.20 Downgrading Database Configured With DBControl
- 1.4.1.21 Oracle Restart Integration with Oracle Universal Installer
- 1.4.1.22 Out-of-Place Oracle Clusterware Upgrade
- 1.4.1.23 OUI Support for Out-of-Place Oracle Clusterware Upgrade
- 1.4.1.24 Server Control (SRVCTL) Enhancements
- 1.4.1.25 Server Control (SRVCTL) Enhancements to Support Grid Plug and Play
- 1.4.1.26 SRVCTL Support for Single-Instance Database in a Cluster
- 1.4.1.27 Universal Connection Pool (UCP) Integration with Oracle Data Guard
- 1.4.1.28 UCP Integration With Oracle Real Application Clusters
- 1.4.1.29 Universal Connection Pool (UCP) for JDBC
- 1.4.1.30 Java API for Oracle RAC FAN High Availability Events
- 1.4.1 Oracle Real Application Clusters Ease-of-Use
- 1.5 Database Overall
- 1.6 Diagnosability
- 1.7 Performance
- 1.8 Security
- 1.9 Server Manageability
- 1.9.1 Automatic Storage Management for All Data
- 1.9.1.1 ASM Cluster File System (ACFS)
- 1.9.1.2 ASM Dynamic Volume Manager (DVM)
- 1.9.1.3 ASM FS Snapshot
- 1.9.1.4 Oracle Cluster Registry (OCR) and Voting Disk on ASM
- 1.9.1.5 ASM Intelligent Data Placement
- 1.9.1.6 ASM Storage Management Configuration Assistant
- 1.9.1.7 Automatic Storage Management (ASM) File Access Control
- 1.9.1.8 ASMCMD Command Extensions
- 1.9.1.9 Enterprise Manager Support for ASM Cluster File System (ACFS)
- 1.9.1.10 Enterprise Manager Integration for ASM File Access Control
- 1.9.2 Database Management
- 1.9.2.1 EMCA Supports New Oracle RAC Configuration for Enterprise Manager
- 1.9.2.2 Patch Application with DBControl
- 1.9.2.3 Automatic Patching of Time Stamp With Time Zone Data
- 1.9.2.4 Prevent Data Loss for Time Zone with Local Time Zone Data Type
- 1.9.2.5 Segment Creation on Demand
- 1.9.2.6 Zero-Size Unusable Indexes and Index Partitions
- 1.9.2.7 Metadata SXML Comparison Tool
- 1.9.2.8 Compare Period Report
- 1.9.2.9 Compare SQL Tuning Sets
- 1.9.2.10 Enable Sampling for Active Data Guard
- 1.9.2.11 Exadata Simulation
- 1.9.2.12 Global Oracle RAC ASH Report + ADDM Backwards Compatibility
- 1.9.2.13 Oracle MTS and Streams Support
- 1.9.2.14 Parallel Query + Alt Plan Recording, Export STS Enhancements
- 1.9.2.15 Synchronization Controls
- 1.9.1 Automatic Storage Management for All Data
- 1.10 Unstructured Data Management