Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Block Size and Checkpoints (NT)
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 - 09:58:52 CDT
![]() |
![]() |