Oracle 11g New Features

[Vinod Sadanandan]

All,

Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features .

Precompilers: Additional Array INSERT and SELECT Syntax Support by
Pro*C/C++ and Pro*COBOL
Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL
Precompilers: Fix Execution Plan in Pro*C/C++ and Pro*COBOL
Precompilers: Flexible B Area Length for Pro*COBOL
Precompilers: Implicit Buffered Insert in Pro*C/C++ and Pro*COBOL
Precompilers: Platform Endianness Support by Pro*COBOL
Precompilers: Scrollable Cursor Support in Pro*COBOL
Precompilers: SQL Syntax Support by Pro*C/C++
Application Express
Application and Schema Comparison
Drag and Drop Item Layout
Flash Charts
Friendly URL Syntax to Facilitate Bookmarks
Improved Web Services
Improved Workspace Management
Microsoft Access Migration
New Password and Account Controls
Page and Region Caching
Extensible Indexing
Create Rules and Actions for DML Events With Rules Manager
Enhanced Rules Manager
New Capabilities for Domain Index Operations
Oracle Text Predicates and Aggregate Operators are Included in Rule Conditions
Oracle Text Predicates Included in Stored Expressions
System-Managed Partitioning of Extensible Indexes
Globalization and Unicode
Unicode Support
OracleJVM Java/JDK Compatibility
OracleJVM JIT Configuration
OracleJVM JIT (Transparent Native Java Compilation Without a C Compiler)
OracleJVM Ease-of-Use: JDK-Like Interface
OracleJVM Ease-of-Use: Property Management Interface
OracleJVM Ease-of-Use: Output Redirect
OracleJVM Ease of Use: Database Resident Jars
OracleJVM Ease of Use: Two-Tier Java Session Termination
OracleJVM Utilities Enhancements
OracleJVM Manageability: JMX Interface
JDBC and SQLJ
JDBC Connection and Statement Enhancements
JDBC Support for New Data Types
JDBC Support for ANYTYPE, ANYDATA, and ANYDATASET
JDBC Support for Continuous Query Notification
JDBC Support for Database Diagnosability
JDBC Support for Database Startup and Shutdown
JDBC Support for Native Streams AQ Protocol
JDBC-Thin Support for Oracle Advanced Security
SQLJ: Enhanced Profile Print Option of the Customizer
SQLJ: Outline Generation Option
SQLJ: Support for JDK
SQLJ: XA Support
Oracle Developer Tools for Visual Studio NET
General Visual Studio Support
Oracle PL/SQL Debugger in Visual Studio
Support for Visual Studio Data Sources Window and Designers
Oracle Data Provider for NET (ODPNET)
Provider-Independent API Using Base Classes and Factories
Connection String Builder
OracleDataAdapter Batch Processing
Row-Level Change Notifications
Schema Discovery
Data Source Enumeration
Faster LOB Retrieval
Improved Parameter Context Caching in Statement Caching
Oracle Provider for OLE DB
Faster Performance
Improved Metadata Caching
Improved Statement Caching
Database Resident Connection Pooling (DRCP)
XA API Available Within PL/SQL
Allow Sequences in PL/SQL Expressions
Enhancements to the Regular Expression Built-Ins
Functional Completeness of Dynamic SQL for PL/SQL
Method Invocation Scoping Operator
Named and Mixed Notation for User-Defined PL/SQL Subprogram in a SQL
Statement
New Compound Trigger Type
PL/SQL CONTINUE Statement
PL/SQL Hierarchical Profiler
PL/SQL Inlining Optimization
SIMPLE_INTEGER Data Type
XML Application Development
Binary XML Support for Java
Binary XML Support for Oracle XML DB
Configurable DOM Support for Java
Event-Based XML Pull Parsing for C
High Performance XPath Query for Java
In-Place XML Schema Evolution
Mid-Tier XQuery Engine Performance Improvements
Pluggable DOM Support for Java
Scalable and High Performance XML Validation for C
Scalable DOM Support for Java
Unified Java API for XML
Unified Java API for XML
XMLDiff Support for C
XMLIndex Enhancements
Availability Interfaces in Oracle Enterprise Manager
Browser-Based Enterprise Manager Integrated Interface for LogMiner
Data Guard Improvements
Fast-Start Failover for Maximum Performance Mode in a Data Guard
Configuration
Compression of Redo Traffic (Only for Gap Resolution) Over the Network in a
Data Guard Configuration
Real-Time Query Capability of Physical Standby Database
Fast Role Transitions in a Data Guard Configuration
User Configurable Conditions to Initiate Fast-Start Failover in a Data Guard
Data Guard Integration, Simplification, and Performance
Dynamic Setting of Oracle Data Guard SQL Apply Parameters
Enhanced Data Guard Broker Based Management Framework
Enhanced Data Guard Management Interface (Using SQL*Plus)
Histogram for Redo Transport Response Time in a Data Guard Configuration
Snapshot Standby
Strong Authentication for Data Guard Redo Transport
Enhanced DDL Handling in Oracle Data Guard SQL Apply
Enhanced Oracle RAC Switchover Support for Logical Standby Databases
Data Guard Logical Apply Completeness
Oracle Scheduler Support in Data Guard SQL Apply
Fine-Grained Auditing (FGA) Support in Data Guard SQL Apply
Support Transparent Data Encryption (TDE) with Data Guard SQL Apply
Support XMLType Data Type (Only CLOB) in Data Guard SQL Apply
Virtual Private Database (VPD) Support in Data Guard SQL Apply
High Availability Improvements
Flashback Transaction
SMP Scalable Redo Apply
Transportable Databases Between Linux and Windows
Information Life Cycle Management
Flashback Data Archive
Integration, Simplification, and Performance of Availability Features
Automatic Reporting of Corrupt Blocks
Block Media Recovery Performance Improvements
Creation and Recovery of Long-Term Backups Improved
End-to-End Redo Validation
Merge Catalogs
Parallel Backup and Restore for Very Large Files
Intelligent Data Protection and Repair
Data Recovery Advisor
Enhance LogMiner to Support Automatic Data Repair
Integrated Protection From Various Data Corruptions
Lost-Write Detection Using a Physical Standby Database
Online Application Maintenance and Upgrade
DDL With the WAIT Option
Enhanced ADD COLUMN Functionality
Finer Grained Dependencies
Invisible Indexes
Materialized View Logging Control
Minimize Dependent PL/SQL Recompilation After Online Table Redefinition
Online Index Creation and Rebuild Enhancements
Online Redefinition for Tables with Materialized View Logs
Read-Only Tables
RMAN Integration, Simplification, and Performance
Archive Log Management Improvements
Fast Incremental Backups on Physical Standby Database
Improved Backup Compression Performance
Improved Integration with Data Guard
Network-Aware DUPLICATE Command
Optimized Undo Backup
Read-Only Transported Tablespaces Backup
Database Overall
Utilities
Compressed Dump File Sets
Data Pump API Enhancements
Database Upgrade/Downgrade Enhancements
Direct Path API Multiple Subtype Support
Encrypted Dump File Sets
Enhancements to Metadata API
Oracle Data Pump External Table Enhancement
Single Partition Transportable for Oracle Data Pump
SQL*Plus BLOB Support
Business Intelligence and Data Warehousing
Complete the Information Cycle
Change Data Purge Enhancements
Change Subscription Enhancements
Enabling or Disabling Synchronous Change Data Capture
Enhanced DML Tracking
Enhanced Materialized View Catalog Views
Query Rewrite Enhancement to Support Queries Containing Inline Views
Query Rewrite Support of Queries on Remote Tables
Refresh Performance Improvements
Enable the Information Grid
Composite List-Hash Partitioning
Composite List-List Partitioning
Composite List-Range Partitioning
Composite Range-Range Partitioning
Interval Partitioning
Metadata for SQL Built-In Operators and Functions
OLTP Table Compression
Reference Partitioning
SQL PIVOT and UNPIVOT Operators
Virtual Column-Based Partitioning
OLAP in Every Data Warehouse
Cost-Based Aggregation of OLAP Cubes
Cube Organized Materialized Views
Fine-Grained Partitioning of OLAP Cubes
OLAP Security Enhancements
SQL Optimizer Support for OLAP Option Cubes and Dimensions
Storage and Access Improvements of Compressed Cubes
Unified OLAP API Metadata Change Management
Predictive Analytics and Data Mining
Automated and Embedded Data Transformations for Mining (Supermodels)
Data Mining Schema Objects
Java API for Oracle Data Mining (JSR- and JSR-)
Multivariate Linear Regression
Multivariate Logistic Regression
Predictive Analytics: PROFILE
SQL Prediction Enhancements
Clustering
Oracle Real Application Clusters Ease-of-Use
Enhanced Oracle RAC Monitoring and Diagnostics in Enterprise Manager
Enhanced Oracle Real Application Clusters Configuration Assistants
OCI Runtime Connection Load Balancing
Parallel Execution for Oracle Real Application Clusters
Support for Distributed Transactions in an Oracle RAC Environment
Content Management Services
Oracle SecureFiles
Fast Bulk Data Transfers
LOB Prefetch
SecureFiles
SecureFiles: Compression
SecureFiles: Deduplication
SecureFiles: Encryption
Text Manageability
Improved Support for Advanced Features in More Languages
Incremental Indexing Enhancements
Oracle Enterprise Manager Support for Text
Re-Create Index Online
Text Performance and Scalability
Composite Index
More Types of Operations Allowed on Document Sections
Text Support for Very Large Number of Partitions
User-Defined Score
XML Content Management Platform
Content Repository Management (JSR-) Support for Java
XML Database
DAV ACL Support
Enable the XDB HTTP Server for SOA
Large Text Node Handling
Oracle XML DB Repository Triggers
Recursive Schema Handling
Repository Performance Improvements
Scalable XSL Output
SQL/XML Standards Compliance and Performance Optimizations
Support for More Types of Links in XDB
XLink Support in XML DB
XML DB Operational Completeness
XML Query Optimization with Schemaless or Weakly-Typed Schema-Based XML
XML Translation Support
XML Update Performance Optimizations
XMLIndex
XQuery and SQL/XML Performance Improvements
XQuery Standards Conformance
XSLT Performance Improvements
Fault Diagnosability
Ease Diagnosis
Automatic Inter-Component Deadlock Detection
Hang Manager
Incident Packaging Service (IPS)
SQL Test Case Builder
First-Failure Capture
Automatic Diagnostic Repository
Enhanced Network Diagnosability
OCI Diagnosability
Intelligent Resolution
Improved Block Corruption Detection
SQL Repair Advisor
Problem Prevention
Automatic Health Monitoring
Automatic Quarantine of Corrupt Undo Segments
Fast ANALYZE: Finding Table-Index Corruptions
Holistic Undo Health Monitoring
Support Workbench
Support Workbench
Information Integration
Information Grid: Computation at Scale
Event Notification Grouping and Management
Oracle Scheduler for Streams Jobs
Scalability for Streams Notifications
Information Grid: Heterogeneous Information
Messaging Gateway Service-Based Failover
Multiple Messaging Gateway Agents in Oracle RAC Environments
Simplified Messaging Gateway Propagation Job Configuration
Database Gateways: Performance Improvements
Database Gateway for Adabas
Database Gateway for IMS
Database Gateway for VSAM
More Granular Change Notifications
Continuous Query Notification Enhancements
Streams Support for XMLType and TDE
Additional Data Type Support for Streams
Location Services and Specialty Data
New Capabilities for Management of Geospatial and Multimedia Data
Spatial: -D Geometry, Surface, and Point Cloud Storage and Indexing Functions
Spatial Web Services
Spatial Routing Engine Enhancements
Spatial Network Data Model Enhancements
Load-On-Demand for Very Large Networks in Oracle Spatial Network Data
Spatial GeoRaster: Manageability, Reliability, Usability Enhancements
Enhanced Workspace Manager Performance and Data Storage Options
Enhanced Workspace Manager Security and Administration
Improved Workspace Manager Valid Time Usability
Oracle Multimedia Performance and Scalability
New Capabilities for Medical Data
Multimedia DICOM Medical Imaging Format Support
ORDDicom Object Type
DICOM Metadata Extraction
DICOM Conformance Validation
DICOM Image Processing
Making DICOM Content Anonymous
Creation of DICOM Content
Runtime Updatable DICOM Data Model
New Capabilities for RFID
RFID Identity Code Data Type for EPC, DoD, and Custom Sensor Tags
New Capabilities for Semantic Data
Improved Performance for Bulk Loading
Support for Storage and Query of Semantic Content
Manageability
Automatic Storage Management
ASM Fast Mirror Resync
ASM Manageability Enhancements
ASM Preferred Mirror Read
ASM Rolling Upgrade
ASM Scalability and Performance Enhancements
Convert Single-Instance ASM to Clustered ASM
New SYSASM Privilege for ASM Administration
Change Assurance
Database Replay
SQL Performance Analyzer
Database Control
Advanced Replication Cutover
ASM Enhancements
Change Manager - Sync and Propagate
Database Cloning Enhancements
Database Configuration (ECM) Collection Enhancements
Database Home Page and Performance Page Improvements
DBCA Enhancements
DBUA Enhancements
Enhanced Adaptive Metric Thresholds
Fusion Requirements
Management of Oracle Text Indexes
Migrate Database to ASM - Enhancements in Enterprise Manager
Storage / Audit Report and Metric Enhancement
Storage: Schema, Security, and Configuration Enhancements
Wait Activity Detail Enhancement
Workspace Manager
Holistic Database Management
ADDM for Oracle Real Application Clusters
Intelligent Infrastructure
Auto-Task
Automatic Maintenance Tasks Management
Automatic Workload Repository (AWR) Baselines
Database Statistics Model Consolidation
Enhanced Active Session History
Enhanced Advisor Framework
Lightweight Jobs
Scheduling External Jobs on Multiple Nodes
Simplified Initialization Parameter Management
Resource Manageability
I/O Calibration
I/O Statistics
Per Session I/O Limits
Resource Manager Statistics in AWR
Resource Plans
Simplify Configuration
Enhanced Optimal Flexible Architecture (OFA) Support
Space, Object and Transaction Manageability
AUM Default Setting and Migration Support
Enhanced Statistics Collection for Partitioned Objects
Simplified Temp Space Management
SQL Manageability
Automatic SQL Tuning with Self-Learning Capabilities
Enhanced Optimizer Statistics Maintenance
Multi-Column Statistics
Partition Advisor
SQL Plan Management
Streams Manageability
Automated Alerts for Streams
Divergence Detection and Resolution
Split and Merge of Streams
Streams Message Tracking
Streams Performance Advisor
Streams Topology
Synchronous Streams Capture
Performance
General Server Performance
Direct NFS Client
Enhanced Partition Pruning Capabilities
Intelligent Cursor Sharing
NLS Performance Improvements
Improve Basic SQL and PL/SQL

Binding and Defining Multiple Buffers in OCI
Bitmap Join Index Support for Index-Organized Tables
Cost-Based Optimizer Enhancements
Network/OCI Fusion
OCI Descriptor Array Allocation
OCI Implicit ROWID Fetching
PL/SQL Function Result Cache
PL/SQL Native Compilation Without Needing a Third-Party C Compiler
Query Result Cache
Optimize Key Platforms
ODBC Performance Improvement
Security
Oracle Advanced Security
Kerberos Cross Realm Support
SYSDBA Strong Authentication
Tablespace Encryption[/b]

Thanks & Regards,
Vinod Sadanandan
Oracle DBA

[amitpatel66]

All,

Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features .

Precompilers: Additional Array INSERT and SELECT Syntax Support by
Pro*C/C++ and Pro*COBOL
Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL
Precompilers: Fix Execution Plan in Pro*C/C++ and Pro*COBOL
Precompilers: Flexible B Area Length for Pro*COBOL
Precompilers: Implicit Buffered Insert in Pro*C/C++ and Pro*COBOL
Precompilers: Platform Endianness Support by Pro*COBOL
Precompilers: Scrollable Cursor Support in Pro*COBOL
Precompilers: SQL Syntax Support by Pro*C/C++
Application Express
Application and Schema Comparison
Drag and Drop Item Layout
Flash Charts
Friendly URL Syntax to Facilitate Bookmarks
Improved Web Services
Improved Workspace Management
Microsoft Access Migration
New Password and Account Controls
Page and Region Caching
Extensible Indexing
Create Rules and Actions for DML Events With Rules Manager
Enhanced Rules Manager
New Capabilities for Domain Index Operations
Oracle Text Predicates and Aggregate Operators are Included in Rule Conditions
Oracle Text Predicates Included in Stored Expressions
System-Managed Partitioning of Extensible Indexes
Globalization and Unicode
Unicode Support
OracleJVM Java/JDK Compatibility
OracleJVM JIT Configuration
OracleJVM JIT (Transparent Native Java Compilation Without a C Compiler)
OracleJVM Ease-of-Use: JDK-Like Interface
OracleJVM Ease-of-Use: Property Management Interface
OracleJVM Ease-of-Use: Output Redirect
OracleJVM Ease of Use: Database Resident Jars
OracleJVM Ease of Use: Two-Tier Java Session Termination
OracleJVM Utilities Enhancements
OracleJVM Manageability: JMX Interface
JDBC and SQLJ
JDBC Connection and Statement Enhancements
JDBC Support for New Data Types
JDBC Support for ANYTYPE, ANYDATA, and ANYDATASET
JDBC Support for Continuous Query Notification
JDBC Support for Database Diagnosability
JDBC Support for Database Startup and Shutdown
JDBC Support for Native Streams AQ Protocol
JDBC-Thin Support for Oracle Advanced Security
SQLJ: Enhanced Profile Print Option of the Customizer
SQLJ: Outline Generation Option
SQLJ: Support for JDK
SQLJ: XA Support
Oracle Developer Tools for Visual Studio NET
General Visual Studio Support
Oracle PL/SQL Debugger in Visual Studio
Support for Visual Studio Data Sources Window and Designers
Oracle Data Provider for NET (ODPNET)
Provider-Independent API Using Base Classes and Factories
Connection String Builder
OracleDataAdapter Batch Processing
Row-Level Change Notifications
Schema Discovery
Data Source Enumeration
Faster LOB Retrieval
Improved Parameter Context Caching in Statement Caching
Oracle Provider for OLE DB
Faster Performance
Improved Metadata Caching
Improved Statement Caching
Database Resident Connection Pooling (DRCP)
XA API Available Within PL/SQL
Allow Sequences in PL/SQL Expressions
Enhancements to the Regular Expression Built-Ins
Functional Completeness of Dynamic SQL for PL/SQL
Method Invocation Scoping Operator
Named and Mixed Notation for User-Defined PL/SQL Subprogram in a SQL
Statement
New Compound Trigger Type
PL/SQL CONTINUE Statement
PL/SQL Hierarchical Profiler
PL/SQL Inlining Optimization
SIMPLE_INTEGER Data Type
XML Application Development
Binary XML Support for Java
Binary XML Support for Oracle XML DB
Configurable DOM Support for Java
Event-Based XML Pull Parsing for C
High Performance XPath Query for Java
In-Place XML Schema Evolution
Mid-Tier XQuery Engine Performance Improvements
Pluggable DOM Support for Java
Scalable and High Performance XML Validation for C
Scalable DOM Support for Java
Unified Java API for XML
Unified Java API for XML
XMLDiff Support for C
XMLIndex Enhancements
Availability Interfaces in Oracle Enterprise Manager
Browser-Based Enterprise Manager Integrated Interface for LogMiner
Data Guard Improvements
Fast-Start Failover for Maximum Performance Mode in a Data Guard
Configuration
Compression of Redo Traffic (Only for Gap Resolution) Over the Network in a
Data Guard Configuration
Real-Time Query Capability of Physical Standby Database
Fast Role Transitions in a Data Guard Configuration
User Configurable Conditions to Initiate Fast-Start Failover in a Data Guard
Data Guard Integration, Simplification, and Performance
Dynamic Setting of Oracle Data Guard SQL Apply Parameters
Enhanced Data Guard Broker Based Management Framework
Enhanced Data Guard Management Interface (Using SQL*Plus)
Histogram for Redo Transport Response Time in a Data Guard Configuration
Snapshot Standby
Strong Authentication for Data Guard Redo Transport
Enhanced DDL Handling in Oracle Data Guard SQL Apply
Enhanced Oracle RAC Switchover Support for Logical Standby Databases
Data Guard Logical Apply Completeness
Oracle Scheduler Support in Data Guard SQL Apply
Fine-Grained Auditing (FGA) Support in Data Guard SQL Apply
Support Transparent Data Encryption (TDE) with Data Guard SQL Apply
Support XMLType Data Type (Only CLOB) in Data Guard SQL Apply
Virtual Private Database (VPD) Support in Data Guard SQL Apply
High Availability Improvements
Flashback Transaction
SMP Scalable Redo Apply
Transportable Databases Between Linux and Windows
Information Life Cycle Management
Flashback Data Archive
Integration, Simplification, and Performance of Availability Features
Automatic Reporting of Corrupt Blocks
Block Media Recovery Performance Improvements
Creation and Recovery of Long-Term Backups Improved
End-to-End Redo Validation
Merge Catalogs
Parallel Backup and Restore for Very Large Files
Intelligent Data Protection and Repair
Data Recovery Advisor
Enhance LogMiner to Support Automatic Data Repair
Integrated Protection From Various Data Corruptions
Lost-Write Detection Using a Physical Standby Database
Online Application Maintenance and Upgrade
DDL With the WAIT Option
Enhanced ADD COLUMN Functionality
Finer Grained Dependencies
Invisible Indexes
Materialized View Logging Control
Minimize Dependent PL/SQL Recompilation After Online Table Redefinition
Online Index Creation and Rebuild Enhancements
Online Redefinition for Tables with Materialized View Logs
Read-Only Tables
RMAN Integration, Simplification, and Performance
Archive Log Management Improvements
Fast Incremental Backups on Physical Standby Database
Improved Backup Compression Performance
Improved Integration with Data Guard
Network-Aware DUPLICATE Command
Optimized Undo Backup
Read-Only Transported Tablespaces Backup
Database Overall
Utilities
Compressed Dump File Sets
Data Pump API Enhancements
Database Upgrade/Downgrade Enhancements
Direct Path API Multiple Subtype Support
Encrypted Dump File Sets
Enhancements to Metadata API
Oracle Data Pump External Table Enhancement
Single Partition Transportable for Oracle Data Pump
SQL*Plus BLOB Support
Business Intelligence and Data Warehousing
Complete the Information Cycle
Change Data Purge Enhancements
Change Subscription Enhancements
Enabling or Disabling Synchronous Change Data Capture
Enhanced DML Tracking
Enhanced Materialized View Catalog Views
Query Rewrite Enhancement to Support Queries Containing Inline Views
Query Rewrite Support of Queries on Remote Tables
Refresh Performance Improvements
Enable the Information Grid
Composite List-Hash Partitioning
Composite List-List Partitioning
Composite List-Range Partitioning
Composite Range-Range Partitioning
Interval Partitioning
Metadata for SQL Built-In Operators and Functions
OLTP Table Compression
Reference Partitioning
SQL PIVOT and UNPIVOT Operators
Virtual Column-Based Partitioning
OLAP in Every Data Warehouse
Cost-Based Aggregation of OLAP Cubes
Cube Organized Materialized Views
Fine-Grained Partitioning of OLAP Cubes
OLAP Security Enhancements
SQL Optimizer Support for OLAP Option Cubes and Dimensions
Storage and Access Improvements of Compressed Cubes
Unified OLAP API Metadata Change Management
Predictive Analytics and Data Mining
Automated and Embedded Data Transformations for Mining (Supermodels)
Data Mining Schema Objects
Java API for Oracle Data Mining (JSR- and JSR-)
Multivariate Linear Regression
Multivariate Logistic Regression
Predictive Analytics: PROFILE
SQL Prediction Enhancements
Clustering
Oracle Real Application Clusters Ease-of-Use
Enhanced Oracle RAC Monitoring and Diagnostics in Enterprise Manager
Enhanced Oracle Real Application Clusters Configuration Assistants
OCI Runtime Connection Load Balancing
Parallel Execution for Oracle Real Application Clusters
Support for Distributed Transactions in an Oracle RAC Environment
Content Management Services
Oracle SecureFiles
Fast Bulk Data Transfers
LOB Prefetch
SecureFiles
SecureFiles: Compression
SecureFiles: Deduplication
SecureFiles: Encryption
Text Manageability
Improved Support for Advanced Features in More Languages
Incremental Indexing Enhancements
Oracle Enterprise Manager Support for Text
Re-Create Index Online
Text Performance and Scalability
Composite Index
More Types of Operations Allowed on Document Sections
Text Support for Very Large Number of Partitions
User-Defined Score
XML Content Management Platform
Content Repository Management (JSR-) Support for Java
XML Database
DAV ACL Support
Enable the XDB HTTP Server for SOA
Large Text Node Handling
Oracle XML DB Repository Triggers
Recursive Schema Handling
Repository Performance Improvements
Scalable XSL Output
SQL/XML Standards Compliance and Performance Optimizations
Support for More Types of Links in XDB
XLink Support in XML DB
XML DB Operational Completeness
XML Query Optimization with Schemaless or Weakly-Typed Schema-Based XML
XML Translation Support
XML Update Performance Optimizations
XMLIndex
XQuery and SQL/XML Performance Improvements
XQuery Standards Conformance
XSLT Performance Improvements
Fault Diagnosability
Ease Diagnosis
Automatic Inter-Component Deadlock Detection
Hang Manager
Incident Packaging Service (IPS)
SQL Test Case Builder
First-Failure Capture
Automatic Diagnostic Repository
Enhanced Network Diagnosability
OCI Diagnosability
Intelligent Resolution
Improved Block Corruption Detection
SQL Repair Advisor
Problem Prevention
Automatic Health Monitoring
Automatic Quarantine of Corrupt Undo Segments
Fast ANALYZE: Finding Table-Index Corruptions
Holistic Undo Health Monitoring
Support Workbench
Support Workbench
Information Integration
Information Grid: Computation at Scale
Event Notification Grouping and Management
Oracle Scheduler for Streams Jobs
Scalability for Streams Notifications
Information Grid: Heterogeneous Information
Messaging Gateway Service-Based Failover
Multiple Messaging Gateway Agents in Oracle RAC Environments
Simplified Messaging Gateway Propagation Job Configuration
Database Gateways: Performance Improvements
Database Gateway for Adabas
Database Gateway for IMS
Database Gateway for VSAM
More Granular Change Notifications
Continuous Query Notification Enhancements
Streams Support for XMLType and TDE
Additional Data Type Support for Streams
Location Services and Specialty Data
New Capabilities for Management of Geospatial and Multimedia Data
Spatial: -D Geometry, Surface, and Point Cloud Storage and Indexing Functions
Spatial Web Services
Spatial Routing Engine Enhancements
Spatial Network Data Model Enhancements
Load-On-Demand for Very Large Networks in Oracle Spatial Network Data
Spatial GeoRaster: Manageability, Reliability, Usability Enhancements
Enhanced Workspace Manager Performance and Data Storage Options
Enhanced Workspace Manager Security and Administration
Improved Workspace Manager Valid Time Usability
Oracle Multimedia Performance and Scalability
New Capabilities for Medical Data
Multimedia DICOM Medical Imaging Format Support
ORDDicom Object Type
DICOM Metadata Extraction
DICOM Conformance Validation
DICOM Image Processing
Making DICOM Content Anonymous
Creation of DICOM Content
Runtime Updatable DICOM Data Model
New Capabilities for RFID
RFID Identity Code Data Type for EPC, DoD, and Custom Sensor Tags
New Capabilities for Semantic Data
Improved Performance for Bulk Loading
Support for Storage and Query of Semantic Content
Manageability
Automatic Storage Management
ASM Fast Mirror Resync
ASM Manageability Enhancements
ASM Preferred Mirror Read
ASM Rolling Upgrade
ASM Scalability and Performance Enhancements
Convert Single-Instance ASM to Clustered ASM
New SYSASM Privilege for ASM Administration
Change Assurance
Database Replay
SQL Performance Analyzer
Database Control
Advanced Replication Cutover
ASM Enhancements
Change Manager - Sync and Propagate
Database Cloning Enhancements
Database Configuration (ECM) Collection Enhancements
Database Home Page and Performance Page Improvements
DBCA Enhancements
DBUA Enhancements
Enhanced Adaptive Metric Thresholds
Fusion Requirements
Management of Oracle Text Indexes
Migrate Database to ASM - Enhancements in Enterprise Manager
Storage / Audit Report and Metric Enhancement
Storage: Schema, Security, and Configuration Enhancements
Wait Activity Detail Enhancement
Workspace Manager
Holistic Database Management
ADDM for Oracle Real Application Clusters
Intelligent Infrastructure
Auto-Task
Automatic Maintenance Tasks Management
Automatic Workload Repository (AWR) Baselines
Database Statistics Model Consolidation
Enhanced Active Session History
Enhanced Advisor Framework
Lightweight Jobs
Scheduling External Jobs on Multiple Nodes
Simplified Initialization Parameter Management
Resource Manageability
I/O Calibration
I/O Statistics
Per Session I/O Limits
Resource Manager Statistics in AWR
Resource Plans
Simplify Configuration
Enhanced Optimal Flexible Architecture (OFA) Support
Space, Object and Transaction Manageability
AUM Default Setting and Migration Support
Enhanced Statistics Collection for Partitioned Objects
Simplified Temp Space Management
SQL Manageability
Automatic SQL Tuning with Self-Learning Capabilities
Enhanced Optimizer Statistics Maintenance
Multi-Column Statistics
Partition Advisor
SQL Plan Management
Streams Manageability
Automated Alerts for Streams
Divergence Detection and Resolution
Split and Merge of Streams
Streams Message Tracking
Streams Performance Advisor
Streams Topology
Synchronous Streams Capture
Performance
General Server Performance
Direct NFS Client
Enhanced Partition Pruning Capabilities
Intelligent Cursor Sharing
NLS Performance Improvements
Improve Basic SQL and PL/SQL

Binding and Defining Multiple Buffers in OCI
Bitmap Join Index Support for Index-Organized Tables
Cost-Based Optimizer Enhancements
Network/OCI Fusion
OCI Descriptor Array Allocation
OCI Implicit ROWID Fetching
PL/SQL Function Result Cache
PL/SQL Native Compilation Without Needing a Third-Party C Compiler
Query Result Cache
Optimize Key Platforms
ODBC Performance Improvement
Security
Oracle Advanced Security
Kerberos Cross Realm Support
SYSDBA Strong Authentication
Tablespace Encryption[/b]

Thanks & Regards,
Vinod Sadanandan
Oracle DBA

Vinod,

This forum is mainly for providing the solution to some technical problems and not for preparing test cases.
DO POST back in case if you have any technical issues!!

Thanks!!

[pritikumari]

RMAN Enhancements in 11g.
Duplicating a Database.
Creating a Standby Database with the DUPLICATE Command.
Parallel Backup and Restore for Very Large Files.
IMPORT CATALOG RMAN Command.
RMAN Data Recovery Commands.
RMAN Security Enhancements.
Improved Integration of RMAN and Data Guard.

JOIN Oracle Training In Noida.