9i now has the following that may help a DW:
-- Bitmap Join Indexes
-- MERGE statement (its there, not well documented)
-- List Partitioning
-- External Tables
-- Resumable Space Allocation
I'm sure there's more, but that's what I've found so far. (I only have so
much spare time!)
Caver
Materialized views with query_rewrite enabled. Can work wonders for
long-running reports. This was available in 8i, so not exactly new to 9i,
but something you left off your list.
Jim
__
Jim Hawkins
Oracle Database Administrator
Data Management