Re: Block Size Question

I don't know if it was ever documented anywhere but I've heard it in a variety of scuttlebutt channels but the following was confirmed by my own experience.

When Oracle 7.3 came out it became apparent that using the default block size (2k) should no longer be used. In the organization where I working at the time we built two databases on the same machine. One had 2K blocks and the other had 4K blocks. Both databases were loaded with the same data and indexes from an export file. Our tests showed that the performance of the 4K database was anywhere from 25% to +50% of the 2K database. Of all the tests we performed we did not find a single test where the 2K database out-performed the 4K database.

Ken

tmgn wrote:

> Oracle's Default Block Size is 2K irrespective of Solaris Block Size.
> You should be sizing the Oracle Block Size depending upon U'r Application
> viz OLTP, OLAP etc .
>
> I would suggest a Block Size of 2K or 4K for OLTP and 4K or 8K or even 16K
> for DataWarehousing Applications and not decide based on the OS Filesystem
> Block Size..
>
> -Thiru
>
>
Received on Fri Jul 09 1999 - 06:56:07 CDT