11g R2 New Features

Application Development

Application Express:

• Application Date Format
• Custom Themes
• BLOB Support
• JavaScript Libraries
• Report Printing (Enhanced)
• Forms Conversion
• Security (Enhanced)
• Runtime-Only Install

General Features:

•  Pro*C
•  “WITH HOLD” Option for Cursors
•  8-byte Numeric host Variable
•  Pro*COBOL
•  8-byte Numeric host Variable

JDBC

• TZ Patching
• SecureFile Zero-Copy

OCI

• 8-byte Numeric host Variable

Availability

• Backup and Recovery:
• Automatic Block Repair
• OSB Cloud Module (Amazon Service)
• DUPLICATE
• Without Target Connection
• NOREDO and “UNDO TABLSPACE”
• Tablespace Checks
• TSPITR (Enhanced)
• “SET NEWNAME” format and clauses  

Online Maintenance and Upgrade:

• Edition Based Redefinition
• “CREATE OR REPLACE TYPE” to Allow FORCE
• Fine-Grained Dependencies for Triggers
• IGNORE_ROW_ON_DUPKEY_INDEX Hint (Insert Statement)

 Data Guard:

• Compressed Table (Logical Standby and LogMiner)
• Real-Time Query Lagging
• FAN Support
• 30 Standby Databases

BI and Data Warehousing

Analytics:

• Analytic Functions 2.0
• Recursive WITH

Data Loading:

• EXECUTE Privilege for Directory Objects
• ORACLE_LOADER Access Driver Extended

Partitioning:

• Virtual Columns in PK or FK
• System-Managed Indexes for List Partitions

Performance and Scalability:

• In-Memory Parallel Execution
• Auto POD
• DBMS_PARALLEL_EXECUTE Package
• On-Commit Fast Refresh (Significant Performance Improvement)

Warehouse Builder:

• Mapping Editor
• Advanced Find
• Copy and Paste of Operators and Attributes
• Grouping and Spotlighting of Objects
• Business Intelligence Tool Integration (BI Standard and Enterprise)
• Current Configuration Dropdown in Design Center
• Flat File Imports (Enhanced Support)
• Table Function (Enhanced Support)
• Experts Available in Editor Menu
• Expression Editing in Operator Edit
• Management/UI of Locations Registered (Enhanced)
• Key Lookup Operator (Enhanced)
• Mapping Debugger (Enhanced)
• JDeveloper-Style UI
• Operator References Included in Generated PL/SQL Code
• Quick Mapper
• Repository Browser (Enhanced)
• Simplified Repository Upgrades
• LONG Data Type Data Extraction (Supported)
• Sub-Queries in Join Operator (Supported)

Clustering :RAC in-use

• Cluster Time Service
• Oracle Cluster Registry (Enhancements)
• Voting Disk (Enhancements)
• Grid Plug and Play
• Oracle Restart
• Policy-Based Cluster/Capacity Management
• Clusterware Resource Modeling (Enhanced)
• Role-Separated Management
• Agent Development Framework
• Zero Downtime Patching (Clusterware and RAC)
• Out-of-Place Clusterware Upgrade
• Server Control (SRVCTL)
• Oracle Restart (Support)
• Grid Plug and Play (Support)
• Single Instance Database in a Cluster (Support)
• Universal Connection Pool (UCP)
• Data Guard Integration
• RAC Integration
• JDBC (Support)
• Enterprise Manager
• Clusterware Resource Management
• Provisioning (Clusterware and RAC)
• Grid Plug and Play (Support)
• Oracle Restart (Support)
• Universal Installer
• Removing RAC (Support)
• Installation Rollback
• Oracle Restart Integration
• Out-of-Place Upgrade (Support)
• Fixup Scripts and Grid Infrastructure Checks
• Typical Installation (Option)
• Single Client Access Name (SCAN)
• Downgrade Database Configured with DBControl
• Java API for RAC FAN Events
• Intelligent Platform Management Interface (IPMI) Integration
• ASM Integration with Clusterware
• Configuration Assistants
• New Features (Support)
• Removing RAC (Support)
• Cluster Verification Utility
• New Features (Enhanced)
• Integration into Universal Installer

Database General:

• Flashback Data Archive DDL (Support)
• Instance Caging
• Scheduler:
• E-mail Notification
• File Watcher
• Multiple Destination Jobs
• Remote Database Jobs
• Utilities:
• Data Pump Legacy Mode
• IPv6:
• JDBC Thin Clients (Support)
• JVM and Java Debuggers (Support)
• Smart Flash Cache
• Stored Outline Migration to SQL Plan Management
• Client Result Cache Using Table Annotations (Support)
• 4 KB Sector Disk Drive (Support)

Security

• Audit Data Management:
• Audit Trail Cleanup
• Encryption Key Management
• Tablespace Master Key Rekey

Server Management

• Automatic Storage Management (ASM) for all Data
• ASM Dynamic Volume Manager (DVM)
• ASM Cluster File System (ACFS)
• ASM FS Snapshot
• Oracle Cluster Registry (OCR) and Voting Disk
• ASM Intelligent Data Placement
• ASM Configuration Assistant
• ASM File Access Control
• ASMCMD (Extension)
• Enterprise Manager Integration
• ACFS (Support)
• ASM File Access Control
• EMCA for New RAC Configurations (Support)
• Patch Application with DBConsole (Single-Instance)
• Automatic Patching of Time Stamp w/ Time Zone Data
• Prevent Data Loss with Local Time Zone Data Type
• Segment Creation on Demand
• Zero-Sized Unusable Indexes and Index Partitions
• Metadata SXML Comparison Tool
• Compare Period Report
• Compare SQL Tuning Sets
• Sampling for Active Data Guard
• Exadata Simulation
• Global RAC ASH Report and ADDM Backward Compatability
• Replay capture on MTS and Streams (Support)
• SQL Tuning Advisor (Support)
• Parallel Query (Auto DOP)
• Action Plan Recording
• Export SQL Tuning Set (STS)
• Replay Synchronization Controls

Multimedia and DICOM:

• Extraction of Requested Attributes Only
• Client –Side DICOM Attribute Extraction
• DICOM (Enhancements)
• Watermarking and Image Processing (Enhancements)

Spatial:

• 3D Visualization Framework
• Network Data Model (Enhancements)
• GeoRaster JAVA API
• Raster Reprojections and Ground Control Point-Based Georeferencing
• Routing and Geocoding (Enhancements)

SecureFiles:

• Database File System (DBFS)
• LZO Compression (Support)

XML DB:

• Binary XML (Enhancements)
• XML DB Repository Performance (Enhancements)
• XMLIndex (Enhancements)
• XMLType Partitioning