Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Oracle Database 10g New Features

• 1.1 Application Development
  • 1.1.1 Application Program Interface (API) and Precompilers
    • 1.1.1.1 Oracle Open Database Connectivity (ODBC) Driver Support for Linux
    • 1.1.1.2 Oracle Call Interface (OCI) Client Version API
    • 1.1.1.3 Start Up and Shut Down of Database OCI API
    • 1.1.1.4 Oracle C++ Call Interface (OCCI) Transparent Application Failover Support
    • 1.1.1.5 Instant Client Light
    • 1.1.1.6 Instant Client Software Development Kit (SDK)
  • 1.1.2 Globalization and Unicode Improvements
    • 1.1.2.1 Unicode 4.0
    • 1.1.2.2 Unicode Data Type Literal Enhancement
    • 1.1.2.3 Globalization Development Kit (GDK) 2.0
    • 1.1.2.4 Character Set Scanner (CSSCAN) Enhancements
    • 1.1.2.5 Language and Character Set File Scanner (LCSSCAN) Enhancements
    • 1.1.2.6 Consistent Linguistic Searching and Sorting
    • 1.1.2.7 Transliteration for Japanese Kana Conversion
  • 1.1.3 Java, Java Database Connectivity (JDBC), and Web Services
    • 1.1.3.1 JDBC XA Connections Caching
    • 1.1.3.2 JDBC Runtime Connection Load Balancing
    • 1.1.3.3 JDBC Support for Data Manipulation Language (DML) in the RETURNING Clause
    • 1.1.3.4 Support for JDBC 3.0 ResultSet Holdability
    • 1.1.3.5 Support for JDBC 3.0 Retrieval of Auto-Generated Key
  • 1.1.4 Oracle HTML DB Improvements
    • 1.1.4.1 Cluster Bar Charts
    • 1.1.4.2 Dial Charts
    • 1.1.4.3 Percentage Bar Charts
    • 1.1.4.4 Stacked Bar Charts
    • 1.1.4.5 Asynchronous Refresh for All Charts Based on Scalable Vector Graphics (SVG)
    • 1.1.4.6 Create Master Detail With Choice of Layout
    • 1.1.4.7 Application From a Spreadsheet Wizard
    • 1.1.4.8 Create Forms and Reports Based on a Web Service Reference
    • 1.1.4.9 Discover Web Services Through UDDI Repository
    • 1.1.4.10 Simplified and More Consistent User Interface
  • 1.1.5 PL/SQL Improvements
    • 1.1.5.1 PL/SQL Conditional Compilation
    • 1.1.5.2 Obfuscation of Dynamically Generated PL/SQL Source Code
    • 1.1.5.3 Relaxation of Line Length and Overall Limits for the DBMS_OUTPUT PL/SQL Package
    • 1.1.5.4 UTL_NLA PL/SQL Package for Matrix Math
  • 1.1.6 SQL Language Improvements
    • 1.1.6.1 Rules Manager
    • 1.1.6.2 Regular Expression Enhancements
    • 1.1.6.3 Collection Operator Performance Improvements
    • 1.1.6.4 Distributed Large Objects (LOB) Support
    • 1.1.6.5 Expression Filter Enhancements
  • 1.1.7 XML Application Development
    • 1.1.7.1 XQuery
    • 1.1.7.2 Advanced XPath Rewrite
    • 1.1.7.3 New InsertXML(), AppendChildXML(), InsertXMLBefore(), and DeleteXML() Functions
    • 1.1.7.4 Simple Object Access Protocol (SOAP) 1.2 Implementation in C/C++
    • 1.1.7.5 SQL/XML Standard (SQL:2003 Standard Part 14) Compliance
    • 1.1.7.6 SQL/XML Standard Compliance
    • 1.1.7.7 Easy XML Application Development Using JAXB Customization
    • 1.1.7.8 Oracle XML Developer's Kit (XDK) PL/SQL Document Object Model (DOM) API Deprecation
    • 1.1.7.9 XPath 2.0 and XQuery 1.0 Functions and Operators Support in Java
    • 1.1.7.10 Custom Metadata for Oracle XML DB Repository Resources
    • 1.1.7.11 Secure Sockets Layer (SSL) Support
    • 1.1.7.12 Transportable Tablespace Support
    • 1.1.7.13 Oracle XML DB Administration in the Enterprise Manager Web Console
• 1.2 Availability
  • 1.2.1 Fast-Start Failover to Standby Database
    • 1.2.1.1 Fast-Start Failover
    • 1.2.1.2 Automatic Conversion of the Primary Database to a Standby Database Upon Failover
    • 1.2.1.3 Optimized Asynchronous Redo Transmission
    • 1.2.1.4 Faster Redo Apply Failover
    • 1.2.1.5 Faster SQL Apply Failover
  • 1.2.2 Support for Database Transport Across Same Endian Platforms
    • 1.2.2.1 Database Transport Across Same Endian Platforms
  • 1.2.3 High Availability Improvements
    • 1.2.3.1 Add and Create a Transportable Tablespace to a Database
    • 1.2.3.2 Additional Data Type Support in LogMiner and SQL Apply
    • 1.2.3.3 Automatic Deletion of Applied Archive Logs
    • 1.2.3.4 Data Guard: Improved Manageability for Redo Transport, Log Apply, and Broker
    • 1.2.3.5 Dynamic RMAN Channel Allocation for Backing Up and Recovering RAC Database
    • 1.2.3.6 RMAN Backup Encryption
    • 1.2.3.7 Easy Conversion of a Physical Standby Database to a Reporting Database
    • 1.2.3.8 Eliminate Control File Re-Creation
    • 1.2.3.9 Enhanced Memory Corruption Checking
    • 1.2.3.10 Enhanced RMAN Backup Job Views
    • 1.2.3.11 Enhanced Server Side Shutdown
    • 1.2.3.12 Enhanced Space Management Verification
    • 1.2.3.13 Failover Improvements for Real Application Clusters (RAC) Distributed Transactions
    • 1.2.3.14 Faster Instance Startup for Large Memory Configurations
    • 1.2.3.15 Fine-Grained, Automated Tracking of SQL Apply Runtime Performance
    • 1.2.3.16 Flashback Across Data Guard Switchovers
    • 1.2.3.17 Flashback Database Through Resetlogs
    • 1.2.3.18 Hardware Assisted Resilient Data (HARD) Compliant RMAN Backups
    • 1.2.3.19 Increase Supported Real Application Clusters Instances for a Database
    • 1.2.3.20 Incremental Roll Forward of Database Copy
    • 1.2.3.21 Online Redefinition Supports Clustered Tables, ADT's, MV Logs, AQ Tables, and Preserves Database Statistics
    • 1.2.3.22 Online Redefinition of a Single Partition
    • 1.2.3.23 Optimized Creation of Logical Standby Database
    • 1.2.3.24 Unused Block Compression
    • 1.2.3.25 Reorganized Object Types Improves User Interface
    • 1.2.3.26 Restore Point
    • 1.2.3.27 Temporary Datafiles Are Re-Created on RMAN Recovery
• 1.3 Business Intelligence
  • 1.3.1 SQL Support for Analytic Applications
    • 1.3.1.1 Enhanced Upsert Abilities in MODEL Clause
    • 1.3.1.2 Enhancements to MODEL Rules Which Use FOR Loops
    • 1.3.1.3 Use of Analytic Functions in the SQL MODEL Clause
    • 1.3.1.4 Intra-Partition DML in the Presence of Bitmap Indexes
  • 1.3.2 Improved Very Large Database (VLDB) Support
    • 1.3.2.1 Increased Maximum Number of Partitions Per Object
    • 1.3.2.2 Enhanced Dynamic Partition Pruning
    • 1.3.2.3 Resource Optimized DROP TABLE for Partitioned Tables
  • 1.3.3 Reduced Information Cycle Time
    • 1.3.3.1 Distributed Asynchronous Change Data Capture (CDC)
    • 1.3.3.2 DML Error Logging Table
    • 1.3.3.3 Partition Change Tracking Refresh Without Materialized View Logs
    • 1.3.3.4 Query Rewrite Using Multiple Materialized Views
    • 1.3.3.5 Skip Level Dimension Hierarchies
  • 1.3.4 Online Analytical Processing (OLAP) Support for Analytic Applications
    • 1.3.4.1 Incremental Aggregation of Compressed OLAP Cubes
    • 1.3.4.2 OLAP API Supports Calculated (Virtual) Dimension Members
    • 1.3.4.3 OLAP Compressed Cubes Support Semiadditive Aggregation Methods
  • 1.3.5 Data Mining Support for Analytic Applications
    • 1.3.5.1 Decision Tree Algorithm
    • 1.3.5.2 Predictive Analytics Package
    • 1.3.5.3 SQL-Level Data Mining Scoring Capability
    • 1.3.5.4 Java Data Mining (JDM) Compliant Java API
• 1.4 Clustering
  • 1.4.1 Real Application Clusters (RAC) Performance
    • 1.4.1.1 Load Balancing Advisory
    • 1.4.1.2 Oracle Cluster File System for Solaris
  • 1.4.2 Real Application Clusters Robustness
    • 1.4.2.1 Clusterware File Redundancy
    • 1.4.2.2 Cluster Verification
    • 1.4.2.3 Cluster Tracing and Diagnostic Enhancements
  • 1.4.3 Application High Availability With Oracle Clusterware
    • 1.4.3.1 High Availability API
• 1.5 Content Management
  • 1.5.1 Oracle Text Improvements
    • 1.5.1.1 CTXRULE Asian Language Support
    • 1.5.1.2 Filtering
    • 1.5.1.3 Key Word in Context (KWIC)
    • 1.5.1.4 Online Indexing for Local Partitioned Index
  • 1.5.2 interMedia Improvements
    • 1.5.2.1 interMedia DICOM Medical Imaging Format Support
    • 1.5.2.2 interMedia Support for Image Content Metadata and XML DB Integration
    • 1.5.2.3 Java Advanced Imaging 1.1.2 Support
• 1.6 Database Overall
  • 1.6.1 Database Utilities
    • 1.6.1.1 Easier Manual Upgrades
    • 1.6.1.2 Enhanced Pre-Upgrade Information Utility
    • 1.6.1.3 Default DATA_PUMP_DIR Directory Object
    • 1.6.1.4 Dumpfile Compression
    • 1.6.1.5 Extended Job Status Display
    • 1.6.1.6 FILESIZE Value for Dumpfiles
    • 1.6.1.7 Monitoring of Data Pump Jobs Started Outside of Enterprise Manager
    • 1.6.1.8 New DBMS_DATAPUMP API Calls
    • 1.6.1.9 New PCTSPACE Transform Parameter on Data Pump Import
    • 1.6.1.10 Object ID (OID) Transform Parameter
    • 1.6.1.11 SQL*Plus AUTOTRACE EXPLAIN Conversion to DBMS_XPLAN
    • 1.6.1.12 SQL*Plus DBMS_OUTPUT Buffer and Line Size Limit Increase
    • 1.6.1.13 SQL*Plus XQuery Support
• 1.7 Database Security
  • 1.7.1 Privacy and Confidentiality
    • 1.7.1.1 Transparent Data Encryption
    • 1.7.1.2 Key Management for Data Encryption
  • 1.7.2 Improved Manageability
    • 1.7.2.1 Enhanced Proxy Authentication
    • 1.7.2.2 Audit Trail in Standard XML Format
  • 1.7.3 Secure By Default
    • 1.7.3.1 Connect Role Privilege Reduction
  • 1.7.4 Improved Integration and Interoperability
    • 1.7.4.1 Secure External Password Store
    • 1.7.4.2 Enhanced Centralized Password Policies for the Database
    • 1.7.4.3 Oracle Label Security Support for Real Application Clusters
• 1.8 Grid Computing
  • 1.8.1 Data Provisioning
    • 1.8.1.1 File Groups Repository
    • 1.8.1.2 Transportable Tablespace from Backup
  • 1.8.2 Oracle Scheduler
    • 1.8.2.1 Event Scheduling
    • 1.8.2.2 Job Chaining
    • 1.8.2.3 Scheduler Enhancements
• 1.9 Grid Management
  • 1.9.1 Configuration Plug-ins and Assistants
    • 1.9.1.1 Enterprise Manager Configuration Plug-in
    • 1.9.1.2 Migrate Non-ASM Databases to ASM
    • 1.9.1.3 Standalone Automatic Storage Management (ASM) Configuration
    • 1.9.1.4 Standalone Disk Group Management
    • 1.9.1.5 Upgrade 10.1 Database to 10.2
  • 1.9.2 Database Management
    • 1.9.2.1 Ability to Discover and Update Host Cluster Targets in Enterprise Manager
    • 1.9.2.2 Access Advisor Enhancements in Enterprise Manager
    • 1.9.2.3 Backup and Recovery Configuration Enhancements in Enterprise Manager
    • 1.9.2.4 Clone External Objects as Part of the Cloning Operation
    • 1.9.2.5 Database Administration Enhancements in Enterprise Manager
    • 1.9.2.6 Database Auditing Administration in Enterprise Manager
    • 1.9.2.7 Enable or Disable Undo Retention Guarantee
    • 1.9.2.8 Enhanced Backup Management
    • 1.9.2.9 Enhanced Diagnostics for Cache Coherency Statistics
    • 1.9.2.10 Integrate Segment Advisor with Segment Findings
    • 1.9.2.11 Lock and Unlock Statistics
    • 1.9.2.12 Management of Directory Objects in the Enterprise Manager Web Console
    • 1.9.2.13 Miscellaneous Undo Advisor User Interface Enhancements
    • 1.9.2.14 New Storage and Configuration Policies
    • 1.9.2.15 Oracle Spatial Administration in the Enterprise Manager Web Console
    • 1.9.2.16 Performance Monitoring for Large Clusters
    • 1.9.2.17 Restore Statistics From Historic Snapshots
    • 1.9.2.18 Restore and Recovery Enhancements in Enterprise Manager
    • 1.9.2.19 Segment Advisor to Work on the Whole Database
    • 1.9.2.20 Show Segment Details of Tablespace
    • 1.9.2.21 Statistics Collection for Fixed and Dictionary Objects
    • 1.9.2.22 Tabular Display of Tablespace Segments
    • 1.9.2.23 Track Interconnect Information Statistics
    • 1.9.2.24 Use RMAN Compression During Cloning
    • 1.9.2.25 Wizard-Based Loading of Flat Files in Enterprise Manager
  • 1.9.3 Patching
    • 1.9.3.1 OPatch the Patching Tool
  • 1.9.4 Software Install and Cloning
    • 1.9.4.1 Improve Automatic Storage Management (ASM) Installation Process
    • 1.9.4.2 Real Application Clusters Cloning
    • 1.9.4.3 Real Application Clusters Install Framework
    • 1.9.4.4 Silent Install for Real Application Clusters
• 1.10 Information Integration
  • 1.10.1 Oracle Streams Performance and Usability Improvements
    • 1.10.1.1 Streams Performance
    • 1.10.1.2 Support for Hot Mining With Downstream Capture
    • 1.10.1.3 Buffered Messaging
    • 1.10.1.4 Commit-Time Ordering of Messages
    • 1.10.1.5 Apply Handler Dependency Declaration
    • 1.10.1.6 Simplified Large Object (LOB) Handling in Streams Apply Process
    • 1.10.1.7 Declarative LCR Transformations
    • 1.10.1.8 Notification Enhancements
    • 1.10.1.9 Oracle Java Message Service (OJMS) Nonpersistent Messaging
    • 1.10.1.10 Simplified Configuration APIs
    • 1.10.1.11 Oracle Streams Administration in the Enterprise Manager Web Console
  • 1.10.2 Improved Client/Server and Server/Server Communications
    • 1.10.2.1 Local Naming Support for JavaNet
    • 1.10.2.2 Oracle Streams AQ Administration in the Enterprise Manager Web Console
    • 1.10.2.3 Transparent Application Failover (TAF) Notification
• 1.11 Location Services
  • 1.11.1 Extend Business Geographics Features to Support Europe
    • 1.11.1.1 Oracle Spatial Routing Engine Support for Western Europe
  • 1.11.2 Extend Coordinate System in Core Spatial
    • 1.11.2.1 Oracle Spatial Support for EPSG Coordinate Systems
  • 1.11.3 GeoRaster Compression Standards
    • 1.11.3.1 Oracle Spatial GeoRaster Compression
  • 1.11.4 Improved Performance of Network Data Model
    • 1.11.4.1 Graph Partitioning for Very Large Networks in Oracle Spatial
  • 1.11.5 Improved Topology Operations
    • 1.11.5.1 Whole Feature Inserts and Updates for the Oracle Spatial Topology Data Model
• 1.12 Performance and Scalability
  • 1.12.1 Improved Large Object (LOB) Performance
    • 1.12.1.1 LOB Access Statistics in Dynamic Performance Views
    • 1.12.1.2 Online Redefinition Supports Parallel Execution for LONG-to-LOB Migration
    • 1.12.1.3 Performance Improvements for Loading LOBs
  • 1.12.2 Other Performance Improvements
    • 1.12.2.1 Asynchronous Commit
    • 1.12.2.2 Checkpointing Improvements
    • 1.12.2.3 Database Change Notification
    • 1.12.2.4 Fast Partition Split for Partitioned Index Organized Tables
    • 1.12.2.5 Improved Aggregation Performance
    • 1.12.2.6 Parallel Join Bitmap Filtering
• 1.13 Server Manageability
  • 1.13.1 Database Replay
  • 1.13.2 Simplified Configuration
    • 1.13.2.1 Automatic Undo Retention Enhancement
    • 1.13.2.2 Net Services Administration in the Enterprise Manager Web Console
    • 1.13.2.3 Self-Tuning Multiblock Read Count
  • 1.13.3 Improved Intelligent Infrastructure
    • 1.13.3.1 Adaptive Alert Thresholds in Enterprise Manager
    • 1.13.3.2 Database Performance Monitoring Enhancements in Enterprise Manager
    • 1.13.3.3 Diagnosis of Hung or Extremely Slow Databases Through Enterprise Manager
    • 1.13.3.4 Display Session Activity History in Enterprise Manager
    • 1.13.3.5 Performance Graph Normalization in Enterprise Manager
    • 1.13.3.6 Read Performance Statistics Directly From the System Global Area (SGA)
    • 1.13.3.7 Cleanup System Statistics
    • 1.13.3.8 Enhanced Active Session History
    • 1.13.3.9 Enhanced Automatic Database Diagnostic Monitor (ADDM) Performance Analysis
    • 1.13.3.10 Progress Monitoring for Advisors
    • 1.13.3.11 Enhanced End-to-End Performance Monitoring
    • 1.13.3.12 Active Session History (ASH) Report
    • 1.13.3.13 Automatic Workload Repository (AWR) Compare Periods Report
    • 1.13.3.14 Configurable AWR SQL Collection
  • 1.13.4 Automatic Storage Management (ASM) Manageability
    • 1.13.4.1 ASM Command-Line Interface
    • 1.13.4.2 ASM Wait on Rebalance Process
    • 1.13.4.3 Additional ASM Manageability Enhancements
    • 1.13.4.4 Batch Selection of Multiple Disks for Operations Like DELETE, RESIZE, and CHECK
  • 1.13.5 Automatic Storage Management (ASM) Extensions
    • 1.13.5.1 ASM Support for Multiple Database Releases
    • 1.13.5.2 Enhanced Protocol Support for Database to ASM Connection
  • 1.13.6 File Support in Automatic Storage Management (ASM)
    • 1.13.6.1 ASM/XDB FTP Support
  • 1.13.7 Enhanced Automatic Database Diagnostic Monitor (ADDM)
    • 1.13.7.1 Automatic Shared Memory Management of Streams Pool
  • 1.13.8 Enhanced Instance Tuning
    • 1.13.8.1 Automatically Enabled Resource Manager
    • 1.13.8.2 Enhanced Ability to Diagnose Memory Allocation
    • 1.13.8.3 Enhanced Automatic Shared Memory Management
    • 1.13.8.4 Enhanced Resource Manager Monitoring
  • 1.13.9 Enhanced SQL Manageability
    • 1.13.9.1 Transportable SQL Tuning Sets
    • 1.13.9.2 Display SQL History in Enterprise Manager
    • 1.13.9.3 Interruptible SQL Access Advisor
    • 1.13.9.4 SQL Access Advisor Recommends Function-Based Indexes
    • 1.13.9.5 SQL Profile Enhancements
    • 1.13.9.6 SQL Statistics Enhancement
    • 1.13.9.7 Timeout for Flushing SQL Statistics
  • 1.13.10 Enhanced Space Management
    • 1.13.10.1 Default Automatic Segment Space Management (ASSM)
    • 1.13.10.2 Automatic Segment Advisor
    • 1.13.10.3 Online Segment Shrink Enhancements
    • 1.13.10.4 Size-Based Tablespace Space Usage Alerts
    • 1.13.10.5 Drop Empty Datafile
• 1.14 Windows
  • 1.14.1 Improved Availability and Scalability With Oracle Real Application Clusters
    • 1.14.1.1 ODP.NET: Fast Application Notification (FAN)
    • 1.14.1.2 ODP.NET: Integration with Real Application Clusters Load Balancing Advisory
  • 1.14.2 Ease of Development
    • 1.14.2.1 Common Language Runtime (CLR) Stored Procedure Visual Studio Integration
    • 1.14.2.2 ODP.NET: .NET Framework 1.1 Functionality Support
    • 1.14.2.3 ODP.NET: Database Change Notification Service
    • 1.14.2.4 ODP.NET: Derived Parameters Support
    • 1.14.2.5 ODP.NET: Enhanced Connection Pool Administration
    • 1.14.2.6 ODP.NET: Query Cancel/Timeout
    • 1.14.2.7 Server-Side ODP.NET
  • 1.14.3 Performance Improvements
    • 1.14.3.1 ODP.NET: Improved LOB Retrieval Performance and Functionality
    • 1.14.3.2 ODP.NET: Statement Caching
  • 1.14.4 Security
    • 1.14.4.1 ODP.NET: Enhanced Virtual Private Database (VPD) Support
    • 1.14.4.2 Secure Operating System Objects
• 1.15 Workspace Manager
  • 1.15.1 New Workspace Manager System Parameters
  • 1.15.2 New Options for the AlterVersionedTable Procedure
  • 1.15.3 New Parameter for the EnableVersioning Procedure
  • 1.15.4 New Views for Removed Workspaces
  • 1.15.5 Merging Multiple Tables
  • 1.15.6 Workspace ID Column Added to Static Data Dictionary Views
  • 1.15.7 User-Defined Hints
  • 1.15.8 Adding, Merging, or Splitting Table Partitions
  • 1.15.9 Null Foreign Key Constraints
  • 1.15.10 Oracle Label Security Policies and Version-Enabled Tables

2 Oracle Database 10g Documentation

• 2.1 Documentation Titles and Online Documentation Structure
  • 2.1.1 Oracle Database 10g Documentation
    • 2.1.1.1 General Database Documents
    • 2.1.1.2 Application Development Documentation
    • 2.1.1.3 Backup Documentation
    • 2.1.1.4 Data Mining Documentation
    • 2.1.1.5 Database Server Documentation
    • 2.1.1.6 Enterprise Manager Documentation
    • 2.1.1.7 Gateways Documentation
    • 2.1.1.8 Installation Documentation
    • 2.1.1.9 Java Development Documentation
    • 2.1.1.10 Networking Documentation
    • 2.1.1.11 OLAP Documentation
    • 2.1.1.12 Real Application Clusters Documentation
    • 2.1.1.13 Release Notes Documentation
    • 2.1.1.14 Text Documentation
    • 2.1.1.15 Ultra Search Documentation
    • 2.1.1.16 Windows Documentation
    • 2.1.1.17 Workflow Documentation