Re: Block Size and Checkpoints (NT)

From: Baolin Ren <bren_at_microsoft.com>
Date: Fri, 2 Oct 1998 13:05:29 -0400
Message-ID: <6v31b3$it3@news.dns.microsoft.com>

NT block size is 4KB. You should set your DB_BLOCK_SIZE as multiple of OS block size such as 4KB or 8KB on NT. Setting the DB_BLOCK_SIZE to 2KB on NT OS is not a good idea.

Baolin

Mark Anderson wrote in message <3614EA23.884AAE5C_at_mitre.org>...
>It's my understanding that WinNT using NTFS allocates file space in
512-byte blocks,
>regardless of the partition size.
>
>
>
>fatman_at_pobox.com wrote:
>>
>> Could someone help me with block sizes for Oracle 7.3 under NT 4? I'm
>> quite new to both NT and Oracle, so please forgive me if the answers
>> seem obvious.
>>
>> I'm using a 4 GB disk (NTFS). I believe the OS block size (called
>> 'cluster' I think) for disks of that size under NT is 4 kB, but I'm not
>> sure. How do I find out?
>>
>> The recommended value for Oracle's DB_BLOCK_SIZE parameter for small
>> databases is 2 kB. Now I wonder, is it really ok to use a smaller DB
>> block size than the actual OS block size (in my case presumably 4 kB)?
>>
Received on Fri Oct 02 1998 - 12:05:29 CDT