Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Oracle 11g Database New Features

• 1.1 Application Development
  • 1.1.1 APIs and Precompilers
    • 1.1.1.1 Client-Side Query Cache
    • 1.1.1.2 OCI Client Session NLS Character Set Status Information
    • 1.1.1.3 Precompilers: Additional Array INSERT and SELECT Syntax Support by Pro*C/C++ and Pro*COBOL
    • 1.1.1.4 Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL
    • 1.1.1.5 Precompilers: Fix Execution Plan in Pro*C/C++ and Pro*COBOL
    • 1.1.1.6 Precompilers: Flexible B Area Length for Pro*COBOL
    • 1.1.1.7 Precompilers: Implicit Buffered Insert in Pro*C/C++ and Pro*COBOL
    • 1.1.1.8 Precompilers: Platform Endianness Support by Pro*COBOL
    • 1.1.1.9 Precompilers: Scrollable Cursor Support in Pro*COBOL
    • 1.1.1.10 Precompilers: SQL99 Syntax Support by Pro*C/C++
  • 1.1.2 Application Express
    • 1.1.2.1 Application and Schema Comparison
    • 1.1.2.2 Drag and Drop Item Layout
    • 1.1.2.3 Flash Charts
    • 1.1.2.4 Friendly URL Syntax to Facilitate Bookmarks
    • 1.1.2.5 Improved Web Services
    • 1.1.2.6 Improved Workspace Management
    • 1.1.2.7 Microsoft Access Migration
    • 1.1.2.8 New Password and Account Controls
    • 1.1.2.9 Page and Region Caching
    • 1.1.2.10 PDF Printing
  • 1.1.3 Extensible Indexing
    • 1.1.3.1 Create Rules and Actions for DML Events With Rules Manager
    • 1.1.3.2 Enhanced Rules Manager
    • 1.1.3.3 New Capabilities for Domain Index Operations
    • 1.1.3.4 Oracle Text Predicates and Aggregate Operators are Included in Rule Conditions
    • 1.1.3.5 Oracle Text Predicates Included in Stored Expressions
    • 1.1.3.6 System-Managed Partitioning of Extensible Indexes
  • 1.1.4 Globalization and Unicode
    • 1.1.4.1 Unicode 5.0 Support
  • 1.1.5 Java in the Database
    • 1.1.5.1 OracleJVM Java/JDK 5.0 Compatibility
    • 1.1.5.2 OracleJVM JIT Configuration
    • 1.1.5.3 OracleJVM JIT (Transparent Native Java Compilation Without a C Compiler)
    • 1.1.5.4 OracleJVM Ease-of-Use: JDK-Like Interface
    • 1.1.5.5 OracleJVM Ease-of-Use: Property Management Interface
    • 1.1.5.6 OracleJVM Ease-of-Use: Output Redirect
    • 1.1.5.7 OracleJVM Ease of Use: Database Resident Jars
    • 1.1.5.8 OracleJVM Ease of Use: Two-Tier Java Session Termination
    • 1.1.5.9 OracleJVM Utilities Enhancements
    • 1.1.5.10 OracleJVM Manageability: JMX Interface
  • 1.1.6 JDBC and SQLJ
    • 1.1.6.1 JDBC 4.0 Connection and Statement Enhancements
    • 1.1.6.2 JDBC 4.0 Support for New Data Types
    • 1.1.6.3 JDBC Support for ANYTYPE, ANYDATA, and ANYDATASET
    • 1.1.6.4 JDBC Support for Continuous Query Notification
    • 1.1.6.5 JDBC Support for Database Diagnosability
    • 1.1.6.6 JDBC Support for Database Startup and Shutdown
    • 1.1.6.7 JDBC Support for Native Streams AQ Protocol
    • 1.1.6.8 JDBC-Thin Support for Oracle Advanced Security
    • 1.1.6.9 SQLJ: Enhanced Profile Print Option of the Customizer
    • 1.1.6.10 SQLJ: Outline Generation Option
    • 1.1.6.11 SQLJ: Support for JDK 1.5
    • 1.1.6.12 SQLJ: XA Support
  • 1.1.7 Oracle Developer Tools for Visual Studio .NET
    • 1.1.7.1 General Visual Studio 2005 Support
    • 1.1.7.2 Oracle PL/SQL Debugger in Visual Studio
    • 1.1.7.3 Support for Visual Studio 2005 Data Sources Window and Designers
  • 1.1.8 Oracle Data Provider for .NET (ODP.NET)
    • 1.1.8.1 Provider-Independent API Using Base Classes and Factories
    • 1.1.8.2 Connection String Builder
    • 1.1.8.3 OracleDataAdapter Batch Processing
    • 1.1.8.4 Row-Level Change Notifications
    • 1.1.8.5 Schema Discovery
    • 1.1.8.6 Data Source Enumeration
    • 1.1.8.7 Faster LOB Retrieval
    • 1.1.8.8 Improved Parameter Context Caching in Statement Caching
  • 1.1.9 Oracle Provider for OLE DB
    • 1.1.9.1 Faster Performance
    • 1.1.9.2 Improved Metadata Caching
    • 1.1.9.3 Improved Statement Caching
  • 1.1.10 PHP
    • 1.1.10.1 Database Resident Connection Pooling (DRCP)
  • 1.1.11 PL/SQL
    • 1.1.11.1 XA API Available Within PL/SQL
    • 1.1.11.2 Allow Sequences in PL/SQL Expressions
    • 1.1.11.3 Enhancements to the Regular Expression Built-Ins
    • 1.1.11.4 Functional Completeness of Dynamic SQL for PL/SQL
    • 1.1.11.5 Method Invocation Scoping Operator
    • 1.1.11.6 Named and Mixed Notation for User-Defined PL/SQL Subprogram in a SQL Statement
    • 1.1.11.7 New Compound Trigger Type
    • 1.1.11.8 PL/Scope
    • 1.1.11.9 PL/SQL CONTINUE Statement
    • 1.1.11.10 PL/SQL Hierarchical Profiler
    • 1.1.11.11 PL/SQL Inlining Optimization
    • 1.1.11.12 SIMPLE_INTEGER Data Type
  • 1.1.12 XML Application Development
    • 1.1.12.1 Binary XML Support for Java
    • 1.1.12.2 Binary XML Support for Oracle XML DB
    • 1.1.12.3 Configurable DOM Support for Java
    • 1.1.12.4 Event-Based XML Pull Parsing for C
    • 1.1.12.5 High Performance XPath Query for Java
    • 1.1.12.6 In-Place XML Schema Evolution
    • 1.1.12.7 Mid-Tier XQuery Engine Performance Improvements
    • 1.1.12.8 Pluggable DOM Support for Java
    • 1.1.12.9 Scalable and High Performance XML Validation for C
    • 1.1.12.10 Scalable DOM Support for Java
    • 1.1.12.11 Unified Java API for XML
    • 1.1.12.12 Unified Java API for XML
    • 1.1.12.13 XMLDiff Support for C
    • 1.1.12.14 XMLIndex Enhancements
• 1.2 Availability
  • 1.2.1 Availability Interfaces in Oracle Enterprise Manager
    • 1.2.1.1 Browser-Based Enterprise Manager Integrated Interface for LogMiner
  • 1.2.2 Data Guard Improvements
    • 1.2.2.1 Fast-Start Failover for Maximum Performance Mode in a Data Guard Configuration
    • 1.2.2.2 Compression of Redo Traffic (Only for Gap Resolution) Over the Network in a Data Guard Configuration
    • 1.2.2.3 Real-Time Query Capability of Physical Standby Database
    • 1.2.2.4 Fast Role Transitions in a Data Guard Configuration
    • 1.2.2.5 User Configurable Conditions to Initiate Fast-Start Failover in a Data Guard Configuration
  • 1.2.3 Data Guard Integration, Simplification, and Performance
    • 1.2.3.1 Dynamic Setting of Oracle Data Guard SQL Apply Parameters
    • 1.2.3.2 Enhanced Data Guard Broker Based Management Framework
    • 1.2.3.3 Enhanced Data Guard Management Interface (Using SQL*Plus)
    • 1.2.3.4 Histogram for Redo Transport Response Time in a Data Guard Configuration
    • 1.2.3.5 Snapshot Standby
    • 1.2.3.6 Strong Authentication for Data Guard Redo Transport
    • 1.2.3.7 Enhanced DDL Handling in Oracle Data Guard SQL Apply
    • 1.2.3.8 Enhanced Oracle RAC Switchover Support for Logical Standby Databases
  • 1.2.4 Data Guard Logical Apply Completeness
    • 1.2.4.1 Oracle Scheduler Support in Data Guard SQL Apply
    • 1.2.4.2 Fine-Grained Auditing (FGA) Support in Data Guard SQL Apply
    • 1.2.4.3 Support Transparent Data Encryption (TDE) with Data Guard SQL Apply
    • 1.2.4.4 Support XMLType Data Type (Only CLOB) in Data Guard SQL Apply
    • 1.2.4.5 Virtual Private Database (VPD) Support in Data Guard SQL Apply
  • 1.2.5 High Availability Improvements
    • 1.2.5.1 Flashback Transaction
    • 1.2.5.2 SMP Scalable Redo Apply
    • 1.2.5.3 Transportable Databases Between Linux and Windows
  • 1.2.6 Information Life Cycle Management
    • 1.2.6.1 Flashback Data Archive
  • 1.2.7 Integration, Simplification, and Performance of Availability Features
    • 1.2.7.1 Automatic Reporting of Corrupt Blocks
    • 1.2.7.2 Block Media Recovery Performance Improvements
    • 1.2.7.3 Creation and Recovery of Long-Term Backups Improved
    • 1.2.7.4 End-to-End Redo Validation
    • 1.2.7.5 Merge Catalogs
    • 1.2.7.6 Parallel Backup and Restore for Very Large Files
  • 1.2.8 Intelligent Data Protection and Repair
    • 1.2.8.1 Data Recovery Advisor
    • 1.2.8.2 Enhance LogMiner to Support Automatic Data Repair
    • 1.2.8.3 Integrated Protection From Various Data Corruptions
    • 1.2.8.4 Lost-Write Detection Using a Physical Standby Database
  • 1.2.9 Online Application Maintenance and Upgrade
    • 1.2.9.1 DDL With the WAIT Option
    • 1.2.9.2 Enhanced ADD COLUMN Functionality
    • 1.2.9.3 Finer Grained Dependencies
    • 1.2.9.4 Invisible Indexes
    • 1.2.9.5 Materialized View Logging Control
    • 1.2.9.6 Minimize Dependent PL/SQL Recompilation After Online Table Redefinition
    • 1.2.9.7 Online Index Creation and Rebuild Enhancements
    • 1.2.9.8 Online Redefinition for Tables with Materialized View Logs
    • 1.2.9.9 Read-Only Tables
  • 1.2.10 RMAN Integration, Simplification, and Performance
    • 1.2.10.1 Archive Log Management Improvements
    • 1.2.10.2 Fast Incremental Backups on Physical Standby Database
    • 1.2.10.3 Improved Backup Compression Performance
    • 1.2.10.4 Improved Integration with Data Guard
    • 1.2.10.5 Network-Aware DUPLICATE Command
    • 1.2.10.6 Optimized Undo Backup
    • 1.2.10.7 Read-Only Transported Tablespaces Backup
• 1.3 Database Overall
  • 1.3.1 Utilities
    • 1.3.1.1 Compressed Dump File Sets
    • 1.3.1.2 Data Pump API Enhancements
    • 1.3.1.3 Database Upgrade/Downgrade Enhancements
    • 1.3.1.4 Direct Path API Multiple Subtype Support
    • 1.3.1.5 Encrypted Dump File Sets
    • 1.3.1.6 Enhancements to Metadata API
    • 1.3.1.7 Oracle Data Pump External Table Enhancement
    • 1.3.1.8 Single Partition Transportable for Oracle Data Pump
    • 1.3.1.9 SQL*Plus BLOB Support
• 1.4 Business Intelligence and Data Warehousing
  • 1.4.1 Complete the Information Cycle
    • 1.4.1.1 Change Data Purge Enhancements
    • 1.4.1.2 Change Subscription Enhancements
    • 1.4.1.3 Enabling or Disabling Synchronous Change Data Capture
    • 1.4.1.4 Enhanced DML Tracking
    • 1.4.1.5 Enhanced Materialized View Catalog Views
    • 1.4.1.6 Query Rewrite Enhancement to Support Queries Containing Inline Views
    • 1.4.1.7 Query Rewrite Support of Queries on Remote Tables
    • 1.4.1.8 Refresh Performance Improvements
  • 1.4.2 Enable the Information Grid
    • 1.4.2.1 Composite List-Hash Partitioning
    • 1.4.2.2 Composite List-List Partitioning
    • 1.4.2.3 Composite List-Range Partitioning
    • 1.4.2.4 Composite Range-Range Partitioning
    • 1.4.2.5 Interval Partitioning
    • 1.4.2.6 Metadata for SQL Built-In Operators and Functions
    • 1.4.2.7 OLTP Table Compression
    • 1.4.2.8 Reference Partitioning
    • 1.4.2.9 SQL PIVOT and UNPIVOT Operators
    • 1.4.2.10 System Partitioning
    • 1.4.2.11 Virtual Columns
    • 1.4.2.12 Virtual Column-Based Partitioning
  • 1.4.3 OLAP in Every Data Warehouse
    • 1.4.3.1 Cost-Based Aggregation of OLAP Cubes
    • 1.4.3.2 Cube Organized Materialized Views
    • 1.4.3.3 Fine-Grained Partitioning of OLAP Cubes
    • 1.4.3.4 OLAP Security Enhancements
    • 1.4.3.5 SQL Optimizer Support for OLAP Option Cubes and Dimensions
    • 1.4.3.6 Storage and Access Improvements of Compressed Cubes
    • 1.4.3.7 Unified OLAP API Metadata Change Management
  • 1.4.4 Predictive Analytics and Data Mining
    • 1.4.4.1 Automated and Embedded Data Transformations for Mining (Supermodels)
    • 1.4.4.2 Data Mining Schema Objects
    • 1.4.4.3 Java API for Oracle Data Mining (JSR-73 and JSR-247)
    • 1.4.4.4 Multivariate Linear Regression
    • 1.4.4.5 Multivariate Logistic Regression
    • 1.4.4.6 Predictive Analytics: PROFILE
    • 1.4.4.7 SQL Prediction Enhancements
• 1.5 Clustering
  • 1.5.1 Oracle Real Application Clusters Ease-of-Use
    • 1.5.1.1 Enhanced Oracle RAC Monitoring and Diagnostics in Enterprise Manager
    • 1.5.1.2 Enhanced Oracle Real Application Clusters Configuration Assistants
    • 1.5.1.3 OCI Runtime Connection Load Balancing
    • 1.5.1.4 Parallel Execution for Oracle Real Application Clusters
    • 1.5.1.5 Support for Distributed Transactions in an Oracle RAC Environment
• 1.6 Content Management Services
  • 1.6.1 Oracle SecureFiles
    • 1.6.1.1 Fast Bulk Data Transfers
    • 1.6.1.2 LOB Prefetch
    • 1.6.1.3 SecureFiles
    • 1.6.1.4 SecureFiles: Compression
    • 1.6.1.5 SecureFiles: Deduplication
    • 1.6.1.6 SecureFiles: Encryption
  • 1.6.2 Text Manageability
    • 1.6.2.1 Improved Support for Advanced Features in More Languages
    • 1.6.2.2 Incremental Indexing Enhancements
    • 1.6.2.3 Oracle Enterprise Manager Support for Text
    • 1.6.2.4 Re-Create Index Online
  • 1.6.3 Text Performance and Scalability
    • 1.6.3.1 Composite Index
    • 1.6.3.2 More Types of Operations Allowed on Document Sections
    • 1.6.3.3 Text Support for Very Large Number of Partitions
    • 1.6.3.4 User-Defined Score
  • 1.6.4 XML Content Management Platform
    • 1.6.4.1 Content Repository Management (JSR-170) Support for Java
  • 1.6.5 XML Database
    • 1.6.5.1 DAV ACL Support
    • 1.6.5.2 Enable the XDB HTTP Server for SOA
    • 1.6.5.3 Large Text Node Handling
    • 1.6.5.4 Oracle XML DB Repository Triggers
    • 1.6.5.5 Recursive Schema Handling
    • 1.6.5.6 Repository Performance Improvements
    • 1.6.5.7 Scalable XSL Output
    • 1.6.5.8 SQL/XML Standards Compliance and Performance Optimizations
    • 1.6.5.9 Support for More Types of Links in XDB
    • 1.6.5.10 XLink Support in XML DB
    • 1.6.5.11 XML DB Operational Completeness
    • 1.6.5.12 XML Query Optimization with Schemaless or Weakly-Typed Schema-Based XML
    • 1.6.5.13 XML Translation Support
    • 1.6.5.14 XML Update Performance Optimizations
    • 1.6.5.15 XMLIndex
    • 1.6.5.16 XQuery and SQL/XML Performance Improvements
    • 1.6.5.17 XQuery Standards Conformance
    • 1.6.5.18 XSLT Performance Improvements
• 1.7 Fault Diagnosability
  • 1.7.1 Ease Diagnosis
    • 1.7.1.1 Automatic Inter-Component Deadlock Detection
    • 1.7.1.2 Hang Manager
    • 1.7.1.3 Incident Packaging Service (IPS)
    • 1.7.1.4 SQL Test Case Builder
  • 1.7.2 First-Failure Capture
    • 1.7.2.1 Automatic Diagnostic Repository
    • 1.7.2.2 Enhanced Network Diagnosability
    • 1.7.2.3 OCI Diagnosability
  • 1.7.3 Intelligent Resolution
    • 1.7.3.1 Improved Block Corruption Detection
    • 1.7.3.2 SQL Repair Advisor
  • 1.7.4 Problem Prevention
    • 1.7.4.1 Automatic Health Monitoring
    • 1.7.4.2 Automatic Quarantine of Corrupt Undo Segments
    • 1.7.4.3 Fast ANALYZE: Finding Table-Index Corruptions
    • 1.7.4.4 Holistic Undo Health Monitoring
  • 1.7.5 Support Workbench
    • 1.7.5.1 Support Workbench
• 1.8 Information Integration
  • 1.8.1 Information Grid: Computation at Scale
    • 1.8.1.1 Event Notification Grouping and Management
    • 1.8.1.2 Oracle Scheduler for Streams Jobs
    • 1.8.1.3 Scalability for Streams Notifications
  • 1.8.2 Information Grid: Heterogeneous Information
    • 1.8.2.1 Messaging Gateway Service-Based Failover
    • 1.8.2.2 Multiple Messaging Gateway Agents in Oracle RAC Environments
    • 1.8.2.3 Simplified Messaging Gateway Propagation Job Configuration
    • 1.8.2.4 Database Gateways: Performance Improvements
    • 1.8.2.5 Database Gateway for Adabas
    • 1.8.2.6 Database Gateway for IMS
    • 1.8.2.7 Database Gateway for VSAM
  • 1.8.3 More Granular Change Notifications
    • 1.8.3.1 Continuous Query Notification Enhancements
  • 1.8.4 Streams Support for XMLType and TDE
    • 1.8.4.1 Additional Data Type Support for Streams
• 1.9 Location Services and Specialty Data
  • 1.9.1 New Capabilities for Management of Geospatial and Multimedia Data
    • 1.9.1.1 Spatial: 3-D Geometry, Surface, and Point Cloud Storage and Indexing Functions
    • 1.9.1.2 Spatial Web Services
    • 1.9.1.3 Spatial Routing Engine Enhancements
    • 1.9.1.4 Spatial Network Data Model Enhancements
    • 1.9.1.5 Load-On-Demand for Very Large Networks in Oracle Spatial Network Data Model
    • 1.9.1.6 Spatial GeoRaster: Manageability, Reliability, Usability Enhancements
    • 1.9.1.7 Enhanced Workspace Manager Performance and Data Storage Options
    • 1.9.1.8 Enhanced Workspace Manager Security and Administration
    • 1.9.1.9 Improved Workspace Manager Valid Time Usability
    • 1.9.1.10 Oracle Multimedia Performance and Scalability
  • 1.9.2 New Capabilities for Medical Data
    • 1.9.2.1 Multimedia DICOM Medical Imaging Format Support
    • 1.9.2.2 ORDDicom Object Type
    • 1.9.2.3 DICOM Metadata Extraction
    • 1.9.2.4 DICOM Conformance Validation
    • 1.9.2.5 DICOM Image Processing
    • 1.9.2.6 Making DICOM Content Anonymous
    • 1.9.2.7 Creation of DICOM Content
    • 1.9.2.8 Runtime Updatable DICOM Data Model
  • 1.9.3 New Capabilities for RFID
    • 1.9.3.1 RFID Identity Code Data Type for EPC, DoD, and Custom Sensor Tags
  • 1.9.4 New Capabilities for Semantic Data
    • 1.9.4.1 Improved Performance for Bulk Loading
    • 1.9.4.2 Support for Storage and Query of Semantic Content
• 1.10 Manageability
  • 1.10.1 Automatic Storage Management
    • 1.10.1.1 ASM Fast Mirror Resync
    • 1.10.1.2 ASM Manageability Enhancements
    • 1.10.1.3 ASM Preferred Mirror Read
    • 1.10.1.4 ASM Rolling Upgrade
    • 1.10.1.5 ASM Scalability and Performance Enhancements
    • 1.10.1.6 Convert Single-Instance ASM to Clustered ASM
    • 1.10.1.7 New SYSASM Privilege for ASM Administration
  • 1.10.2 Change Assurance
    • 1.10.2.1 Database Replay
    • 1.10.2.2 SQL Performance Analyzer
  • 1.10.3 Database Control
    • 1.10.3.1 Advanced Replication Cutover
    • 1.10.3.2 ASM Enhancements
    • 1.10.3.3 Change Manager - Sync and Propagate
    • 1.10.3.4 Database Cloning Enhancements
    • 1.10.3.5 Database Configuration (ECM) Collection Enhancements
    • 1.10.3.6 Database Home Page and Performance Page Improvements
    • 1.10.3.7 DBCA Enhancements
    • 1.10.3.8 DBUA Enhancements
    • 1.10.3.9 Enhanced Adaptive Metric Thresholds
    • 1.10.3.10 Fusion Requirements
    • 1.10.3.11 Management of Oracle Text Indexes
    • 1.10.3.12 Migrate Database to ASM - Enhancements in Enterprise Manager
    • 1.10.3.13 Storage / Audit Report and Metric Enhancement
    • 1.10.3.14 Storage: Schema, Security, and Configuration Enhancements
    • 1.10.3.15 Wait Activity Detail Enhancement
    • 1.10.3.16 Workspace Manager
  • 1.10.4 Holistic Database Management
    • 1.10.4.1 ADDM for Oracle Real Application Clusters
  • 1.10.5 Intelligent Infrastructure
    • 1.10.5.1 Auto-Task
    • 1.10.5.2 Automatic Maintenance Tasks Management
    • 1.10.5.3 Automatic Workload Repository (AWR) Baselines
    • 1.10.5.4 Database Statistics Model Consolidation
    • 1.10.5.5 Enhanced Active Session History
    • 1.10.5.6 Enhanced Advisor Framework
    • 1.10.5.7 Lightweight Jobs
    • 1.10.5.8 Scheduling External Jobs on Multiple Nodes
    • 1.10.5.9 Simplified Initialization Parameter Management
  • 1.10.6 Resource Manageability
    • 1.10.6.1 I/O Calibration
    • 1.10.6.2 I/O Statistics
    • 1.10.6.3 Per Session I/O Limits
    • 1.10.6.4 Resource Manager Statistics in AWR
    • 1.10.6.5 Resource Plans
  • 1.10.7 Simplify Configuration
    • 1.10.7.1 Enhanced Optimal Flexible Architecture (OFA) Support
  • 1.10.8 Space, Object and Transaction Manageability
    • 1.10.8.1 AUM Default Setting and Migration Support
    • 1.10.8.2 Enhanced Statistics Collection for Partitioned Objects
    • 1.10.8.3 Simplified Temp Space Management
  • 1.10.9 SQL Manageability
    • 1.10.9.1 Automatic SQL Tuning with Self-Learning Capabilities
    • 1.10.9.2 Enhanced Optimizer Statistics Maintenance
    • 1.10.9.3 Multi-Column Statistics
    • 1.10.9.4 Partition Advisor
    • 1.10.9.5 SQL Plan Management
  • 1.10.10 Streams Manageability
    • 1.10.10.1 Automated Alerts for Streams
    • 1.10.10.2 Divergence Detection and Resolution
    • 1.10.10.3 Split and Merge of Streams
    • 1.10.10.4 Streams Message Tracking
    • 1.10.10.5 Streams Performance Advisor
    • 1.10.10.6 Streams Topology
    • 1.10.10.7 Synchronous Streams Capture
• 1.11 Performance
  • 1.11.1 General Server Performance
    • 1.11.1.1 Direct NFS Client
    • 1.11.1.2 Enhanced Partition Pruning Capabilities
    • 1.11.1.3 Intelligent Cursor Sharing
    • 1.11.1.4 NLS Performance Improvements
  • 1.11.2 Improve Basic SQL and PL/SQL
    • 1.11.2.1 Binding and Defining Multiple Buffers in OCI
    • 1.11.2.2 Bitmap Join Index Support for Index-Organized Tables
    • 1.11.2.3 Cost-Based Optimizer Enhancements
    • 1.11.2.4 Network/OCI Fusion
    • 1.11.2.5 OCI Descriptor Array Allocation
    • 1.11.2.6 OCI Implicit ROWID Fetching
    • 1.11.2.7 PL/SQL Function Result Cache
    • 1.11.2.8 PL/SQL Native Compilation Without Needing a Third-Party C Compiler
    • 1.11.2.9 Query Result Cache
  • 1.11.3 Optimize Key Platforms
    • 1.11.3.1 ODBC Performance Improvement
• 1.12 Security
  • 1.12.1 Oracle Advanced Security
    • 1.12.1.1 Kerberos Cross Realm Support
    • 1.12.1.2 SYSDBA Strong Authentication
    • 1.12.1.3 Tablespace Encryption
    • 1.12.1.4 Hardware-Based Master Key Protection
  • 1.12.2 Secure by Default
    • 1.12.2.1 Audit By Default
    • 1.12.2.2 Built-in Password Complexity Checker
    • 1.12.2.3 Built-in User Profile
    • 1.12.2.4 Fine-Grained Access Control on Network Call-outs from the Database
    • 1.12.2.5 Improve Security for Network Administration, Registration, and Operation
    • 1.12.2.6 Parameters for Enhanced Security of Database Communication
    • 1.12.2.7 Support Nonanonymous LDAP Access for Net Naming
  • 1.12.3 Security Manageability
    • 1.12.3.1 Integrated Database Security Manageability
    • 1.12.3.2 Virtual Private Catalog
  • 1.12.4 Stronger Password Protection
    • 1.12.4.1 Standards-Based Password Algorithm
• 1.13 Windows
  • 1.13.1 Integration with Windows Services
    • 1.13.1.1 Active Directory Security Enhancements
    • 1.13.1.2 Volume Shadow Copy Service (VSS) Writer

2 Oracle Database 11g Documentation

• 2.1 Documentation Titles and Online Documentation Structure
  • 2.1.1 Oracle® Database 11g Windows Documentation
  • 2.1.2 Oracle® Database 11g Server Library
  • 2.1.3 Oracle® Database 11g OLAP Documentation
  • 2.1.4 Oracle® Database 11g Data Mining Documentation
  • 2.1.5 Oracle® Database 11g Spatial Documentation
  • 2.1.6 Oracle® Database 11g Java Documentation
  • 2.1.7 Oracle® Database 11g Linux x86 Documentation
  • 2.1.8 Oracle® Database 11g Release Notes Documentation
  • 2.1.9 Oracle® Database 11g Installation Guide Documentation
  • 2.1.10 Oracle® Database 11g Documentation Library