Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Block Size for OS
I am not quite sure what you mean by OS block size - cluster size
(partition dependent) or memory page size (OS dependent)?
The cluster size in NT is a function of the size of the partition for
both FAT and NTFS partitions, but can be customized for NTFS. The page
size is 4k for Intel and 8k for Alpha.
Stilian
David Sisk wrote:
>
> Do you mean the O/S block size or the database block size?
>
> For database block size on either, SELECT value FROM v$parameter WHERE name
> = 'db_block_size', or just look in your init.ora file.
>
> The O/S blocksize for NT is 2048 bytes. On most Unices, it's 4096. The
> database block size will be an even multiple of the O/S blocksize.
>
> Regards,
>
> --
> David C. Sisk
> The Unofficial ORACLE on NT site
> http://www.ipass.net/~davesisk/oont.htm
>
> selena.flowers_at_gtri.gatech.edu wrote in message
> <7ml90d$ndn$1_at_nnrp1.deja.com>...
> >Can anyone tell me how to find the Block Size for different Operating
> >Systems?( UNIX and Windows NT)
> >
> >Thanks, Selena
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
Received on Fri Jul 16 1999 - 09:56:51 CDT