Re: Optimal db_block

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Fri, 05 Feb 1999 09:44:28 -0800
Message-ID: <36BB2DFC.A57992A0@us.oracle.com>

There has been some work done by Oracle's System Performance Group on this question. From memory, their determination was that you should almost never use 2K (of course, that's the default!), and there are few situations where a block size less than 8K is valuable. As you say, larger sizes still are good for DSS.

HTH. Pete

Terry Ball wrote:

> 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?

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Fri Feb 05 1999 - 11:44:28 CST

Re: Optimal db_block_size