Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview of Oracle9i

Introduction

Oracle9i Database

Oracle9i Application Server

Oracle9i Developer Suite

2 Oracle9i Database Release 2 (9.2) New Features

Scalability and Performance

Partitioning of Applications No Longer Necessary

Fast Split Partitioning

Shared Server

Availability

Enhanced Disaster Recovery Environment

Recovery Manager Enhancements and Changes

Manageability

Streamlined Operational Database Management

Simplified Oracle9i Administration With Oracle Enterprise Manager

LogMiner Enhancements

Minimizing the Production Impact of Upgrading

Cluster File Systems

Domain Indexes Enhancement

Table Function Enhancement

Oracle Net Services Enhancements

Segment-level statistics collection

Real Application Clusters Guard II

Information Integration

Oracle Streams

Conclusion

Business Intelligence

Oracle OLAP Option Enhancements

Scalability for Business Intelligence

Security and Directory

SYS Accountability

DBA GRANT/REVOKE of Object Privileges

Password for Users SYS and SYSTEM at Database Creation

Enterprise User Security: Simplified User Setup and Administration

Enterprise User Security: User Migration Utility

Support for Advanced Encryption Standard (AES)

Strong Authentication: Support for RADIUS Authorizations

Public Key Infrastructure: SSL Hardware Acceleration

Directory Naming Access Control in Oracle Net Services

Oracle Label Security: Releasabilities

Internet Content Management

Storage, Management, and Aggregation of All Types of Content

Oracle Spatial

Application Development

Workspace Manager

XML and XML DB

Oracle XML DB Features

Open Server-Side PL/SQL and Java Debugging

Object Type Translator (OTT) Tags: Carrying Forward User Added Code

Windows Integration

Integration Capabilities

3 Oracle9i Database Release 1 (9.0.1) New Features

Development Platform

Enterprise Java Engine

New Extended Markup Language (XML) Features in the Server

Oracle XML Developer's Kit

SQL and PL/SQL Improvements

Oracle Text

Internet Content Management

Storage, Management, and Aggregation of All Types of Content

Efficient Searching and Indexing of All Types of Content

Collaborative Projects

iSQL*Plus

Availability

Enhanced Disaster Recovery Environment

Online Data Evolution

Precision Database Repair

Advanced Replication

Manageability

Database Self-Management

Streamlined Operational Database Management

Enhanced Recovery Manager (RMAN) Performance

Simplified Oracle9i Administration With Oracle Enterprise Manager

Oracle Net Services

Data Cartridge Enhancements

Oracle Spatial

Heterogeneous Services

Business Intelligence

Performance and Scalability

Data Warehouse Manageability

Integrated Analysis Capabilities

Scalability and Performance

Scalability

Performance

Database Security

Security New Features Implementation

Database Security New Features:

Data Encryption and Label Security

Windows Integration

Integration Capabilities

Information Integration

Providing a Standard Infrastructure

Supporting Industry Standard Business Messaging Formats

Packaged Applications

Database Globalization Support

Development Features for Independent Software Vendors

4 Oracle9i Documentation

Online Documentation Structure

Documentation Titles

Oracle9i Master Index and Master Glossary

Oracle9i Server and SQL*Plus

Oracle9i Directory, Networking, and Security Documentation

Oracle9i Real Application Clusters

Oracle9i Database Application Development

Oracle Text

5 Oracle9i Feature and Option Availability

Options

Features

Features

The V$OPTION Table

Index