Re: What does Oracle think O/S block size is?

From: Mario <msimic_at_alf.tel.hr>
Date: Tue, 14 Jul 1998 11:53:56 +0200
Message-ID: <6ofa2d$dhb@as041.tel.hr>

nasof_at_my-dejanews.com wrote in message <6o969v$a86$1_at_nnrp1.dejanews.com>...
>I think he wanted to find the Operating System Block size from inside
Oracle,
>not the Oracle Block size. These are two different things.
>
>If you are looking for the OS block size I would trust the word of your Sys
>admins, Oracle doesn't store it anywhere. But are you sure Oracle cares
what
>the OS block size is?
>

Oracle doesn't care about OS block size, but for the best performance DB block
size should be multiple of OS block size. For example, if OS block size is 2K
then it would be unwise to set DB block size to 1K. It would be 2K, 4K, 8K ... Received on Tue Jul 14 1998 - 04:53:56 CDT