Re: Optimal db_block_size

A lot depends on what the database is being used for and/or the size of the tables. If you are using your database for Decsion Support or as a DataWarehouse, a larger block size is probably better. But if it is for OLTP, the smaller block size usually better.

If you have tables that have a lot of chaining because the data can not fit in one block, then a larger block size is better.

Terry Ball
Sr. DBA, CSG Systems

Peter Laursen wrote:

> Whats is the optimal db_block_size on NT4.0 running Oracle 8.04?
>
> Ive been told never change the default 2k size, however now I hear 8k is
> better? Anyone?
Received on Fri Feb 05 1999 - 08:50:33 CST