Re: Block Size for OS

From: David Sisk <davesisk_at_ipass.net>
Date: Thu, 15 Jul 1999 18:46:16 -0400
Message-ID: <eotj3.187$w3.359@news.ipass.net>

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 Thu Jul 15 1999 - 17:46:16 CDT