Oracle Tips  by Burleson Consulting

The Data Warehouse Development Life Cycle

Oracle Features for the Data Warehouse
Oracle and CD-ROM media

Now that the tablespace has been packed and copied to cheaper media, we can perform some system tuning tricks to boost performance. Oracle recommends that the data warehouse Remote DBA use the table CACHE option and issue a full-table scan against all small, frequently accessed tables in the read-only tablespace to insure that they have been loaded into the Oracle buffer pool. For small tables defined with the CACHE option, issuing the select count(*) against the table at database startup time will cache the table in the most frequently used portion of Oracle’s data buffer.

SVRMGRL> select count(*) from sales_fact_table;

Now that we understand how read-only tablespaces are used, let’s invalidate this entire discussion by noting that in a few years it will not be necessary to use these techniques since system performance will be so fast that this type if tuning will not significantly influence performance. To illustrate, let’s take a look at how unbelievable speed is being achieved using Oracle data warehouses on 64 bit processors.

---

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