Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Documentation Accessibility

Related Documents

1 Oracle Database 10g New Features

Application Development

Application Program Interface (API) and Precompilers

Oracle Open Database Connectivity (ODBC) Driver Support for Linux

Oracle Call Interface (OCI) Client Version API

Start Up and Shut Down of Database OCI API

Oracle C++ Call Interface (OCCI) Transparent Application Failover Support

Instant Client Light

Instant Client Software Development Kit (SDK)

Globalization and Unicode Improvements

Unicode Data Type Literal Enhancement

Globalization Development Kit (GDK) 2.0

Character Set Scanner (CSSCAN) Enhancements

Language and Character Set File Scanner (LCSSCAN) Enhancements

Consistent Linguistic Searching and Sorting

Transliteration for Japanese Kana Conversion

Java, Java Database Connectivity (JDBC), and Web Services

JDBC XA Connections Caching

JDBC Runtime Connection Load Balancing

JDBC Support for Data Manipulation Language (DML) in the RETURNING Clause

Support for JDBC 3.0 ResultSet Holdability

Support for JDBC 3.0 Retrieval of Auto-Generated Key

Oracle HTML DB Improvements

Cluster Bar Charts

Percentage Bar Charts

Stacked Bar Charts

Asynchronous Refresh for All Charts Based on Scalable Vector Graphics (SVG)

Create Master Detail With Choice of Layout

Application From a Spreadsheet Wizard

Create Forms and Reports Based on a Web Service Reference

Discover Web Services Through UDDI Repository

Simplified and More Consistent User Interface

PL/SQL Improvements

PL/SQL Conditional Compilation

Obfuscation of Dynamically Generated PL/SQL Source Code

Relaxation of Line Length and Overall Limits for the DBMS_OUTPUT PL/SQL Package

UTL_NLA PL/SQL Package for Matrix Math

SQL Language Improvements

Regular Expression Enhancements

Collection Operator Performance Improvements

Distributed Large Objects (LOB) Support

Expression Filter Enhancements

XML Application Development

Advanced XPath Rewrite

New InsertXML(), AppendChildXML(), InsertXMLBefore(), and DeleteXML() Functions

Simple Object Access Protocol (SOAP) 1.2 Implementation in C/C++

SQL/XML Standard (SQL:2003 Standard Part 14) Compliance

SQL/XML Standard Compliance

Easy XML Application Development Using JAXB Customization

Oracle XML Developer's Kit (XDK) PL/SQL Document Object Model (DOM) API Deprecation

XPath 2.0 and XQuery 1.0 Functions and Operators Support in Java

Custom Metadata for Oracle XML DB Repository Resources

Secure Sockets Layer (SSL) Support

Transportable Tablespace Support

Oracle XML DB Administration in the Enterprise Manager Web Console

Fast-Start Failover to Standby Database

Fast-Start Failover

Automatic Conversion of the Primary Database to a Standby Database Upon Failover

Optimized Asynchronous Redo Transmission

Faster Redo Apply Failover

Faster SQL Apply Failover

Support for Database Transport Across Same Endian Platforms

Database Transport Across Same Endian Platforms

High Availability Improvements

Add and Create a Transportable Tablespace to a Database

Additional Data Type Support in LogMiner and SQL Apply

Automatic Deletion of Applied Archive Logs

Data Guard: Improved Manageability for Redo Transport, Log Apply, and Broker

Dynamic RMAN Channel Allocation for Backing Up and Recovering RAC Database

RMAN Backup Encryption

Easy Conversion of a Physical Standby Database to a Reporting Database

Eliminate Control File Re-Creation

Enhanced Memory Corruption Checking

Enhanced RMAN Backup Job Views

Enhanced Server Side Shutdown

Enhanced Space Management Verification

Failover Improvements for Real Application Clusters (RAC) Distributed Transactions

Faster Instance Startup for Large Memory Configurations

Fine-Grained, Automated Tracking of SQL Apply Runtime Performance

Flashback Across Data Guard Switchovers

Flashback Database Through Resetlogs

Hardware Assisted Resilient Data (HARD) Compliant RMAN Backups

Increase Supported Real Application Clusters Instances for a Database

Incremental Roll Forward of Database Copy

Online Redefinition Supports Clustered Tables, ADT's, MV Logs, AQ Tables, and Preserves Database Statistics

Online Redefinition of a Single Partition

Optimized Creation of Logical Standby Database

Unused Block Compression

Reorganized Object Types Improves User Interface

Temporary Datafiles Are Re-Created on RMAN Recovery

Business Intelligence

SQL Support for Analytic Applications

Enhanced Upsert Abilities in MODEL Clause

Enhancements to MODEL Rules Which Use FOR Loops

Use of Analytic Functions in the SQL MODEL Clause

Intra-Partition DML in the Presence of Bitmap Indexes

Improved Very Large Database (VLDB) Support

Increased Maximum Number of Partitions Per Object

Enhanced Dynamic Partition Pruning

Resource Optimized DROP TABLE for Partitioned Tables

Reduced Information Cycle Time

Distributed Asynchronous Change Data Capture (CDC)

DML Error Logging Table

Partition Change Tracking Refresh Without Materialized View Logs

Query Rewrite Using Multiple Materialized Views

Skip Level Dimension Hierarchies

Online Analytical Processing (OLAP) Support for Analytic Applications

Incremental Aggregation of Compressed OLAP Cubes

OLAP API Supports Calculated (Virtual) Dimension Members

OLAP Compressed Cubes Support Semiadditive Aggregation Methods

Data Mining Support for Analytic Applications

Decision Tree Algorithm

Predictive Analytics Package

SQL-Level Data Mining Scoring Capability

Java Data Mining (JDM) Compliant Java API

Real Application Clusters (RAC) Performance

Load Balancing Advisory

Oracle Cluster File System for Solaris

Real Application Clusters Robustness

Clusterware File Redundancy

Cluster Verification

Cluster Tracing and Diagnostic Enhancements

Application High Availability With Oracle Clusterware

High Availability API

Content Management

Oracle Text Improvements

CTXRULE Asian Language Support

Key Word in Context (KWIC)

Online Indexing for Local Partitioned Index

interMedia Improvements

interMedia DICOM Medical Imaging Format Support

interMedia Support for Image Content Metadata and XML DB Integration

Java Advanced Imaging 1.1.2 Support

Database Overall

Database Utilities

Easier Manual Upgrades

Enhanced Pre-Upgrade Information Utility

Default DATA_PUMP_DIR Directory Object

Dumpfile Compression

Extended Job Status Display

FILESIZE Value for Dumpfiles

Monitoring of Data Pump Jobs Started Outside of Enterprise Manager

New DBMS_DATAPUMP API Calls

New PCTSPACE Transform Parameter on Data Pump Import

Object ID (OID) Transform Parameter

SQL*Plus AUTOTRACE EXPLAIN Conversion to DBMS_XPLAN

SQL*Plus DBMS_OUTPUT Buffer and Line Size Limit Increase

SQL*Plus XQuery Support

Database Security

Privacy and Confidentiality

Transparent Data Encryption

Key Management for Data Encryption

Improved Manageability

Enhanced Proxy Authentication

Audit Trail in Standard XML Format

Secure By Default

Connect Role Privilege Reduction

Improved Integration and Interoperability

Secure External Password Store

Enhanced Centralized Password Policies for the Database

Oracle Label Security Support for Real Application Clusters

Data Provisioning

File Groups Repository

Transportable Tablespace from Backup

Oracle Scheduler

Event Scheduling

Scheduler Enhancements

Grid Management

Configuration Plug-ins and Assistants

Enterprise Manager Configuration Plug-in

Migrate Non-ASM Databases to ASM

Standalone Automatic Storage Management (ASM) Configuration

Standalone Disk Group Management

Upgrade 10.1 Database to 10.2

Database Management

Ability to Discover and Update Host Cluster Targets in Enterprise Manager

Access Advisor Enhancements in Enterprise Manager

Backup and Recovery Configuration Enhancements in Enterprise Manager

Clone External Objects as Part of the Cloning Operation

Database Administration Enhancements in Enterprise Manager

Database Auditing Administration in Enterprise Manager

Enable or Disable Undo Retention Guarantee

Enhanced Backup Management

Enhanced Diagnostics for Cache Coherency Statistics

Integrate Segment Advisor with Segment Findings

Lock and Unlock Statistics

Management of Directory Objects in the Enterprise Manager Web Console

Miscellaneous Undo Advisor User Interface Enhancements

New Storage and Configuration Policies

Oracle Spatial Administration in the Enterprise Manager Web Console

Performance Monitoring for Large Clusters

Restore Statistics From Historic Snapshots

Restore and Recovery Enhancements in Enterprise Manager

Segment Advisor to Work on the Whole Database

Show Segment Details of Tablespace

Statistics Collection for Fixed and Dictionary Objects

Tabular Display of Tablespace Segments

Track Interconnect Information Statistics

Use RMAN Compression During Cloning

Wizard-Based Loading of Flat Files in Enterprise Manager

OPatch the Patching Tool

Software Install and Cloning

Improve Automatic Storage Management (ASM) Installation Process

Real Application Clusters Cloning

Real Application Clusters Install Framework

Silent Install for Real Application Clusters

Information Integration

Oracle Streams Performance and Usability Improvements

Streams Performance

Support for Hot Mining With Downstream Capture

Buffered Messaging

Commit-Time Ordering of Messages

Apply Handler Dependency Declaration

Simplified Large Object (LOB) Handling in Streams Apply Process

Declarative LCR Transformations

Notification Enhancements

Oracle Java Message Service (OJMS) Nonpersistent Messaging

Simplified Configuration APIs

Oracle Streams Administration in the Enterprise Manager Web Console

Improved Client/Server and Server/Server Communications

Local Naming Support for JavaNet

Oracle Streams AQ Administration in the Enterprise Manager Web Console

Transparent Application Failover (TAF) Notification

Location Services

Extend Business Geographics Features to Support Europe

Oracle Spatial Routing Engine Support for Western Europe

Extend Coordinate System in Core Spatial

Oracle Spatial Support for EPSG Coordinate Systems

GeoRaster Compression Standards

Oracle Spatial GeoRaster Compression

Improved Performance of Network Data Model

Graph Partitioning for Very Large Networks in Oracle Spatial

Improved Topology Operations

Whole Feature Inserts and Updates for the Oracle Spatial Topology Data Model

Performance and Scalability

Improved Large Object (LOB) Performance

LOB Access Statistics in Dynamic Performance Views

Online Redefinition Supports Parallel Execution for LONG-to-LOB Migration

Performance Improvements for Loading LOBs

Other Performance Improvements

Asynchronous Commit

Checkpointing Improvements

Database Change Notification

Fast Partition Split for Partitioned Index Organized Tables

Improved Aggregation Performance

Parallel Join Bitmap Filtering

Server Manageability

Simplified Configuration

Automatic Undo Retention Enhancement

Net Services Administration in the Enterprise Manager Web Console

Self-Tuning Multiblock Read Count

Improved Intelligent Infrastructure

Adaptive Alert Thresholds in Enterprise Manager

Database Performance Monitoring Enhancements in Enterprise Manager

Diagnosis of Hung or Extremely Slow Databases Through Enterprise Manager

Display Session Activity History in Enterprise Manager

Performance Graph Normalization in Enterprise Manager

Read Performance Statistics Directly From the System Global Area (SGA)

Cleanup System Statistics

Enhanced Active Session History

Enhanced Automatic Database Diagnostic Monitor (ADDM) Performance Analysis

Progress Monitoring for Advisors

Enhanced End-to-End Performance Monitoring

Active Session History (ASH) Report

Automatic Workload Repository (AWR) Compare Periods Report

Configurable AWR SQL Collection

Transportable Automatic Workload Repository (AWR)

Automatic Storage Management (ASM) Manageability

ASM Command-Line Interface

ASM Wait on Rebalance Process

Additional ASM Manageability Enhancements

Batch Selection of Multiple Disks for Operations Like DELETE, RESIZE, and CHECK

Automatic Storage Management (ASM) Extensions

ASM Support for Multiple Database Releases

Enhanced Protocol Support for Database to ASM Connection

File Support in Automatic Storage Management (ASM)

ASM/XDB FTP Support

Enhanced Automatic Database Diagnostic Monitor (ADDM)

Automatic Shared Memory Management of Streams Pool

Enhanced Instance Tuning

Automatically Enabled Resource Manager

Enhanced Ability to Diagnose Memory Allocation

Enhanced Automatic Shared Memory Management

Enhanced Resource Manager Monitoring

Enhanced SQL Manageability

Transportable SQL Tuning Sets

Display SQL History in Enterprise Manager

Interruptible SQL Access Advisor

SQL Access Advisor Recommends Function-Based Indexes

SQL Profile Enhancements

SQL Statistics Enhancement

Timeout for Flushing SQL Statistics

Enhanced Space Management

Default Automatic Segment Space Management (ASSM)

Automatic Segment Advisor

Online Segment Shrink Enhancements

Size-Based Tablespace Space Usage Alerts

Drop Empty Datafile

Improved Availability and Scalability With Oracle Real Application Clusters

ODP.NET: Fast Application Notification (FAN)

ODP.NET: Integration with Real Application Clusters Load Balancing Advisory

Ease of Development

Common Language Runtime (CLR) Stored Procedure Visual Studio Integration

ODP.NET: .NET Framework 1.1 Functionality Support

ODP.NET: Database Change Notification Service

ODP.NET: Derived Parameters Support

ODP.NET: Enhanced Connection Pool Administration

ODP.NET: Query Cancel/Timeout

Server-Side ODP.NET

Performance Improvements

ODP.NET: Improved LOB Retrieval Performance and Functionality

ODP.NET: Statement Caching

ODP.NET: Enhanced Virtual Private Database (VPD) Support

Secure Operating System Objects

2 Oracle Database 10g Documentation

Documentation Titles and Online Documentation Structure

Oracle Database 10g Documentation

General Database Documents

Application Development Documentation

Backup Documentation

Data Mining Documentation

Database Server Documentation

Enterprise Manager Documentation

Gateways Documentation

Installation Documentation

Java Development Documentation

Networking Documentation

OLAP Documentation

Real Application Clusters Documentation

Release Notes Documentation

Text Documentation

Ultra Search Documentation

Windows Documentation

Workflow Documentation

Index