9i Features

1    Automatic undo management
2    Automatic Segment Space Management
3    Rename Column
4    Rename Constraints
5    Flashback Query
6    Object Privileges by DBA
7    Default Temporary Tablespace
8    Resumable Space Allocation
9    List Partitioning
10    Range-list Partitioning
11    External Tables
12    Dynamic Sampling of Optimizer Statistics
13    Dynamic Database Parameters
14    Dynamic Memory Management / Automatic Memory Tuning
15    Server Parameter File
16    Oracle Managed Files
17    Using multiple block sizes
18    DBMS_METADATA
19    DBMS_XPLAN
20    New Data Types
21    MERGE statement
22    Multi-table INSERT