Re: Data Warehouse and DB Block Buffers

From: <bpage_at_my-dejanews.com>
Date: Mon, 01 Jun 1998 20:04:13 GMT
Message-ID: <6kv1fs$r7l$1@nnrp1.dejanews.com>

In article <6kuqb6$g2e$1_at_nnrp1.dejanews.com>, rad_at_earthling.net wrote:
>
> 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
>

And use parallel query.

-----== 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 - 15:04:13 CDT