Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Aggregating Data For The Oracle Warehouse
Summary
Now that you have a fundamental understanding of OLAP and do-it-yourself data aggregation techniques, we are ready to dive into the internals of the Oracle database. Subsequent chapters will take a close look at how to tune the Oracle architecture for data warehousing and the issues involved with managing Oracle locks and tuning Oracle SQL. Even if you are an experienced Oracle professional, I suggest that you take the time to read these chapters. The information is directly related to data warehousing, and some of the tuning tips are not intuitive.

SQL utilities to detect and correct row chaining, see Chapter 10, Oracle Data Warehouse Utilities.

---

This is an excerpt from "High Performance Data Warehousing". To learn more about Oracle, try "Oracle Tuning: The Definitive Reference", by Donald K. Burleson.  You can buy it direct from the publisher at 30% off here:
http://www.rampant-books.com/book_1002_oracle_tuning_definitive_reference_2nd_ed.htm