ORACLE 9i New Features

Bring me home...

In addtion to the features already discussed in the data warehousing section,
here are some more 9i features that I found interesting...

SQL and PL/SQL

• Merge, don't go the update/insert route
• The more user-friendly joins...
• Index by Varchar2 associative array

More initialization parameters for you...

• Memory related init parameters
• UNDO related init parameters

Memory management enhancement

• Dynamic SGA

You will like these views...

• v$segment_statistics
• v$undostat
• v$session_longops

Storage management enhancement

• Data Compression
• ASSM(Automatic Segment Space Management)
• AUM(Automatic Undo Management)
• LMT(Locally Managed Tablespace) for SYSTEM

Index management enhancement

• Bitmap Join Index
• Index monitoring
• Rebuilding index