Re: DB_BLOCKSIZE

From: Winnie Liu <poohland_at_hotmail.com>
Date: Wed, 15 Jul 1998 22:45:51 -0700
Message-ID: <6ok3qh$gm8@sjx-ixn1.ix.netcom.com>

If you have a bigger block size, Oracle do not have to read in so many blocks when they have to do a physical read. Also, it will decrease the chance of chained-row.

Winnie Liu

John Farley wrote in message <01bdb03a$00cfebe0$2165cccf_at_db-john>...
>I'm on a NT4 platform with Oracle 7.3.4 for Workgroups. The default
>DB_BLOCKSIZE is 2k. Are there any advantages to increasing that to say 4
>or 8k, and if so what are they? Any help would be greatly appreciated.
>
>Thanks,
>
>--John
Received on Thu Jul 16 1998 - 00:45:51 CDT