Re: DB_BLOCK_SIZE on Netware ?

Try picturing your oracle engine loading block of 16000 bytes in memory, EVERY block that size....
May be you will change your mind about experts then.

On Fri, 28 May 1999 13:41:57 GMT, Ben <bthomas_at_trey-industries.com> wrote:

>Oracle bypasses the Netware file system in a sense. It accesses what it
>needs directly. Therefore the recommentdation has always been, use
>NETWARE 64k block size so as to use LESS Netware memory.
>
>The database block size depends on the size of the record in the tables
>you have. You could spend the rest of your life calculating such
>mathematical questions. :) I was told that 16K db_block_size works well
>for most people. I may be corrected here shortly by a REAL expert. :)
>
>good luck
>Ben
>
>
>
>Jarosław Palka wrote:
>>
>> What DB_BLOCK_SIZE should be set on Netware 5 (4.x)?
>> Netware block size is 64 kB and Oracle recommends turn off subalocation
>> on database volume, so Netware block size never won't be smaller. Does
>> it mean that Oracle db_block_size should be set to 64kB ?
>>
>> --
>> ****************************************************
>> * Jaroslaw Palka <jarek_at_kamsoft.com.pl> *
>> * P.I. KAMSOFT, Katowice POLAND *
>> ****************************************************
Received on Mon May 31 1999 - 16:08:40 CDT