Contents

List of Tables

Title and Copyright Information

Send Us Y our Comments

Preface

Audience

Organization

Related Documentation

Conventions

Doc umentation Accessibility

1 Oracle Database 10g, Release 1 New Features

Introduct ion

Server Manageability

Server C onfiguration

Simplified Database Install

Automatic Storage Management Configuration

Automatic Oracle Real Application Clu sters Services Configuration

Simplified Upgrade for RAC and Oracle Parallel Server Datab ases

Automatic Oracle Enterprise Manager Configuration

Automatic Integrated Clusterware Installation

Automatic Configuration of Rec overy Area

Out-of-the-Box LDAP Configuration

Simplified Initialization Parameters

Default User Tablespace

Easy Upgrade

Upgrade Information Tool

Network Management

Back Up Directory Naming Entries t o Local Naming File

Dynamic Connection Manager Configuration

Easy Connect Naming Method

Improved Network Outage Detection

Automatic LDAP Discovery for Clients

Improved Connec tion Manager Access Rules

Automatic Shared Server Configuration

Simplified Shared Server Configuration Parameters

Managea bility Infrastructure

Database Features Usage Tracking

Enhanced Database Time Model

End-to-End Application Tracing

JDBC: End-to-End Tracing

SYSAUX Tablespace

Automatic Routine Administration Tasks

Server-Gen erated Alerts

Automatic Workload Respository

Enhanced Wait Model

Threshold-Based Alerts

Storage Management

Multiple Default Temporary Tablespace Support for SQL Operations

Automatic Storage Management

Rename Tablespace

Space, Object, and Transaction Management

< dd>

Automatic Undo Retention Tuning

Segment A dvisor

New Segment Resource Estimation

On line Segment Shrink

Proactive Tablespace Management

Undo Advisor

Backup and Recovery Manageability

Enhanced RMAN Reporting

Backup Compression

Bounded Backup Window

RMAN Scripts Manageability

Recovery Area Full Alert

Insta nce Tuning

User-Initiated Buffer Cache Flushing

Database Resource Manager - Adaptive Consumer Group Mapping

New Perfor mance Overview Charts in Oracle Enterprise Manager

Improved SQL Reporting Using Oracle Enterprise Manager

Automatic Database Diagnostic Monitor

Redo Logfile Sizing Advisor

Automatic Checkpoint Tuning

Automatic Shared Memory Tuning

Transaction Rollback and Recovery Monitoring

Application Tuning

SQL Tuning Advisor

SQLAccess Advisor

Materialized View Tuning API

Automatic Optimizer Statistics Collection

Database Overall

Utilities

SQL*Plus - glogin.sql Changes

SQL*Plus - Show Recycle Bin

SQL*Plus - Run glogin.sql and login.sql After Each CONNECT

SQL*Plus - DBMS_OUTPUT After SELECT

SQL*Plus - COMPATIBILITY Command Line Option

SQL*Plus - SET SQLPROMPT Runtime V ariable Substitution

SQL*Plus - SPOOL CREATE, REPLACE, and APPEND Options

Data Pump Data Load/Unload

iSQL*Plus - Output Over Mul tiple Pages

iSQL*Plus Input Prompting

Performance and Scalability

Overall

< a href="chapter1.htm#sthref181">Index-Organized Table (IOT) Partitioning Enhancements

E liminate Duplicated Columns in Index on an Index-Organized Table

Configurable TCP/IP Se nd and Receive Buffer Size

Single-Set Aggregates in DML Returning Clause

< a href="chapter1.htm#sthref186">High-Speed Infiniband Network Support

Sorted Hash Clust ers

Windows Fiber Support

Optimized 64-bi t Database

SQL Tuning Advisor

SQLAccess A dvisor

Materialized View Tuning API

Autom atic Optimizer Statistics Collection

Clustering

Oracle Real Application Clusters Enhancements

Integrated Clusterware Management

Automatic Workload Management

Single System Image Management

Fast Connection Failover

Performance Improvements

Zero Downtime Patc hing

Cluster Verification and Improved Diagnostic Tools

Grid Computing

Resource Virtualization and Provisioning

Resonance

Transpa rent Session Migration

Streams - Moving an Operating System File

Streams - Simple Instantiation of Replica Tablespaces and Databases

Integrated Clusterware Management

High-Speed Infiniband Network Support

< dd>Fast Connection Failover

Automatic Storage Manageme nt

Cross-Platform Transportable Tablespaces

Data Pump Export and Import Utilities

Streams - Instantiation Through RMAN

Streams - Instantiation Through Transportable Tablespaces

Streams - Instantiation Through Data Pump

Workload Management

Automatic Workload Management

Database Resource Manager - Adaptive Consumer Group Mapping

Scheduler - Job Processing

Scheduler - Usability and Manageability

Scheduler - Support for Jobs in a Clustered Environment

Information Integrat ion

Improved Information Integration Performance

Transparent Gateway - Remote Stored Functions in SELECT Statements

Oracle Streams

JMS 1.3-Compliant JDBC - Thin Driver Support

OJMS Queue and Topic Unification Support

Oracle Messaging Gateway - MQSeries JMS Interface

Oracle Messaging Gateway - OJMS (AQ/ JMS) Interface

Oracle Messaging Gateway - Tibco/Rendezvous Java Interface

Streams - Batch Enqueue/Dequeue

Advanced Replication t o Streams Migration Tool

Streams - Support Delete Cascade Operations

Streams - Enqueue Handler

Streams - Access to Client Inform ation During Processing

Streams - Descending and Function-Based Index Support

Streams - Precommit Handlers

Streams - Negative Ru les

Streams - Rules Engine - Easy Rules Engine Transformation Management

< a href="chapter1.htm#sthref308">Streams - Row Subsetting During Capture and Propagation

Streams - Additional Streams Datatype and IOT Support

Streams - Access to Additional L CR Attributes

Streams - Instantiation Through Data Pump

Streams - Clean Up Rules Sets

Streams - Buffer Queue Monitoring

Streams - Message Notification

Streams - Allocate Memory from Streams Pool

Streams - High-Level API for Message Queuing

Streams - Easier Transformation Monitoring

Streams - Impr oved Capture and Apply Error Handling

Streams - Instantiation Through RMAN

Streams - Expose Commit Order of Changes

Streams - Cl ean Up LogMiner Information

Streams - Set Instantiation SCN at Apply Site

Streams - Views to Monitor Instantiation Data

Streams - New APIs to Grant Privileges

Improved Streams Oracle Real Application Clusters Suppor t

Streams - Downstream Capture

Streams - Instantiation Through Transportable Tablespaces

OCCI Support for Streams AnyData Queues

Streams - Enhanced Capture and Apply Performance

Streams - Performance Enhancements for AnyData

Rules Engine - Rules Enhancemen ts

The Scheduler

Sche duler - Core Scheduler Features

Scheduler - Usability and Manageability

Scheduler - Monitoring

Scheduler - Job Processing

Scheduler - Recovery

Scheduler - Support for Jo bs in a Clustered Environment

Scheduler - ILMS Support

Scheduler - Increased Throughput

Scheduler - Dynamic Slave Pool

Scheduler - Redo Minimization

Availability

Backup and Recovery

Flash Backup and Recovery

Drop Database

RMAN Database Deregistration

Backup and Restore of Standby Control File< /dd>

Automatic TSPITR

Simplified Recovery Manager Cataloging of Backup Files

Automatic Channel Failover for Backup and Restore

< dd>Automatic File Creation During Recovery

Simplified Backups to Disk

Proxy Copy Backup of Archivelogs

Incrementally Updated Backups

Simplified Recovery Through Resetlogs

Restore Tolerates Corrupt or Missing Backups

Full Da tabase Begin Backup Command

Change-Aware Incremental Backups

Enhanced Oracle Data Guard Infrastructure

Data Guard Broker Support for RAC

Automatic LogMiner Configuration

Log Miner Support for Index-Organized Tables

LogMiner Support for More Types: LONG, Multibyte CLOB and NCLOB

Fine-Grained Supplemental Logging

< dd>Secured Redo Transmission

Uniquely Named Databases with DB_UNIQUE_NAME

Simplified Zero Data Loss for Data Guard SQL Apply

Zero Downtime Instantiation for SQL Apply

Real Time Apply

Automating Recovery Through Open Resetlogs in Standby Databases

Recovering from Human Error with Flashback Technology

Oracle Flashback Database

Oracle Flashback Table

Oracle Flashback Version Query

Oracle Flashback Drop

Oracle Flashback Transaction Query

Reduced Dow ntime for Application and Database Upgrades

Enhanced Online Redefinition< /dd>

Rolling Upgrades with SQL Apply

Signature-Bas ed Dependency Tracking Using Synonyms

Security and Directory

Improved Administration

DML Support in FGA

Communication over SASL

U nified User Model

Easy Database Registration

Extended and Uniform Audit Trail

Oracle Label Security Directory Integration

Integration and Interoperability

Certificate Validation with Certificate Revocation Lists (CRLs)

Centralized CRL M anagement

Centralized User Management for Kerberos Users

Kerberos-Enabled Database Links

Operating System Credential Cache

Access to Single Sign On Wallet

Key Store Inte rface

Database Authentication with Standard LDAP Password Verifiers

Single Station Administration for Password Authentication to Oracle Database

Smart Card Support for X509v3 Certificates

Transport Layer Security (T LS) Support

SSL Session Renegotiation

409 6-Bit Key Size Support

Performance Improvements

Security and Privacy

VPD Support for Parallel Query

VPD Static and Dynamic Policies

Column-Level VPD< /a>

Business Intelligence

Bioinformatics

BLAST Queries

Statistical Functions

Document Clustering

Support Vector Machines

Document Named Entity Extraction

< dd>Data Mining Support for Analytic Applications

Frequent Itemsets

DBMS_DATA_MINING PL/SQL Interface for Oracle Data Mining

Features Extraction using Non-Negative Matrix Factorization Algorithm

Enhanced Data Preprocessing

Enhanced Adaptive Bayes Network

Multi-User Access Control

Oracle Data Mining C lient (DM4J)

Support Vector Machines (SVM)

Improved Very Large Database (VLDB) Support

Bigfile Tablespace

Enhanced Partition Management in Oracle Enterprise Manager

Global Partitioned Indexes - Hash Partitioning

Partitioned Index-Organi zed Tables - List Partitioning

Partitioned Index-Organized Tables - Global Index Mainte nance

Partitioned Index-Organized Tables - LOB Support

Enhanced Bitmap Index Performance and Space Management

Local Partitioned Indexes Manageability Improvements

OLAP Support for Analytic Applications

Parallel AGGREGATE Command

Paralle l SQL IMPORT Command

PL/SQL Creation of Analytic Workspaces

Intra-Dimensional (Attribute) Aggregation

Enhanced Composite Dimensi ons Indexing

PL/SQL OLAP Measure Calculation Definition

Complete Analytical Workspace Management

Multi-Writer Support

< dd>XML Interface for Analytic Workspace

Redu ced Information Cycle Time

Asynchronous Change Data Capture

Cross-Platform Transportable Tablespaces

Enhanced Table Fu nctions

External Tables Unload

Enhanced M ERGE Functionality

Data Pump Export and Import Utilities

Parallel Data Pump Export and Import

SQL*Loader Direct-Path Load Suppor t for ROWID Datatype

SQL*Loader Direct-Path Load Support for VARRAY Datatype

< dd>SQL*Loader Direct-Path Load Support for XMLType Tables

SQL Support for Analytic Applications

Partition Outer Join< /dd>

Increased Number of Aggregates per Query

SQL MODEL Clause

Upsert Through SQL Model Calculations

Summary Management OLAP Query Performance Improvements

Summary Management - E nhanced Partition-Aware Materialized View Refresh

Summary Management - EXPLAIN PLAN Sho ws Materialized View Access

Summary Management - Enhanced Dimensions

Summary Management - Nested Materialized View Refresh

Summa ry Management - Enhanced PCT Refresh

Content Management

Improved Multimedia Support

ISO/ IEC 13249-5 SQL Multimedia Still Image Support

Terabyte-Size LOBs

Java Advanced Imaging 1.1.1_01 Support

Native Support for Addi tional Audio/Video Media Formats

Improved Text Globalization Capabilities

Document Character Set and Language Detection

New German Spelling Rules Support

Chinese GB18030 Character Set Support

Enhanced Japanese Language Support

Improved Text Manageability and Usability

Text Classification and Routing

Classification Training Set Wizard for JDeveloper

Thesaurus Manager

Catalog Wizard for JDeveloper

Text Wizard for JDeveloper

Indexless Document Services

Progressive Text Query Relaxation

Query Log Analysis

Multipart MIME Filter

Highlighting for INPATH a nd HASPATH Operators

Positional Operator

Improved Text Quality of Retrieval

Link Analysis

NEAR-ACCUM Text Operator

Theme Proximity Searching

Location Services

O verall

GeoRaster Support

Spatia l Analytics and Geocoder

Network Data Model

Topology Data Model

Spatial Index Updates and Queries - Performance Improvements

Parallel Spatial Queries

OpenGIS Simple Feat ures Specification Conformance

Workspace Manager Event Management

Enhanced Workspace Manager Usability

Enhanced Workspace Manage r Database Support

Application Development

< a href="chapter1.htm#sthref733">Database Centric Application Development Environment

Service Administration

SQL Workshop

Data Workshop

Application Builder

Globalization and Unicode

Globalization Development Kit

Character Set Scanner Utilities

Database Character Set S canner CSALTER Script

Expanded Locale Coverage

Unicode 3.2 Support

CLOB and NCLOB Implicit Conversions

Java, JDBC, and Web Services

JDBC Thin Driver PL/SQL Index Table

JDBC 3.0 Named Parameter

SOAP Client for Database Web Services

Java-in-Database Web Services

SQL Query Web Services

Web Services Data Source

Enhanced PL/SQL Web Services

Consuming External We b Services from SQL and PL/SQL

Consuming External Web Services from Database Using Java

SQL DML Web Services

OracleJVM: Native J ava Interface

Enhanced JDBC VARRAY Support

JDBC IEEE DOUBLE and FLOAT Datatypes

JDBC LONG to LOB Conversion

JDBC INTERVAL DAY TO SECOND

JDBC RAC/HA Fast Connection Failo ver

JDBC 3.0 J2EE Connector Architecture Resource Adapter

JDBC 3.0 DATALINK Datatype and Ref Interface

JDBC Web RowSet

OracleJVM J2SE 1.4.x Compatibility

Implicit JDBC 3 .0 Connection Caching

JDBC Connection Cache Manager

Other APIs and Precompilers

Instant Client

OCCI Globalization Support

OCCI Stateless Connection P ooling

OCCI Performance Improvements

OCCI Statement Caching

OCCI XA Support

Preser ved User Code in OTT-Generated Classes

PL/SQL Improvements

Sparse Table Bulk Binds

Collection Set Operations

Database Storage of PL/SQL Native Compilation Units

Fine-Grained Debug Privileges

Regular Expressions

User-Specified Quoting Character

UTL_COMPRESS Package

UTL_MAIL Package

Compile-Time Warnings

< a href="chapter1.htm#sthref851">DBMS_PROFILER Improvements

PL/SQL Optimizing Compiler

SQL Language Improvements

Case-Insensitive and Accent-Insensitive Query and Sort

BINARY_DOUBLE and BINARY_FLO AT Datatypes

Enhanced Collections

Enhance d CONNECT BY Support

Expression Filter

Ex tensible Indexing

SQL Regular Expressions

Row Timestamp

XML Application Development Support

SQL/XML Standard Compliance

Oracle XML DB LDAP Access Per formance

XML DB Schema Evolution

XML Proc essing Performance Improvements

XML Transformation Performance Improvements in C/C++

XML DB Internationalization

Extended XML St andard Support in C/C++

Extended XML Standard Support in Java

XML Transformation and Querying Performance Improvements in Java

H igh Performance XML - Java

XML DB XMLType View Performance

Windows

Data Access Support

Oracle Objects for OLE Support for Oracle Datatypes and Grid

ODP.NET Support for Advanced Oracle Features

ODP.NET Support for XML DB

Operating System Integration

Optimized 64-bit Database

Oracle Services for Microsoft Transaction Server Support

2 Oracle Database 10g Documentation

Documentation Tit les and Online Documentation Structure

Oracle Database 10g Server an d SQL*Plus Documentation

Oracle Data Mining Documentation

Oracle Spatial Documentation

Oracle OLAP Documentation

Oracle Database10g Documentation for Windows

Ja va Documentation

Oracle Enterprise Manager Documentation

Index