Oracle 10g warehouse features

The list includes these Oracle 10g warehouse features:
Materialized Views — The Oracles materialized views (MV) feature uses Oracle replication to allow you to pre-summarize and pre-join tables.
Automated Workload Repository — The AWR is a critical component for data warehouse predictive tools such as the dbms_advisor package.
Multiple Blocksizes — All data warehouse indexes that are accessed via range scans and Oracle objects that must be accessed via full-table, or full-index, scans should be in a 32k blocksize.
STAR query optimization — The Oracle 10g STAR query features make it easy to make complex DSS queries run at super-fast speeds.
Multi-level partitioning of tables and indexes — Oracle now has multi-level intelligent partitioning methods that allow Oracle to store data in a precise scheme.
Asynchronous Change Data Capture — Change data capture allows incremental extraction, so only changed data to be extracted easily.
Oracle Streams — Streams-based feed mechanisms can capture the necessary data changes from the operational database and send it to the destination data warehouse.
Read-only Tablespaces — If you have a time-series warehouse in which information eventually becomes static, using tablespace partitions and marking the older tablespaces as read-only can greatly improve performance.
Automatic Storage Management (ASM) — The revolutionary new method for managing the disk I/O subsystem removes the tedious and time-consuming chore of I/O load balancing and disk management.
Advanced Data Buffer Management — Using Oracle 10g’s multiple block sizes and KEEP pool, you can preassign warehouse objects to separate data buffers and ensure that your working set of frequently-referenced data is always cached.