Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Block Size and Checkpoints (NT)

Re: Block Size and Checkpoints (NT)

From: Mark Anderson <anderson_at_mitre.org>
Date: Fri, 02 Oct 1998 11:00:58 -0400
Message-ID: <3614EAAA.29B49107@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 - 10:00:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US