Re: db_block_size and performance

From: Pat Keenan <jpkeenan_at_ix.netcom.com>
Date: Thu, 22 Oct 1998 21:29:15 -0600
Message-ID: <362FF80B.A6C2F7FC@ix.netcom.com>

I was my experience that you would like to have the block size be equal to or some even multiple of whatever the OS block read size is. More efficient reads that way! If you are dealing with lots of little tables or a funny distribution of data in blocks, you might waste some space with the increased block size. Big databases (i.e. warehouses) you should be using 16K or whatever Oracle allows!

Regards,
Pat Keenan
JPK Tech Services, Inc.

Peter Shankey wrote:

> I read that changing the db_block_size could see a increase in speed of
> up to 40%. What are your experinces with changing the db_block_size? I
> realize I will have to re-create the WHOLE db and I am wondering if it
> is really worth the effort. My db_block_size it set to the default of
> 2048. The db is running on solaris 2.5.1

Received on Thu Oct 22 1998 - 22:29:15 CDT