Oracle9i New Features

What’s new in Oracle9i that is of interest to a DBA?

Automatic undo management

Automatic Segment Space Management

Rename Column

Rename Constraints

Data Compression

Index Key Compression

Flashback Query

Object Privileges by DBA

Default Temporary Tablespace

Resumable Space Allocation

List Partitioning

Range-list Partitioning

External Tables

Tuning Advisories

Dynamic Sampling of Optimizer Statistics

Dynamic Database Parameters

Dynamic Memory Management / Automatic Memory Tuning

Server Parameter File

Oracle Managed Files

Using multiple block sizes

Multi-table INSERT

Index Skip Scan



ANSI Style Outer Joins

Random Sampling of Data

New Data Types

“Upsert” or the MERGE statement


Search Exact Match Search      
Home Oracle DBA TKMCE Alumni H1B Info Guestbook

Biju Thomas is Oracle7.3 OCP, Oracle8 OCP, 
Oracle8i OCP and Oracle9i OCA/OCP Certified DBA

Questions/Comments? Write to © The scripts, tips and articles appearing on cannot be reproduced elsewhere without the prior permission from the webmaster.