Re: db_block_size and performance

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Sun, 18 Oct 1998 22:30:04 -0700
Message-ID: <70eifh$199@sjx-ixn3.ix.netcom.com>

It will increase the I/O of your query. If you have contention on the I/O right now, of course. It would definitely help if you are doing a lot of full table scan.

Winnie

Peter Shankey wrote in message <362A8E46.E06D588E_at_charlestoncounty.org>...
>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 Mon Oct 19 1998 - 00:30:04 CDT