Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB_BLOCK_SIZE on Netware ?
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 Fri May 28 1999 - 08:41:57 CDT