Skip Headers
Oracle® Database New Features Guide
11
g
Release 2 (11.2)
Part Number E22487-02
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
Contents
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Oracle Database 11
g
Release 1 (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 11
g
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 11
g
Release 2 (11.2.0.3) New Features
3.1
General
3.1.1
Oracle ACFS Snapshot Enhancements
3.1.2
Oracle ACFS Security and Encryption Features
3.1.3
Support for ACFS Replication and Tagging on Windows
3.1.4
Oracle LogMiner Support for Binary XML
3.1.5
SQL Apply Support for Binary XML
3.1.6
Oracle LogMiner Support for Object Relational Model
3.1.7
SQL Apply Support for Object Relational Model
3.1.8
Deprecation of Obsolete Oracle XML DB Functions and Packages
3.1.9
Oracle Warehouse Builder Support for Partition DML
3.1.10
Enhanced Partitioning Support in Oracle Warehouse Builder
3.1.11
Oracle Warehouse Builder External Table Data Pump Support
3.1.12
Oracle Warehouse Builder External Table Preprocessor Support
3.1.13
Compressed Table and Partition Support in Oracle Warehouse Builder
3.1.14
Support for PL/SQL Native Compilation
4
Oracle Database 11
g
Documentation
4.1
Documentation Titles and Online Documentation Structure
4.1.1
Oracle® Database 11
g
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
Scripting on this page enhances content navigation, but does not change the content in any way.