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 understand that the disk block size has no relavance to the
Oracle db block size on Windows NT.
That being the case, choose the db_block_size that suits your application.
Mark Anderson <anderson_at_mitre.org> wrote:
> 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)?
> >
--
joebrown
@leading.net
Received on Fri Oct 02 1998 - 14:10:00 CDT