Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Oracle Database 11g Release 2 (11.2.0.1) New Features

• 1.1 Application Development
  • 1.1.1 Oracle Application Express
    • 1.1.1.1 Application Date Format
    • 1.1.1.2 Custom Themes
    • 1.1.1.3 Declarative BLOB Support
    • 1.1.1.4 Documented JavaScript Libraries
    • 1.1.1.5 Enhanced Report Printing
    • 1.1.1.6 Forms Conversion
    • 1.1.1.7 Improved Security
    • 1.1.1.8 Interactive Reporting Region
    • 1.1.1.9 Runtime-Only Installation
  • 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.2.1 Edition-based Redefinition
    • 1.2.2.2 Enhance CREATE or REPLACE TYPE to Allow FORCE
    • 1.2.2.3 Fine-Grained Dependencies for Triggers
    • 1.2.2.4 IGNORE_ROW_ON_DUPKEY_INDEX Hint for INSERT Statement
  • 1.2.3 Oracle Data Guard
    • 1.2.3.1 Compressed Table Support in Logical Standby Databases and Oracle LogMiner
    • 1.2.3.2 Configurable Real-Time Query Apply Lag Limit
    • 1.2.3.3 Integrated Support for Application Failover in a Data Guard Configuration
    • 1.2.3.4 Support Up to 30 Standby Databases
• 1.3 Business Intelligence and Data Warehousing
  • 1.3.1 Improved Analytics
    • 1.3.1.1 Analytic Functions 2.0
    • 1.3.1.2 Recursive WITH Clause
  • 1.3.2 Improved Data Loading
    • 1.3.2.1 EXECUTE Privilege for DIRECTORY Objects
    • 1.3.2.2 Preprocessing Data for ORACLE_LOADER Access Driver in External Tables
  • 1.3.3 Improved Partitioning
    • 1.3.3.1 Allow Virtual Columns in the Primary Key or Foreign Key for Reference Partitioning
    • 1.3.3.2 System-Managed Indexes for List Partitioning
  • 1.3.4 Improved Performance and Scalability
    • 1.3.4.1 In-Memory Parallel Execution
    • 1.3.4.2 Minimal Effort Parallel Execution - Auto Degree of Parallelism (DOP) and Queuing
    • 1.3.4.3 The DBMS_PARALLEL_EXECUTE Package
    • 1.3.4.4 Significant Performance Improvement of On-Commit Fast Refresh
  • 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.5 Database Overall
  • 1.5.1 General
    • 1.5.1.1 Flashback Data Archive Support for DDLs
    • 1.5.1.2 Instance Caging
  • 1.5.2 Improvements to Oracle Scheduler
    • 1.5.2.1 E-mail Notification
    • 1.5.2.2 File Watcher
    • 1.5.2.3 Multiple Destination Jobs
    • 1.5.2.4 Remote Database Jobs
  • 1.5.3 Improvements to Utilities
    • 1.5.3.1 Data Pump Legacy Mode
  • 1.5.4 IPv6 Support
    • 1.5.4.1 Complete IPv6 Support for JDBC Thin Clients
    • 1.5.4.2 Complete IPv6 Support for JVM and Java Debuggers
• 1.6 Diagnosability
  • 1.6.1 Support Workbench
    • 1.6.1.1 Enterprise Manager Support Workbench for ASM
• 1.7 Information Integration
  • 1.7.1 Oracle Database XStream
    • 1.7.1.1 XStream
• 1.8 Performance
  • 1.8.1 General Server Performance
    • 1.8.1.1 Database Smart Flash Cache
    • 1.8.1.2 Stored Outlines Migration to SQL Plan Management
    • 1.8.1.3 Client Result Cache Using Table Annotations Support
    • 1.8.1.4 Support 4 KB Sector Disk Drives
• 1.9 Security
  • 1.9.1 Audit Data Management
    • 1.9.1.1 Audit Trail Cleanup
  • 1.9.2 Encryption Key Management
    • 1.9.2.1 Tablespace Master Key Rekey
• 1.10 Server Manageability
  • 1.10.1 Automatic Storage Management for All Data
    • 1.10.1.1 ASM Cluster File System (ACFS)
    • 1.10.1.2 ASM Dynamic Volume Manager (DVM)
    • 1.10.1.3 ASM FS Snapshot
    • 1.10.1.4 Oracle Cluster Registry (OCR) and Voting Disk on ASM
    • 1.10.1.5 ASM Intelligent Data Placement
    • 1.10.1.6 ASM Storage Management Configuration Assistant
    • 1.10.1.7 Automatic Storage Management (ASM) File Access Control
    • 1.10.1.8 ASMCMD Command Extensions
    • 1.10.1.9 Enterprise Manager Support for ASM Cluster File System (ACFS)
    • 1.10.1.10 Enterprise Manager Integration for ASM File Access Control
  • 1.10.2 Database Management
    • 1.10.2.1 EMCA Supports New Oracle RAC Configuration for Enterprise Manager
    • 1.10.2.2 Patch Application with DBControl
    • 1.10.2.3 Automatic Patching of Time Stamp With Time Zone Data
    • 1.10.2.4 Prevent Data Loss for Time Zone with Local Time Zone Data Type
    • 1.10.2.5 Segment Creation on Demand
    • 1.10.2.6 Zero-Size Unusable Indexes and Index Partitions
    • 1.10.2.7 Metadata SXML Comparison Tool
    • 1.10.2.8 Compare Period Report
    • 1.10.2.9 Compare SQL Tuning Sets
    • 1.10.2.10 Enable Sampling for Active Data Guard
    • 1.10.2.11 Exadata Simulation
    • 1.10.2.12 Global Oracle RAC ASH Report + ADDM Backwards Compatibility
    • 1.10.2.13 Oracle MTS and Streams Support
    • 1.10.2.14 Parallel Query + Alt Plan Recording, Export STS Enhancements
    • 1.10.2.15 Synchronization Controls
• 1.11 Unstructured Data Management
  • 1.11.1 Enhanced Oracle Multimedia and DICOM Support
    • 1.11.1.1 Attribute Extraction of Requested Attributes Only
    • 1.11.1.2 Client-Side DICOM Attribute Extraction
    • 1.11.1.3 DICOM Enhancements
    • 1.11.1.4 Watermarking and Image Processing Enhancements
  • 1.11.2 Enhanced Oracle Spatial Support
    • 1.11.2.1 3D Visualization Framework
    • 1.11.2.2 Network Data Model Enhancements
    • 1.11.2.3 New GeoRaster JAVA API
    • 1.11.2.4 Raster Reprojections and Ground Control Point-Based (GCP) Georeferencing
    • 1.11.2.5 Routing and Geocoding Enhancements
  • 1.11.3 Oracle SecureFiles
    • 1.11.3.1 Database File System (DBFS)
    • 1.11.3.2 Support for Oracle SecureFiles
  • 1.11.4 Oracle XML DB Scale and Performance Improvements
    • 1.11.4.1 Binary XML Enhancements
    • 1.11.4.2 Oracle XML DB Repository Performance Improvements and Guidelines
    • 1.11.4.3 XMLIndex Enhancements
    • 1.11.4.4 XMLType Partitioning

2 Oracle Database 11g Release 2 (11.2.0.2) New Features

• 2.1 General
  • 2.1.1 General
    • 2.1.1.1 Control File Updates Can Be Disabled During NOLOGGING Operations
    • 2.1.1.2 New Package for Configuring Automatic SQL Tuning
    • 2.1.1.3 Enhanced Security for DBMS_SCHEDULER E-Mail Notification
    • 2.1.1.4 Enhanced TRUNCATE Functionality
    • 2.1.1.5 Support for In-Place Upgrade of Clients
    • 2.1.1.6 Maintenance Package for Segment Creation on Demand
    • 2.1.1.7 Maximum CPU Utilization Limit
    • 2.1.1.8 Name Matching
    • 2.1.1.9 Named Entity Extraction
    • 2.1.1.10 Default Size of First Extent of Any New Segment for a Partitioned Table Has Changed
    • 2.1.1.11 Parallel Statement Queuing
    • 2.1.1.12 PMML Import
    • 2.1.1.13 Result Set Interface
    • 2.1.1.14 Segment Creation On Demand for Partitioned Tables
    • 2.1.1.15 Simplification of XML and XQuery Interfaces
    • 2.1.1.16 SMTP Authentication
    • 2.1.1.17 SMTP Encryption
    • 2.1.1.18 SPA Support for Active Data Guard Environment
    • 2.1.1.19 The EDITION Attribute of a Database Service
    • 2.1.1.20 Using Binary XML with SecureFiles as the XMLType Default Storage
    • 2.1.1.21 JDBC 4.0 SQLXML
    • 2.1.1.22 ID Key LCRs in XStream
  • 2.1.2 ACFS Improvements
    • 2.1.2.1 ACFS, ADVM and Snapshots on Solaris and AIX
    • 2.1.2.2 Oracle ACFS Replication
    • 2.1.2.3 Oracle ACFS Security and Encryption Features
    • 2.1.2.4 Oracle ACFS Tagging
  • 2.1.3 Quality of Service (QoS) Management
    • 2.1.3.1 Database QoS Management Server
    • 2.1.3.2 Database Quality of Service (QoS) Management Support
    • 2.1.3.3 Enterprise Manager QoS Management Integration
    • 2.1.3.4 Server Memory Stress Protection for Oracle Clusters
  • 2.1.4 Database Replay
    • 2.1.4.1 Database Replay SQL Performance Analyzer (SPA) Integration
    • 2.1.4.2 Database Replay Timeout Function
    • 2.1.4.3 Database Replay Workload Analyzer
  • 2.1.5 Management
    • 2.1.5.1 DBCA Support for Creating an Oracle RAC One Node Database
    • 2.1.5.2 Option of Downloading Latest Updates During Installation
    • 2.1.5.3 Oracle ASM Configuration Assistant Support for Out-of-Place Upgrades
    • 2.1.5.4 Oracle Database Upgrade Assistant Support for Out-of-Place Upgrades
    • 2.1.5.5 Oracle Enterprise Manager DB Control Support for Oracle RAC One Node
    • 2.1.5.6 Online Relocation of an Oracle RAC One Node Database
    • 2.1.5.7 SRVCTL-Based Management of Oracle RAC One Node Databases
    • 2.1.5.8 CRSCTL Command Enhancements
    • 2.1.5.9 SRVCTL Command Enhancements
    • 2.1.5.10 Enhanced XStream Manageability
    • 2.1.5.11 Columnar Compression Support in Supplemental Logging and XStream
    • 2.1.5.12 Standalone Configuration Wizard for Post-Installation Cluster Configuration
    • 2.1.5.13 Redundant Interconnect Usage

3 Oracle Database 11g Release 2 (11.2.0.3) New Features

• 3.1 General
  • 3.1.1 Support Hybrid Columnar Compression on Pillar Axiom and Sun ZFSSA
  • 3.1.2 Support for SHA-2 Certificate Signatures
  • 3.1.3 TDE Hardware Acceleration for Solaris
  • 3.1.4 Support for Multiple Certificates on Smart Card
  • 3.1.5 QoS Management Support for Oracle RAC Enterprise Edition
  • 3.1.6 QoS Management Support for Instance Caging on Exadata
  • 3.1.7 Oracle ACFS Snapshot Enhancements
  • 3.1.8 Oracle ACFS Security and Encryption Features
  • 3.1.9 Support for ACFS Replication and Tagging on Windows
  • 3.1.10 Oracle LogMiner Support for Binary XML
  • 3.1.11 SQL Apply Support for Binary XML
  • 3.1.12 Oracle LogMiner Support for Object Relational Model
  • 3.1.13 SQL Apply Support for Object Relational Model
  • 3.1.14 Deprecation of Obsolete Oracle XML DB Functions and Packages
  • 3.1.15 Oracle Warehouse Builder Support for Partition DML
  • 3.1.16 Enhanced Partitioning Support in Oracle Warehouse Builder
  • 3.1.17 Oracle Warehouse Builder External Table Data Pump Support
  • 3.1.18 Oracle Warehouse Builder External Table Preprocessor Support
  • 3.1.19 Compressed Table and Partition Support in Oracle Warehouse Builder
  • 3.1.20 Support for PL/SQL Native Compilation

4 Oracle Database 11g Documentation

• 4.1 Documentation Titles and Online Documentation Structure
  • 4.1.1 Oracle® Database 11g Server Documentation
  • 4.1.2 Oracle® Database 11g Installation Documentation
  • 4.1.3 Oracle® Database 11g Networking Documentation
  • 4.1.4 Oracle® Database 11g Spatial and Semantic Documentation
  • 4.1.5 Oracle® Database 11g Gateways Documentation
  • 4.1.6 Oracle® Database 11g Communications Data Model Documentation
  • 4.1.7 Oracle® Database 11g Java Development Documentation
  • 4.1.8 Oracle® Database 11g Data Mining Documentation
  • 4.1.9 Oracle® Database 11g TimesTen In-Memory Database Documentation
  • 4.1.10 Oracle® Database 11g Documentation Library
  • 4.1.11 Oracle® Database 11g Warehouse Builder Documentation
  • 4.1.12 Oracle® Multimedia 11g Documentation
  • 4.1.13 Oracle® Database 11g Microsoft Windows Documentation
  • 4.1.14 Oracle® Database 11g OLAP Documentation
  • 4.1.15 Oracle® Database 11g Release Notes Documentation