Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Data Warehouse and DB Block Buffers

Data Warehouse and DB Block Buffers

From: <rad_at_earthling.net>
Date: Mon, 01 Jun 1998 18:02:15 GMT
Message-ID: <6kuqb6$g2e$1@nnrp1.dejanews.com>


I'm a UNIX systems guy, not a DBA. That said..

Does a data warehouse take much advantage of db block buffers? If it is mostly doing full tablescans that are not repetitive from one job to the next, will Oracle be reusing any data in the db block buffers? If a DW does utilize db buffers, how so?

Also, when loading data into a single table on a DW, will the data be placed contigously physically? That is, will full tablescans take advantage of read ahead cache on a high end disk array?

I'm on HPUX 10.2 and Oracle 7.3.4.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 01 1998 - 13:02:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US